question Order by not working in list collector? in Developer forum

Order by not working in list collector?

rahul16 — Tue, 22 Nov 2022 10:28:36 GMT

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

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

Reference qualifier - javascript&colon; '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

Re: Order by not working in list collector?

Raghav Sharma24 — Tue, 22 Nov 2022 10:36:20 GMT

ref_ac_order_by is applicable to reference fields only.

Refer : https://docs.servicenow.com/en-US/bundle/tokyo-it-asset-management/page/product/service-catalog-management/reference/variable-attributes.html

Re: Order by not working in list collector?

Gunjan Kiratkar — Tue, 22 Nov 2022 10:43:26 GMT

Hi @rahul16

Do not do anything in the Variable Attributes section, in place of that update the "Reference qual" of the variable as below--

ORDERBYu_order

Demo :-

javascript&colon; 'ORDERBYu_order^u_language='+gs.getSession().getLanguage();

Re: Order by not working in list collector?

rahul16 — Tue, 22 Nov 2022 10:42:05 GMT

Then for lookup what i can use

Re: Order by not working in list collector?

rahul16 — Tue, 22 Nov 2022 10:58:33 GMT

javascript&colon; 'u_inactive=false^ORDERBYu_order^u_type=subcategory^u_dependent =' + current.variables.category+'^u_catalog_item='+(current.cat_item.sys_id||current.request_item.cat_item.sys_id);

Yes, I try like that too but it's not working for the subcategory but for the category, it's working.

Re: Order by not working in list collector?

Raghav Sharma24 — Tue, 22 Nov 2022 10:54:54 GMT

@rahul16 this doest seems to be possible.

Refer : https://www.servicenow.com/community/developer-forum/sorting-an-advanced-reference-qual/m-p/1484642

Re: Order by not working in list collector?

rahul16 — Tue, 22 Nov 2022 18:50:55 GMT

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

Re: Order by not working in list collector?

Raghav Sharma24 — Wed, 23 Nov 2022 03:45:36 GMT

Where are you using order by category in the qualifier?

Re: Order by not working in list collector?

rahul16 — Wed, 23 Nov 2022 06:40:13 GMT

javascript&colon; 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

Re: Order by not working in list collector?

Raghav Sharma24 — Wed, 23 Nov 2022 06:58:12 GMT

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

Re: Order by not working in list collector?

rahul16 — Wed, 23 Nov 2022 07:03:49 GMT

For category data coming by order by but for subcategory data is not coming in order

Re: Order by not working in list collector?

Raghav Sharma24 — Wed, 23 Nov 2022 07:13:42 GMT

Can you try to remove orderby from category to check any change in data, we need to check if orderby is working or by default the category data is showing in that order.

Re: Order by not working in list collector?

rahul16 — Wed, 23 Nov 2022 07:41:49 GMT

Before orderby it not showing in order. after adding it showing based on the order.

I try with variable attributes but it's not worked so I added orderby it working fine.