Reference (or List Collector) show 2 field

[Nguyen Quang Tu]

Hi experts,

When a reference (or list collector) field reference to Group Member(sys_user_grmember) table, it will display as User[Group] format. So is there anyway that I can make other table display as the same as Group Memebr table? the Variable attributes only allow me to display two or more field in the drop down list, but only show display field when chosen.

Thanks in advance.

[OlaN · Accepted solution]

Hi,

That is correct. When using a list collector you can show one or more fields when browsing the list of options, but when a option is selected only the display-field will show up in the selected items.

A workaround would be to create a new field that is set to display, and have that new field contain all the values of the different fields as needed.

You would need to populate it using a business rule, or perhaps create it as a calculated field.

[Nguyen Quang Tu]

Thank you for reply!!

So there is no setting that I can make my custom table to display like Group Member tables ?

[OlaN]

No, no setting will change that. It will always use the display field of any table.

Hence the suggestion of the workaround.

[Arun_S1]

Hello Nguyen,

Group Member table by out of the box has only 2 fields 

1. Group - Reference to the Assignment Group (sys_user_group)

2. User - Reference to the User Table (sys_user)

I believe you have a custom field in the Group Member  table which is a calculated field and concatenating the user name and the group name for a better visibility. Looks like this custom field is set to Display True in the dictionary.

The same way you can create a calculated field that can automatically populate values and can be used as display.