@SQL filtering on Outlook mail messages - AND/ORs

[Sheri]

Hi team, I am trying to filter Outlook mail messages down to:

Today’s date only
AND
including a subject of A, B OR C.

Here’s my filter:

“@SQL= %today(urn:schemas:httpmail:datereceived)% AND urn:schemas:httpmail:subject like ‘%A%’ or urn:schemas:httpmail:subject like ‘%B%’ or urn:schemas:httpmail:subject like ‘%C%’”

Unfortunately, it’s still sweeping emails from older dates into the collection. I assume it’s a problem with my ANDs and ORs.

Any ideas?

[Sheri]

Can confirm a colleague found the solution. Hope this helps someone else in the future!

“@SQL=((urn:schemas:httpmail:subject LIKE ‘%A%’) OR (urn:schemas:httpmail:subject LIKE ‘%B%’) OR (urn:schemas:httpmail:subject LIKE ‘%C%’)) AND %today(urn:schemas:httpmail:datereceived)%”