Ability to specify which group we DO NOT want to appear on the “assignment group” field

[sagar0711]

I have created a one-check box with the label "not visible in assignment group"  in the group table form when that checkbox is selected we want to make sure the group is not visible in any Assignment groups How can we do this using script

[Harish KM]

Hi @sagar0711 You dont need script for this. Just simple reference qualifier will work on Assignment Group fields.

Your reference qual condition will be

fieldname is not True

Ensure you do this by doing a dictionary override to all child tables if extended from TASK.

[sagar0711]

I want do that for all tables where the assignment group field is present but the tables do not have any relation between them.
I have already applied the reference qualifier condition but it only works for a perticular table.

[Harish KM]

Hi @sagar0711 Assignment group field is a reference field so you can hide few records based on reference qual only, 

other option I could think is of ACL on Group table. Create a read acl with condition and return false so that those groups dont appear anywhere

[Sarika S Nair1 · Accepted solution]

You can create a before query business rule in groups table which should trigger only for sys_ref_list

view.

refer below script

if(gs.action.getGlideURI().getMap().get('sysparm_view')=='sys_ref_list'){

current.addQuery('checkboxfieldname',false); // will show only groups with that checkbox is false
}