Get Outlook Mail Messages SQL Filter Issues

Help Studio
,
1

Hi,

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?

2

Hello @b.forbes,

Kindly check here.

Regards.
Ömer

3

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

4

Also tried this:

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

5

Hello @b.forbes ,

Please check this thread :

Regards,
Rohith

6

Found what I needed in there. Thank you.

1 Like
7

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