Get Outlook Mail Message - "@SQL=urn:schemas:httpmail:subject - strict on variable

Help Activities
, ,
1

Hello,

I am trying to filter out emails from outlook based on subject with a variable. Currently i use “@SQL=urn:schemas:httpmail:subject LIKE '%”+ mailSubject + “%'” but this is relative due to the LIKE part of it. I would like to search strictly based on the specific subject ( = / == / is) . I tried “@SQL=urn:schemas:httpmail:subject ='%”+ mailSubject + “%'” but nothing came up , no filtering.

any ideas?

2

Hi,

Can you try the following?

"[Subject] = '"+mailSubject +"'"

There are some samples in the following document.

Regards,

3

Hello,

I am trying to filter out emails from outlook based on subject with a variable. Currently i use “@SQL=urn:schemas:httpmail:subject LIKE '%”+ mailSubject + “%’” but this is relative due to the LIKE part of it. I would like to search strictly based on the specific subject ( = / == / is) . I tried “@SQL=urn:schemas:httpmail:subject =’%”+ mailSubject + “%’” but nothing came up , no filtering.

any ideas?

4

morning and thanks for your reply, i did try with what you recommended previously and it does not filter,the only one i found is the urnschema

5

Bump. I’m struggling with the same issue and cannot find a way to apply specific subject filter without using “Like” and “%” which is not a solution