Some PDIs are currently unavailable, and PDI actions are paused. View the latest updates here. Read More

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?

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?