Lookup Select Box not obeying ORDERBY in Reference Qual

[Paul Ryder1]

Hi,

I have a Catalog Item with a couple of Variables on it, which the second needs to be related to the first.

This is working but I cannot get the Order clause to work on the second.

Both variables are referencing the same table.

Table:

Custom table that does not extend another

Fields:

Active: True/False

Main Version: String

Update Version: String

Order: Integer

Main Variable Qual

javascript:'ORDERBYDESCsys_created_on^u_active=true'

Update Variable Qual:

javascript:'ORDERBYu_order^u_active=true^u_revit_main_version=' + current.variables.revit_main_version

The first field gets it's items ordered correctly and they are in the correct order, however when this is clicked on the Update field gets populated correctly based on the Main variable, but it's always ordered in Alphabetical order.

The only difference is that I am concatinating onto that string in the second, but will that make any difference?

Many Thanks,

Paul

[Srinidhi Hari E]

Hi Paul, 

I have the same issue when I upgraded to London.

Were you able to resolve this issue ?

Thanks, Srinidhi

[Brian Lancaster]

try addOrderBy.

[Aksha · Accepted solution]

Hi,

Did you tried using 'ref_ac_order_by=u_order' in variable attribute?

[Adam Rasmussen]

This worked for me.