Service Portal and UX sort issue

gracjan
Tera Guru

‎01-17-2025 06:20 PM

While creating a list of rooms associated with the dependent value of a location, I ran into an issue where Service Portal shows no order but UX does, even the ORDERBY is there. How can I make it to look the same on both. 

 

Also, I noticed that when I remove the numbers starting with 1001 the sort starts to work in the Service Portal, otherwise it does not. There only 97 records for the room numbers. The order is set to increment by 10 so 209, the order is 10. This is on the question_choice table.

 

Reference qualifier:

javascript:'inactive=false^ORDERBYorder^question=99eee6dd1b7cc2107c81da49b04bcba1^u_dependent_valueISNOTEMPTY^u_dependent_value=' + current.variables.sample_locations

 

 

What am I doing wrong? Is there a way to circumvent this? Please help.

 

This is Service Portal

backend.PNG

This is UX which is correct.

backend1.PNG

 

0 Helpfuls
  • 381 Views
1 REPLY 1

Community Alums
Not applicable

‎01-17-2025 08:08 PM

Hi @gracjan ,

The reference list in Service Portal can be configured to be sorted by Order column using the following steps:

  1. Navigate to the reference variable.
  2. Go to the Default Value tab.
  3. In the Variable Attributes field, add the following: ref_ac_order_by=order 
  4. Save and test on Service Portal. 

Also, You can refer to below thread, should help you if above doesn't:

https://www.servicenow.com/community/developer-forum/reference-qualifier-to-sort-a-reference-field/m...