Lookup assignment groups based on the Condition on Change

Delapan
Tera Contributor

Hello,

I have a requirement to control the lookups for assignment group based on the condition.

Delapan_0-1695914926000.png

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!!

1 ACCEPTED SOLUTION

Sandeep Rajput
Tera Patron
Tera Patron

@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

Screenshot 2023-09-28 at 9.12.55 PM.png

2. You will be taken to the assignment group field of Task table (change is extended from task and the filed is inherited)

Screenshot 2023-09-28 at 9.13.46 PM.png

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.

Screenshot 2023-09-28 at 9.14.59 PM.png

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.

 

 

View solution in original post

1 REPLY 1

Sandeep Rajput
Tera Patron
Tera Patron

@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

Screenshot 2023-09-28 at 9.12.55 PM.png

2. You will be taken to the assignment group field of Task table (change is extended from task and the filed is inherited)

Screenshot 2023-09-28 at 9.13.46 PM.png

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.

Screenshot 2023-09-28 at 9.14.59 PM.png

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.