Bot should fetch mail whose subject like "RPA Process started " or "RPA process started" I used this "@SQL=""urn:schemas:httpmail:subject"" like 'RPA%Started%'" but it failed

Help Studio
, ,
1

Bot should fetch mail whose subject like “RPA Process started " or “RPA process started” I used this “@SQL=”“urn:schemas:httpmail:subject”” like ‘RPA%Started%’" but it failed

2

Hi @Sakhare_Ankita

Try this

"@SQL=""urn:schemas:httpmail:subject"" LIKE '%RPA Process started%' OR ""urn:schemas:httpmail:subject"" LIKE '%RPA process started%'"

Regards,

3

I’ll check but.Isn’t it will take all subject which have RPA Process started . I just want it should Start with RPA and check started is there also

4

@Sakhare_Ankita

Can you try this

"@SQL=""urn:schemas:httpmail:subject"" LIKE 'RPA%Process started%' OR ""urn:schemas:httpmail:subject"" LIKE 'RPA%process started%'"
5

Got Solution :"
@SQL=““urn:schemas:httpmail:subject”” LIKE ‘RPA%’ AND ““urn:schemas:httpmail:subject”” LIKE ‘%started%’" OR ““urn:schemas:httpmail:subject”” LIKE ‘RPA%’ AND"“urn:schemas:httpmail:subject”" LIKE ‘%Started%’"

6

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