Look up select box reference qualifier not sorting by sequence

Debasis Pati
Tera Guru

I have a look up select box variable on my record producer called subcategory which is depend on another variable category.

Now i have created a look up select box variable and used the referecnce qualifier below still its sorting alphabetically not by sequence field on sys_choice table.

DebasisPati_0-1750386134450.png



@Ankur Bawiskar  Can you please guide what can be done to achieve this?

Regards,
Debasis

11 REPLIES 11

Chaitanya ILCR
Kilo Patron

Hi @Debasis Pati 

try this

ChaitanyaILCR_0-1750387796606.png

 

put this in the variable attributes

ref_qual_elements=category

 

 

Please mark my answer as helpful/correct if it resolves your query.

Regards,
Chaitanya

 

J Siva
Tera Sage

Hi @Debasis Pati 
Try prefixing the "ORDERBY sequence" in the Reference qualifier as below. It'll work.

JSiva_0-1750388532649.png
Sample:

ORDERBYsequence^element=resolution_code^name=problem

 Regards,
Siva

Ankur Bawiskar
Tera Patron
Tera Patron

@Debasis Pati 

it has worked in the past using something similar

Lookup select box reference qual - sort by sequence 

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

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Hello @Ankur Bawiskar ,

I have already tried it it's not working.

Please look below

DebasisPati_0-1750392959657.png


Regards,
Debasis