Filter mail subject question

Hey everyone,
I have the filter down below for get outlook mail messages:
“@SQL=(”“urn:schemas:httpmail:subject”" LIKE ‘%"&“Purchase Orders” &"%’)"

Is there another option then “like” because like works like a contains, so it will open the reply mails(re:Purchase Orders) as well. I need something else to use, it would be perfect if it also ignores case, so I can also get PURCHASE ORDERS etc.

Hello,

you can find all the syntax you can use in the following documentation
Chapter 11: Searching Outlook Data | Microsoft Docs

I think the one you are using is DASL, and from the documentation it explains the following:

  • Note that when you filter on the Subject property, prefixes such as RE: and FW: are ignored.
  • The following = restriction:
    string filter = “@SQL=”+"""+“urn:schemas:httpmail:subject” + “”" + " = ‘question’";
    will return the following results:
    Question RE: Question

So in fact it already is case insensitive and it’s not possible to retrieve only the ones without RE:.
Maybe you can try with another query language and see if it works.

1 Like