Order By in Look up Select Box Reference Qualifier not working
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-18-2022 01:03 AM
I have a Lookup select Box.
I applied ORDERBY in reference qualifier. But its not working.
Below is the text from ref qualifier. What am I missing?
javascript:"persona=" + current.variables.persona.getDisplayValue()+"^device_type="+current.variables.computer_setup+"^exceptiondevice=false^isactive=true^ORDERBYsortsequence"

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-18-2022 03:51 AM
The last part of the reference qualifier is the problem.
ORDERBYsortsequence
Replace sortsequence with your field name.
for example, I have used serial_number for the orderBy:
javascript:"persona=" + current.variables.persona.getDisplayValue()+"^device_type="+current.variables.computer_setup+"^exceptiondevice=false^isactive=true^ORDERBYserial_number"
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-18-2022 05:04 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-18-2022 05:27 AM
lol, I'm sorry.
Now I'm clueless.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-18-2022 05:39 AM
You can write a SI and sort the result using orderBy and simply return the list. Call this SI in the reference qualifier.
This will definitely work.