Variable Attribute display order and return value

Colleen1
Tera Contributor

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?

find_real_file.png

 

find_real_file.png

Any assistance would be greatly appreciated.

1 ACCEPTED SOLUTION

Jaspal Singh
Mega Patron
Mega Patron

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.

View solution in original post

6 REPLIES 6

Shivani Singh1
Tera Guru

Hello Colleen,

It's because as per OOB "Name" is considered as primary field to be displayed. So, if you want to "Software name" to display on left side, then in dictionary set Display = true for this field.

But this change will be global, any table/form where group table is in reference then group names won't be visible but Software name. Ex- assignment group fields in inc, chg etc.

Ideally, it should be avoided. Even in current situation, any user can search by software names and result will be displayed.

Please mark helpful if it solves the purpose.

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.