Reference qualifier for Subcategory which is dependent on Category variabele

[Anisha Bandhoe]

I have created a Catalog Item in ServiceNow that contains two variables: Category and Subcategory.

• Both variables are dependent on each other.

• In the Reference Qualifier for the Subcategory variable, I have filtered the values so that they should be displayed sorted by the sequence field.

• This works as expected in the backend form, but in the Service Portal, the Subcategory options are still sorted alphabetically.

Goal:
I want the Subcategory options in the Service Portal to appear sorted by the sequence field, so that the option "Other" always appears at the bottom of the list.

Current situation:

• Sequence for dependent value 50 (subcategory) = X

• Sequence for dependent value 40 (subcategory) = Y

• In the Service Portal, the order is alphabetical, ignoring the sequence.

Question:
How can I make the Subcategory variable in the Service Portal display options sorted by the sequence field instead of alphabetically, ensuring "Other" is always at the bottom?

Shown in the serviceportal:

[Shashank_Jain]

@Anisha Bandhoe , I didn't find an exact solution, but you can try the following approach:

active=true^ORDERBYDESCsys_created_on

active=true^ORDERBYDESCsys_created_on
will sort the results so that the most recently created records appear at the top of the list.

So the newest item shows first, and older ones appear further down.

Create "others" choice first and then create rest of the choices and put on this reference qualifier condition.

Give it a try, hope it works. I tried it on PDI.

Thank you!

If you find this correct, please mark the response as helpful.

[Ankur Bawiskar]

@Anisha Bandhoe 

I could see you already added ^ORDERBYsequence in between the reference qualifier

But add that at the end

^ORDERBYsequence

Something like this

javascript: 'inactive=false^name=x_vua_rs_case^element=subcategory^language=' + gs.getSession().getLanguage() + '^dependent_value=' + current.variables.category + '^ORDERBYsequence';

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

[Ankur Bawiskar]

@Anisha Bandhoe 

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.