how to validate glide_list in encoded query

[jobin1]

Hi All,

How to validate field type  glide_list data in an encoded query tried below but not working.

var css_assign_rule = new GlideRecord("u_css_assignment_rules");

//css_assign_rule.addEncodedQuery('u_active=true^u_override=true^u_company=' + compsysid + '^u_client_mailbox_addressp_mappingCONTAINS' + mailbox);

css_assign_rule.addEncodedQuery('u_active=true^u_override=true^u_company=' + compsysid + '^u_client_mailbox_addressp_mappingLIKE' + mailbox);

[Siddhesh Gawade]

Hello @jobin1 ,

Your query seems to be correct, In this you are trying to add compsysid  and mailbox values. 

So once confirm that compsysid would be the copany record sys_id and mailbox should be an ( , ) sepated array.

can you please let me know what you are trying to do?

Kindly mark the answer ✔️Correct or Helpful ✔️If it addresses your concern

Regards,

Siddhesh

[jobin1]

yes that's correct.And till u_active=true^u_override=true^u_company=' + compsysid +   query is working

[Siddhesh Gawade]

So what is the value of mailbox varible? Can you show me the if this isn't resolved yet.

[ersureshbe]

Hi, I suggest to check the field name (database value) and export xml file for this entry & map the field name , value. To troubleshoot the issue try to split value like css_assign_rule .addQuery('u_active', 'true'); css_assign_rule .addQuery('u_company', compsysid);