Reference Qualifier not working

[Joe Taylor]

Why isn't this reference qualifier not working?

javascript:'sys_id!=NULL^ORDERBYu_order'

[Joe Taylor · Accepted solution]

Thanks to everyone for their suggestions.

I finally got this working.

I changed it back to a "Simple" Reference Qualier.

Then I added "ref_ac_order_by=u_order" in the Variable attribute field.

[GlideFather]

Hi @Joe Taylor 

you can remove the sorting and keep it as "javascript:'sys_id!=NULL". If your reference qualifier is so simple you can use the condition builder...

Please provide more details... What does it return? and what do you want to return it? :))

EDIT:

Note: javascript + colon (:) has transcript to javascript: 

it's a problem of this Community, not ServiceNow as such but be careful if copy pasting back to ServiceNow 

[GlideFather]

@Joe Taylor what's your ambition?

Your current ref qualifier could be either:

or

But records whose sys ID is NULL means they don't exist so I don't think your condition could be EVER valid... it will always evaluate all the records in the referencing table.

Please review the condition or explain your requirement and I'll help you build it better, the current condition doesn't make any sense

[Joe Taylor]

Here's my table.

It only has 2 custom columns.

I just want to sort by Order in my reference qualifier.  That's it.  I've used this before without any issues:

javascript: 'ORDERBYu_order';

[Joe Taylor]