OData : Operands of logical operator 'AND' are not valid

2
votes

I am trying to call an OData report with the following URL :

https://myXXXXX.sapbydesign.com/sap/byd/odata/crm_customerinvoicing_analytics.svc/RPCRMCIVIB_Q0001QueryResults?&$filter=PARA_CAL_DAY%20gt%20datetime%272017-01-01T00:00:00.000%27%20and%20PARA_CAL_DAY%20lt%20datetime%272017-01-02T00:00:00.000%27&$skip=0

As you can see I am trying to use the and operator inside a filter property but I received the error in the title of this post.

I tried :

$filter=(MyFilter1) and (MyFilter2)
$filter=(MyFilter1 and MyFilter2)
$filter=(MyFilter1 AND MyFilter2)

But I still have an error. Any ideas ?

1
filterodatasap-cloud-platform
Does it work if you just use one of the filters? – norbip
what is the spec version of the OData service? V2? V4? – Boghyon Hoffmann

1 Answers

1
votes

Just in case someone stumbles upon this thread first, this is error occurs when the same field is used to filter the dataset twice (greater than+less than, greater than+less than or equal to, etc) SAP issue report