[
https://issues.apache.org/jira/browse/OLINGO-1213?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Mirjan updated OLINGO-1213:
---------------------------
Summary: Odata @filter=startswith() doesn't work (was: Odata
@filter=startswith() dosen't work)
> Odata @filter=startswith() doesn't work
> ---------------------------------------
>
> Key: OLINGO-1213
> URL: https://issues.apache.org/jira/browse/OLINGO-1213
> Project: Olingo
> Issue Type: Question
> Components: odata2-core
> Affects Versions: V2 2.0.9
> Reporter: Mirjan
>
> Hi !
> I am using olingo in my spring boot project with maven dpendency :
> <dependency>
> <groupId>org.apache.olingo</groupId>
> <artifactId>olingo-odata2-jpa-processor-core</artifactId>
> <version>2.0.10</version>
> </dependency>
> when i try this query :
> /api/v1/reports/Users?$filter=startswith(Description,'a') eq true
>
> I got an error : INFO c.a.mdx.report.CustomJpaQueryBuilder.buildQuery -
> Query: SELECT E1 FROM User E1 WHERE (E1.description LIKE CONCAT(?2,'%')
> ESCAPE '\' ) ORDER BY E1.id
> ERROR o.h.e.jdbc.spi.SqlExceptionHelper.logExceptions - You have an error in
> your SQL syntax; check the manual that corresponds to your MariaDB server
> version for the right syntax to use near ''\' order by user0_.id' at line 1
> But i when i try in version <2.0.7> it works fine.
> please can you help me ,beacouse i need to use 2.0.9 version which supports
> filter on expanded properties.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
