I need to create a reference qualifier to remove null result

[Cherly]

I need to create a reference qualifier to  block item that  the user(u_user) is  empty.  I am very know i this and can't seem to get it to worki. 

[johnfeist]

Hi Cherly,

If you are looking to set up a reference qualifier on the table, just use simple and then select User | Is Not Empty.  The easiest way to convert that into something for a script is to invoke it on the list view.  From there, right click on the rightmost end of the filter.  Click on copy query.  You can then go to your scripting and make that an encoded query:

var myTable = new GlideRecord("<table name>");
myTable.addEncodedQuery("u_userISNOTEMPTY");
// add anything else you need to query the record

Hope that helps.

:{)

Helpful and Correct tags are appreciated and help others to find information faster

[Cherly]

it on a lookup selectbox since i dont have the filter option.

[Hitoshi Ozawa · Accepted solution]

Hi Cherly,

In the "Type Specification" tab, set "Use reference qualifier" as "Advanced".

In the "Reference qualifier", set as below to not list records where u_user is empty.

javascript: "u_userISNOTEMPTY";