An error occurs on combining two filter conditions for getting outlook message

Hi,all

When I add a single condition to the “filter” in the “Get Outlook Mail Message” Activity, everything works fine.

"@SQL=""urn:schemas:httpmail:subject"" like '%"& str_sbuject &"%'"

" [ReceivedTime]>'" +Now.AddDays(-1).ToShortDateString+ "'"

However, when I combine these conditons together, the program shows that the condition cannot be analyzed.

"@SQL=""urn:schemas:httpmail:subject"" like '%"& str_sbuject &"%' And [ReceivedTime]>'" + Now.AddDays(-1).ToShortDateString+ "'"

I’m uncertain of the reason, but I require your help. I am very grateful for it.

Studio Pro Version: 2020.4.3

Regards,

HI,

Unfortunately we cannot use JET style query and DASL style query at same time.
So How about using only DASL query, for example?

"@SQL=  urn:schemas:httpmail:subject LIKE '%target word%' AND urn:schemas:httpmail:datereceived >= '2024/8/22 0:00'"

Regards,

1 Like

Hi,

Great!It works.

I am deeply grateful for your assistance in resolving my issue once more. My thanks are beyond words.

Regards,

1 Like

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