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]

@Joe Taylor I believe there is a misunderstanding.. reference qualifier is a method how you qualify records to be selectable...

If this is a reference to User table - for example - then the RQ can be set that all active users their location isn't in the US are selectable..

If you want to apply the order of your custom field, you should do it in the attribute and not reference qualifier. Also, the Order field is ineteger, not reference so it doesn't even use that...

To change the order please go to attribute:

[GlideFather]

oh missing screenshot from above:

go to sys_dictionary table and find your custom field, and add the attribute as following:

ref_ac_order_by=u_order

Where are you trying to get it ordered by that field? Please share screenshots...

[GlideFather]

Hi @Joe Taylor,

do you have any progress? please share a feedback if you solved it or need mot things to do

[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 · Accepted solution]

Hi @Joe Taylor 

what you accepted as solution is exactly what I replied above:

https://www.servicenow.com/community/itsm-forum/reference-qualifier-not-working/m-p/3352395/highligh...

and 

https://www.servicenow.com/community/itsm-forum/reference-qualifier-not-working/m-p/3352375/highligh...

I'm really glad that it solved your issue, but now it'd be fair to accept my replies as solution, not your own... you basically did what I've been saying the whole time. :))

Thank you for considering to accept my solution. If not, then I'm happy you solved your issue but again it's not fair and actually against the Community's code of conduct.