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:42:15 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

Athiban_Mahamathi — Mon, 10 Feb 2025 14:54:27 GMT

@MobashirMd14 - I am not sure what made it suddenly not working. Try to debug the query by executing it in parts to identify the issue and fix it accordingly.

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

naveed_raza — Mon, 01 Dec 2025 13:01:17 GMT

@MobashirMd14 - first try with only subject line and see if its working or not , then you can act based on that