Hi All,
I trust this msg finds you well.
I have a catalogue item with two variables.
1 - business application
2 - service manager
Number 2 is populated based on 1, as this value is in the business application form. However, if the value is outdated i want to be able to change it by selecting people from a specific group (service managers).
To do this i use a reference field for field 2 linked to "sys_user_grmember" table.
Everything works ok until i want to change the value. Once i clear the default value i can only see
dates.
So i used the "variable attributes" to select which column i want to see and added as follows.
"ref_auto_completer=AJAXTableCompleter,ref_ac_columns=user,ref_ac_columns_search=true"
the problem i have is that not only i can see the name of the user, but i cannot get rid of the created date.
how can i remove the first column?
regards,
Hi @El Cuchi ,
You can go to Dictionary (sys_dictionary) there in table search for sys_user_grmember and whichever field you want to be visible in dropdown make Display as true
If you want to add more columns you can add what @AnimeshP_96 has mentioned in variable attribute,
ref_auto_completer=AJAXTableCompleter,ref_ac_columns_search=true,ref_ac_columns=group;user
Please mark this comment as Correct Answer/Helpful if it helped you.
Regards,
Swathi Sarang
