Set Reference qualifier to only show assignment group parent for selected company

[mhafizam]

Hello everyone,

I'm trying to filter the available options in the Assignment Group field based on the Company selected.

I've been looking into Reference Qualifiers, but I'm struggling to apply a condition to achieve this. My goal is to ensure that when a new incident has 'Test Company' selected as the Company, the Assignment Group field only displays groups with the parent 'Test ITIL Fulfillers' related to that company.

I'd appreciate any guidance or suggestions on how to set this up. Thanks in advance!

[mhafizam]

The company operates as a vendor (test company). When the 'test' vendor company is selected in the company field, the system should display only the parent groups that have associated subgroups.

[Ankur Bawiskar]

@mhafizam 

how do you determine this? -> display only the parent groups that have associated subgroups.

If test company is selected then which field on Group table will you use to relate to company?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[mhafizam]

when test company selected, in assigned group [sys_user_group] will show parent.

i'll show you example filter that i run as below. parent is EQ ITIL and it will show only subgroup as screenshot

[Ankur Bawiskar]

@mhafizam 

you can create a dictionary override on Assignment group field for your table and use advanced ref qualifier

something like this

If that particular company is selected then it will show groups based on that query; if another company then it will show all groups

javascript: var query=''; if(current.company.name == 'company name') query='parent.nameINEQ ITIL Fulfillers'; query;

If my response helped please mark it correct and close the thread so that it benefits future readers.