On Nov 1, 2014 8:35 AM, "Chandan V.A (JIRA)" <[email protected]> wrote: > > > [ https://issues.apache.org/jira/browse/OLINGO-451?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14193008#comment-14193008 ] > > Chandan V.A commented on OLINGO-451: > ------------------------------------ > > Hi Dhaval, > There is no function in JPQL that directly can be mapped to startswith and endswith. Hence they have to be computed using functions like LOCATE. > > For example startswith should be computed using the function LOCATE(SEARCHSTRING, SEARCHEDSTRING, 1) = 1 and endswith should be computed using function LOCATE(SEARCHSTRING, SEARCHEDSTRING, LENGTH(SEARCHSTRING) - LENGTH(SEARCHEDSTRING)) = (LENGTH(SEARCHSTRING) - LENGTH(SEARCHEDSTRING))
What about using LIKE? > > I believe this should solve the use case. > > Regards > Chandan > > > Startswith and endswith is not supported by odata2 > > -------------------------------------------------- > > > > Key: OLINGO-451 > > URL: https://issues.apache.org/jira/browse/OLINGO-451 > > Project: Olingo > > Issue Type: New Feature > > Components: odata2-jpa > > Reporter: dhaval gupta > > Assignee: Chandan V.A > > Priority: Minor > > > > Odata2 version is not supporting some functions like startswith , endswith, etc which is supported by the odata protocol. While querying the odata2 olingo built service using Linqpad I am getting some exception. I am using odata2 with jpa. > > > > -- > This message was sent by Atlassian JIRA > (v6.3.4#6332)
