Get Outlook Mail Messages SQL Filter Issues


I am trying to filter outlook mail messages by received today and by two separate subjects.

Currently I have this:

“@SQL=%today(urn:schemas:httpmail:datereceived)%”+ “urn:schemas:httpmail:subject” + “”“” + " Like ‘%String1%’ Or “+ “””" + “urn:schemas:httpmail:subject” + “”“” + " Like ‘%String2%’"

This does not work. Can anyone see where I am going wrong?

Hello @b.forbes,

Kindly check here.


Hi, I’ve had a look at that document and it doesn’t contain anything about the sql filter.

Also tried this:

“@SQL=%today(urn:schemas:httpmail:datereceived)% AND urn:schemas:httpmail:subject LIKE ’%String1%’ OR urn:schemas:httpmail:subject LIKE ’%String2%'”

Hello @b.forbes ,

Please check this thread :


Found what I needed in there. Thank you.

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.