olingo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mirjan (JIRA)" <j...@apache.org>
Subject [jira] [Created] (OLINGO-1213) Odata @filter=startswith() dosen't work
Date Fri, 08 Dec 2017 12:00:00 GMT
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)

Mime
View raw message