Community
Showing results for 
Search instead for 
Do you mean 
Reply

Another weird result with OData.

Highlighted
Copper Contributor
Posts: 205
Country: Netherlands

Another weird result with OData.

Example (4 ORs):

 

$filter=(businessAddress/line1 eq null or businessAddress/city eq null or customFields/gemeente eq null or businessAddress/state eq null)

Results: 22 (expected when doing this lookup in Act! : 228)

 

Now I remove the first OR! (3 ORs left)

 

$filter=(businessAddress/city eq null or customFields/gemeente eq null or businessAddress/state eq null)
Results: 2 (expected when doing this lookup in Act! : 228)

 

Now I again remove the first OR (2 ORs left)


$filter=(customFields/gemeente eq null or businessAddress/state eq null)
Results: 228 (as expected).

 

What am I doing wrong in the first two? is there something broken in businessAddress filtering?

Greetings,

ACT Certified Consultants
TendenZ
the Netherlands