Outlook Email Filter

Help Studio
#1

Hello,

I am filtering the subject by using below statement in get outlook mail message activity.

“@SQL=urn:schemas:httpmail:subject LIKE ‘%Invoice%’”. This is working.

If i wanted to check for “INVOICE” along with Invoice or invoice then how one ca n check.

#2

Are you sure it is not catching all of them already? Not sure the filtering is case specific. Did you test it? Otherwise you could try:
@SQL=urn:schemas:httpmail:subject LIKE ‘%Invoice% OR urn:schemas:httpmail:subject LIKE ‘%INVOICE% OR …etc.