Lookup Select Box - Reference Qualifier

StefanSrba
Tera Contributor

Hi, 

 

I am having dificulty understanding how to user Reference Qualifier on Lookup Select Box.

Things that I have searched for always asks to set Reference Qualifier to 'advanced' even thou that is option only for Reference type of field.

 

And now that I have an Reference Qualifier that has to be 'advance' I would like to know how to write the RQ itself.

This was created based on other question that people helped me with
javascript:
'u_detailed_descriptionLIKE'+current.variables.application_description+
'^u_operating_system='+current.variables.u_operating_system+
'^NQu_operating_system='+current.variables.u_operating_system+
'^u_category='+current.variables.category+
'^u_sub_category='+current.variables.subcategory;

But I would like to have better control on this, to trigger one part of RQ 

'u_detailed_descriptionLIKE'+current.variables.application_description+
'^u_operating_system='+current.variables.u_operating_system

only if application_description has some text in it and if not to go the other route.

 

Is this even possible with RQ or is this something that should be done with Catalog Client Script?

1 ACCEPTED SOLUTION

@StefanSrba 

yes you can write normal javascript server side code.

ensure the query is set before you use query; as the last line in your script

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

View solution in original post

6 REPLIES 6

@StefanSrba 

Hope you are doing good.

Did my reply answer your question?

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

HugoFirst
Kilo Sage

I do something similar in a List Colector on the server table.  I use the javascript tag to start things of with an IF... else clause:

Here's the RQ:
javascript:if (current.variables.application_instance == '' ) { "fqdnSTARTSWITHzzzz" } else {"install_status=1^u_application_instance=" + current.variables.application_instance};