Reference qualifier to select based on a tag

adeh
Tera Contributor

Hi,

I have a reference field (to sys_user_group) and I want to add a reference qualifier to only show groups that have a certain tag. I am struggling to work out if this is possible as I can't find any examples - any advice?

1 ACCEPTED SOLUTION

arthikamugundan
Kilo Expert

Hello,

 

You can also try adding a simple reference qualifier on the "Tags" field like below. 

The field name of Tags in any table is sys_tags. 

find_real_file.png

View solution in original post

3 REPLIES 3

Archana Reddy2
Tera Guru

Hi,

May I know what you meant by tag?

Ahmmed Ali
Mega Sage

Hello,

 

Tags are stored in "label_entry" table. you can create create a script include to query the "label_entry" table with table name as "sys_user_group" and label as required tag. then return table key (which will be sys_id of group record).

 

Hope this helps. 

 

Let me know if you need help in script.

 

Thanks,

Ali

If I could help you with your Query then, please hit the Thumb Icon and mark my answer as Correct!!

Thank you,
Ali

arthikamugundan
Kilo Expert

Hello,

 

You can also try adding a simple reference qualifier on the "Tags" field like below. 

The field name of Tags in any table is sys_tags. 

find_real_file.png