Power Platform Community Forum Thread Details

Hello everyone, really need someone to look at this query because I can't see what's wrong here.

I am using the following List Rows OData filter on the Dataverse table Opportunities:

statecode eq 0 and hx_orderid eq null and (hx_orderstatus ne '1100' or hx_orderstatus ne '1110' or hx_orderstatus ne '1120')

Both hx_orderid and hx_orderstatus are text fields and I want to list every row where:
Active,

hx_orderid is empty,

and hx_orderstatus should not equal 1100, 1110 or 1120.

But it ignores the last part and lists these orderstatus rows.

Categories:

OData filter with multiple AND and OR