Look up select box reference qualifier not sorting by sequence

[Debasis Pati]

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.

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

Regards,
Debasis

[Chaitanya ILCR]

Hi @Debasis Pati 

try this

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]

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

Sample:

ORDERBYsequence^element=resolution_code^name=problem

 Regards,
Siva

[Ankur Bawiskar]

@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.

[Debasis Pati]

Hello @Ankur Bawiskar ,

I have already tried it it's not working.

Please look below

Regards,
Debasis