ORDERBY not working with JavaScript Reference Qualifier in Record Producer

[kiran115]

Description:
I have a Record Producer with two fields — Services and Solutions.
Both Services and Solutions are Lookup Select Box variables.
The Solutions field is dependent on the Services field, and I’ve mapped this dependency through a custom field called u_dependent_field on the referenced table.

• Scenario 1: When I use a static reference qualifier (without JavaScript), for example:

  u_active=true^ORDERBYu_order

  the results are displayed correctly and sorted as per the u_order field.

• Scenario 2: When I use a JavaScript reference qualifier, for example:

  javascript:'u_dependent_field=' + current.variables.u_services + '^ORDERBYu_order';

  the dependent values are retrieved correctly based on the selected service, but the results are not sorted by u_order — instead, they appear in alphabetical order.

Could you please confirm whether ORDERBY is supported in JavaScript-based reference qualifiers for Lookup Select Box variables in Record Producers, or suggest the recommended way to ensure sorting by a specific field (like u_order) when using a dynamic qualifier?

[Brad Bowman]

This is working for me.  In a more out of box example I have 2 Lookup Select Box variables on an incident record producer for Category and Subcategory.  This is what Subcategory looks like:

The choices are ordered by the Sequence on the sys_chocie table.  If I take out the orderby, they are sorted alphabetically.  Make sure you have the Variable attribute pointing back to the name of the dependent variable.

[Marco0o1]

Hi @kiran115 ,

On the Record Producers I got the same problem, 

You can just use the attribute on the Variable attributes field:

ref_ac_order_by=sequence

If you want to use the reverse:

ref_ac_order_by_desc = number