topic Re: Not able to read Email with a specific subject line and within a time frame using a SQL query in Product Forum

Not able to read Email with a specific subject line and within a time frame using a SQL query

MobashirMd14 — Wed, 05 Feb 2025 16:04:52 GMT

I am trying to read specific mail from outlook within a specific subject line and within a time frame.

I was using below mentioned query which was working fine until sometime back. But now it has stopped working and the bot is not able to read those specific mails.

@SQL=urn:schemas:httpmail:subject LIKE '%Test123%' AND urn:schemas:httpmail:datereceived >='11 January 2025 00:00' AND urn:schemas:httpmail:datereceived<='05 February 2025 15:20'

Can someone tell if they have experienced a similar issue and how did they resolve it?

Thanks in advance.

Re: Not able to read Email with a specific subject line and within a time frame using a SQL query

SayeedBinAbdullah — Thu, 06 Feb 2025 04:57:14 GMT

Hi @MobashirMd14

I ran the exact same query on my machine and successfully obtained the result.

@SQL=urn:schemas:httpmail:subject LIKE '%Test123%' AND urn:schemas:httpmail:datereceived >='11 January 2025 00:00' AND urn:schemas:httpmail:datereceived<='06 February 2025 15:20'

I recommend closing all open instances of the Outlook application. Once closed, reopen the application before running the mentioned query.

Best Regards,
Sayeed Bin Abdullah

Re: Not able to read Email with a specific subject line and within a time frame using a SQL query

MobashirMd14 — Thu, 06 Feb 2025 15:51:11 GMT

Thanks for the update. I identified the issue, and it was something else.

In this case, bot was not able to get results because mails have been moved to archive folder.

Thanks for your response.

Regards,

Mobashir