Variable Attribute in reference field

[El Cuchi]

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,

[AnimeshP_96]

Hey @El Cuchi 
 I guess its something to do when you try to search the record, try using this and let me know if this works or not

 ref_auto_completer=AJAXTableCompleter,ref_ac_columns_search=true,ref_ac_columns=name;phone

here name and phone are column or field backend name. 

[AnimeshP_96]

Hi @El Cuchi 
if this worked close this thread ,so that others will have look into it if they face any problems related to it.

[swathisarang98 · Accepted solution]

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

[MQG]

This worked brilliantly for me. Thanks!