Help with Encoded query in flow designer

[Snowman15]

Hi everyone,

I'm working on a Flow Designer script in ServiceNow where I build an encoded query to filter records. One of the conditions I need is to exclude any records on the sys_email table where the recipients field  contains @hotmail 

I’ve tried the following variations but none of these seem to work:

• recipientsNOTLIKE@hotmail
• recipientsNOT LIKE@hotmail
• recipientsNOTLIKEhotmail
• recipientsDOESNOTCONTAIN@hotmail
• recipientsDOES NOT CONTAIN@hotmail

If I remove that condition, flow works correctly. Any idea what's happening?

Here is the full script:

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;

[Pau Besalu]

What kind of error do you get?

I tested it with 'recipientsNOT LIKE@hotmail' and it worked fine.

[Snowman15]

@Pau Besalu have you tried it with all the other conditions I shared above? I am getting 0 results as soon as I add this condition 'recipientsNOT LIKE@hotmail'

[Pau Besalu]

No, I removed the 'u_accontISEMPTY' condition because it is a custom field and I also removed this conditions because in my instance I don't have a table with this internal name:

'target_tableSTARTSWITHsn_customerservice',

'target_tableENDSWITHcase', 

You could also create the encodedQuery going to sys_email.list and create the filter and run and then with right click on the filter you can "Copy query".

[Snowman15]

@Pau Besalu It worked as you have not included other conditions. There is an issue when putting all conditions together apparently.