OData filter query 4 conditions

[tchong95]

Hi, I have to get items from a sharepoint list that is in the condition of the following item

1. Both Column 1 & 2 (Choice) must be None(one of my sharerpoint choice if someone misclick) or null

2. If one of the column 1 & 2 contains choices other than None, that item will not be selected.

Column 1	Column 2
Null/None	Null/None

How do I write a OR statement in ODATA filter?

the following screenshot is some attempts i did

Reasonfordelay_x0028_QELinterven eq 'None' or Reasonfordelay_x0028_QELinterven eq null

[abm]

Hi @tchong95 

Your Reasonfordelay_x0028_QELinterven eq 'None' or Reasonfordelay_x0028_QELinterven eq null look right to me. What's your other column name called. You need to mix with an and operator for other with similar conditions.

[tchong95]

do I have to use bracket for ODATA?

For example,

(condition 1) and (condition 2 )

[abm]

Yes you need brackets.

Thanks