- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-28-2023 08:31 AM
Hello,
I have a requirement to control the lookups for assignment group based on the condition.
As you can see in the above image, we have a custom field called Division on sys_user_group table.
We have the similar field called Divisions on change request as well. Based on the selection of 'Division' on change request, it should control the lookup for assignment groups. How can we achieve that??
Thanks in advance!!
Solved! Go to Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-28-2023 08:50 AM
@Delapan Use the following steps to filter assignment groups on the basis of division field.
1. Right click on your assignment group field on Change request form and choose Configure dictionary
2. You will be taken to the assignment group field of Task table (change is extended from task and the filed is inherited)
Scroll to the bottom and find Dictionary Override related list, click on New button to add a new dictionary override for change_request. Edit existing if a record already exist.
3. Create the dictionary override as follows.
Here is the script for reference qualifier.
javascript:'u_division=' + current.u_division
Here I am assuming that your field name on change_request and group is u_division. Update the field names in the above qualifier if they are different.
Save this record and check if you manage to see the correct assignment groups on change request on the basis of the division selected.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-28-2023 08:50 AM
@Delapan Use the following steps to filter assignment groups on the basis of division field.
1. Right click on your assignment group field on Change request form and choose Configure dictionary
2. You will be taken to the assignment group field of Task table (change is extended from task and the filed is inherited)
Scroll to the bottom and find Dictionary Override related list, click on New button to add a new dictionary override for change_request. Edit existing if a record already exist.
3. Create the dictionary override as follows.
Here is the script for reference qualifier.
javascript:'u_division=' + current.u_division
Here I am assuming that your field name on change_request and group is u_division. Update the field names in the above qualifier if they are different.
Save this record and check if you manage to see the correct assignment groups on change request on the basis of the division selected.