Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-21-2025 05:45 AM
@Snowman15
try this once -> use wild card along with NOT LIKE operator
var gdt = new GlideDateTime();
var ms = 65 * 60 * 1000; // 65 minutes in milliseconds
gdt.add(-ms); // subtract 65 minutes
var encodedQuery = [
'u_accountISEMPTY',
'mailbox=sent',
'sys_created_on>=' + gdt.getValue(),
'target_tableSTARTSWITHsn_customerservice',
'target_tableENDSWITHcase',
'recipientsNOT LIKE%@hotmail%'
].join('^');
return encodedQuery;
💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏
Regards,
Ankur
✨ Certified Technical Architect || ✨ 10x ServiceNow MVP || ✨ ServiceNow Community Leader
Ankur
✨ Certified Technical Architect || ✨ 10x ServiceNow MVP || ✨ ServiceNow Community Leader