cancel
Showing results for 
Search instead for 
Did you mean: 

XSOData filter is not working

former_member184867
Active Contributor
0 Kudos

Hello Experts,

I am using XSOData in my UI5 application.The metadata of my OData service is

<EntityType Name="ContentType">

<Key>

<PropertyRef Name="CLIENT_ID"/>

<PropertyRef Name="DATS"/>

<PropertyRef Name="TIMS"/>

</Key>

<Property Name="CLIENT_ID" Type="Edm.String" Nullable="false" MaxLength="40"/>

<Property Name="DATS" Type="Edm.DateTime" Nullable="false"/>

<Property Name="TIMS" Type="Edm.Time" Nullable="false"/>

<Property Name="CONTENT" Type="Edm.Decimal" Precision="16"/>

</EntityType>


As per odata filters I am firing following URIs

1. Filter based on DATS field:

zzzzzzzzzzzzz/odata/mqttmaster.xsodata/Content?$filter=DATS%20EQ%20datetime'2013-10-09T00:00:00.0000...

2.Filter on CLIENT_ID field.

xxxxxxxxxxxxxxxx/odata/mqttmaster.xsodata/Content?$filter=CLIENT_ID%20EQ%20'XXX'

Both gives me error '

<message xml:lang="en-US">Illegal operation 'EQ' at position 10.</message>

'

I think I am using correct filter notation as per OData standard. What can be the cause of error???

Does HANA XSODATA support filters?

Regards,

Atanu

Accepted Solutions (1)

Accepted Solutions (1)

thomas_jung
Developer Advocate
Developer Advocate
0 Kudos

Its lower case: eq, not upper: EQ. I just tested and if I use EQ I get the same error.  If I use eq, it works fine.

Answers (0)