Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Order by not working in list collector?

rahul16
Giga Guru

What is wrong with the list collector I am unable to show data on the portal form with order by u_order field.

 

rahul16_0-1669112732981.png

 

variable attribute - ref_qual_elements=category,ref_ac_order_by=u_order,ref_auto_completer=AJAXTableCompleter

Reference qualifier - javascript: 'u_inactive=false^u_type=subcategory^u_dependent =' + current.variables.category+'^u_catalog_item='+(current.cat_item.sys_id||current.request_item.cat_item.sys_id);

 

I am getting the data based on the category selected. but order is not working 

 

12 REPLIES 12

But for category it's working fine i am using same lookup

Where are you using order by category in the qualifier?


Raghav
MVP 2023
LinkedIn

javascript: var query; if (!current.variables.application) query = 'u_type=category^ORDERBYu_order^u_inactive=false^u_catalog_item='+(current.cat_item.sys_id||current.request_item.cat_item.sys_id); else query = 'u_type=category^ORDERBYu_order^u_inactive=false^u_catalog_item='+(current.cat_item.sys_id||current.request_item.cat_item.sys_id)+'^u_application='+current.variables.application; query;

 

in variable attributes - ref_qual_elements=application

ORDERBY will not work here, as per you post you stated it is working for category, where have you put ORDERBY category?


Raghav
MVP 2023
LinkedIn