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

Question

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 ?

Does it work if you just use one of the filters? – norbip Oct 17 '18 at 18:36 — norbip, Oct 17 '18 at 18:36
what is the spec version of the OData service? V2? V4? – Boghyon Hoffmann Aug 10 '21 at 15:07 — Boghyon Hoffmann, Aug 10 '21 at 15:07

score 1 · Answer 1 · answered Apr 05 '19 at 16:40

1

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

answered Apr 05 '19 at 16:40

D Anderson

11
1

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

1 Answers1