Hi Team, I'm getting error on this query "@SQL=urn:schemas:httpmail:subject LIKE '%Testing%' AND [ReceivedTime] >= '02/23/2018' AND [ReceivedTime] <= '02/25/2018'"

Help Activities
, ,
1

“@SQL=urn:schemas:httpmail:subject LIKE ‘%Testing%’ AND [ReceivedTime] >= ‘02/23/2018’ AND [ReceivedTime] <= ‘02/25/2018’”
image
Thanks

2

have a look there:
https://docs.uipath.com/activities/other/latest/productivity/get-outlook-mail-messages

we do surround some parts

grafik
grafik1098×211 25.8 KB

3

all three condition is not working at a time when i run separately then its working

4

Maybe you can tell more specifically what is not working (compiling issue, not expected filter result)

What was done in detail (screenshot from the use statement)?

5

23.4.1+Branch.master.Sha.43c76fe6d960fdc239be3af93d0fd47b8ca81224

Source: Get Outlook Mail Messages

Message: Cannot parse condition. Error at “@SQL=urn:schemas:httpmail:subject LIKE '…”.

Exception Type: System.Runtime.InteropServices.COMException

System.Runtime.InteropServices.COMException: Cannot parse condition. Error at “@SQL=urn:schemas:httpmail:subject LIKE '…”. at Microsoft.Office.Interop.Outlook._Items.Find(String Filter)
at UiPath.Mail.OutlookAPI.GetMessages(MAPIFolder inboxFolder, Int32 count, MailFilterVariant filterVariant, EOrderByDate orderByDate, Boolean onlyUnread, Boolean markAsRead, Boolean getAttachments, CancellationToken cancellationToken)
at UiPath.Mail.OutlookAPI.GetMessages(String account, String folderMail, Int32 count, MailFilterVariant filter, EOrderByDate orderByDate, Boolean onlyUnread, Boolean markAsRead, Boolean getAttachments, CancellationToken cancellationToken)
at UiPath.Mail.Outlook.Activities.GetOutlookMailMessages.<>c__DisplayClass40_0.b__0()
at System.Threading.Tasks.Task1.InnerInvoke() at System.Threading.Tasks.Task.<>c.<.cctor>b__272_0(Object obj) at System.Threading.ExecutionContext.RunFromThreadPoolDispatchLoop(Thread threadPoolThread, ExecutionContext executionContext, ContextCallback callback, Object state) --- End of stack trace from previous location --- at System.Threading.ExecutionContext.RunFromThreadPoolDispatchLoop(Thread threadPoolThread, ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread) --- End of stack trace from previous location --- at UiPath.Mail.Activities.Extensions.TaskExtensions.TimeoutAfter[TResult](Task1 task, Int32 timeoutMs)
at UiPath.Mail.Activities.GetMailActivity.ExecuteAsync(AsyncCodeActivityContext context, CancellationToken cancellationToken)
at UiPath.Shared.Activities.AsyncTaskCodeActivityImplementation.EndExecute(AsyncCodeActivityContext context, IAsyncResult result)
at UiPath.Shared.Activities.AsyncTaskCodeActivity.EndExecute(AsyncCodeActivityContext context, IAsyncResult result)
at UiPath.Mail.Activities.BaseMailAsyncActivity.EndExecute(AsyncCodeActivityContext context, IAsyncResult result)
at System.Activities.AsyncCodeActivity.System.Activities.IAsyncCodeActivity.FinishExecution(AsyncCodeActivityContext context, IAsyncResult result)
at System.Activities.AsyncCodeActivity.CompleteAsyncCodeActivityData.CompleteAsyncCodeActivityWorkItem.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager)

6

better to share with us also the requested screenshot

grafik
grafik840×140 8.91 KB

vs

grafik

can be checked