How to create query for sys_id "is not in" for the reference field

[Shruti D]

I want to apply a filter on custom table in which the related item field is a ref type field. By using this field I want to check multiple sys_ids with "Not In" query. How can I apply the filter?

[Rushi Savarkar · Accepted solution]

Hello @Shruti

Hope you are doing well!

Please find below the code and apply it in your encodedQuery: 

addEncodedQuery("ref_field_nameNOT IN"+array_name); //if there are multiple sys_ids

 Thank you!

[Mark Manders]

You will need to add them separately (fyi: that sysid is probably not the display value, so you need to select the display value of the referenced records and than just add 'is not .... AND is not .... AND is not ...'