Mirjan created OLINGO-1213:
------------------------------

             Summary: Odata @filter=startswith() dosen'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)

Reply via email to