Variable Attribute display order and return value

[Colleen1]

We are attempting to show a list of groups and a secondary field in a reference variable using [the attribute we used]. This is working, but we would prefer to have the group name to the right and our additional field to the left flipping the columns to make it more user friendly.

In the drop down, we added a new field to the sys_user_group table for software name (u_software_name).  In the scenario below, the group name is Test Apps and the software is Adobe Acrobat Pro.  We, would like to display the software on the left side of the drop down.  Below the first screen is how we are defining the Variable attributes.  We said to order by the software field but appears to not be taking it. Also, would it be possible to return the Software name in that field as well?

Any assistance would be greatly appreciated.

[Jaspal Singh · Accepted solution]

Hi Collen,

Unfortunately that is not possible as the sequence is 

1. Display Value of table

2. Whatever attributes are added in ref_ac_columns

So, it seems the table you referencing here has Display set as Name & thus is the cause. You can control the ordering by ref_ac_columns but default will be Display value of the table refrenced.

[Colleen1]

Thank you for the information.  This has helped greatly.  Because of you guidance we have decided to go in another direction and that is working.  Thank you.

[Neethi2]

Hi Jaspal,

We have a requirement to populate IT application owner which is in Business Applications table.

Also, we have checked that name is not marked as display value in the table.

We have given the below query to populate only IT application owners in the reference field which is referring Business applications table created in the catalog form

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=it_application_owner,ref_ac_columns_search=true,ref_ac_order_by=it_application_owner

This is a urgent requirement.

Please help.

[Neethi2]

Hi Jaspal,

Could you please help here