UiPath Outlook filter

Help Activities
, ,
1

I am trying to pass the filter in the get outlook message activity.
Please help me to write the syntax of “OR” condition
image

2

Hi @Ritaman_Baral

Try the below syntax:

"@SQL=""urn:schemas:httpmail:subject"" like '%outlook%' Or [Subject] = 'TEST'"

Regards

3

Hi,

I think JET style query and DASL style query cannot mix. How about the following?

"@SQL= ""urn:schemas:httpmail:subject"" like '%outlook%' OR ""urn:schemas:httpmail:subject"" like 'TEST'"

Regards,

4

Hey @Ritaman_Baral
here you can find example:

"@SQL=(urn:schemas:httpmail:subject like '%topic1%' OR urn:schemas:httpmail:subject like '%topic2%')"

5

image
image

6

It worked…“Like” generally points to “contains” in string…What is the syntax for “equals” here?
What is the syntax to filter if contains attachments ?

7

LIKE can be used Equal, StartsWith, EndsWith or Contains by the position of “%”
If there is no %, it will be Equals. If %keyword%, it will be Contains

What is the syntax to filter if contains attachments ?

Can you try the following?

"@SQL= ""urn:schemas:httpmail:hasattachment"" = True"

Regards,

8

Hi @Ritaman_Baral

For the OR condition you can use the syntax given by @Yoichi and to filter with attachments you can use below syntax

"@SQL=""urn:schemas:httpmail:hasattachment"" = True"

Regards

9

pleas esned me some reference from where I can study or get syntaxes

10

Hi,

The following page will help you.

In addition, searching keywords like OUTLOOK, DASL, Attachments etc. in google, bing or GPT also helps you to get specific sample expression.

Regards,

1 Like
11

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