Assignment group reference qualifier should be diff based on table

[sinu2]

Hi All,

As of today assignment group field if being used from the task table. But now i have a requirement if i open incident,problem,sc_request_incident_task_problem_task,sc_task tables open and trying to select assignment group reference icon, it should show assignment groups active true and group tye ITIL

But for Change_request and Change_task tables when user selects assignment group, only it should show the groups type is change

how can i achieve this. As of today all these tables are using assignment group field task table one

[bammar]

When you go to Dictionary for the Assignment Group field,

Scroll down , go to dictionary Overrides- Select New- Set the Table and check override reference qualifier then put in your query into the line.

Do this for any and all tables you need to

[Anurag2]

Hi,

Right click on Assignment group-> Configure dictionary -> Switch to advanced view -> Scroll down and go to dictionary overrides -> Check on Override Reference Qualifier and put the new condition there. 

Please mark correct if it solves your problem.

[John VanBruggen · Accepted solution]

There are already some great responses that point you to the correct area to configure for this.  I wanted to do a deaper dive and show you how to get the data needed to configure the reference qualifier field of a dicitonary override.

I hope you find this helpful.

[Jonah Piascik]

@John VanBruggen - great little video walkthrough.  I'm looking to do the same and ran into a little speed bump.  I don't see the 'problem' table as a choice for a dictionary override on the task.assignment_group field.  I was able to configure this for incident, change_request, and problem_task.  Thoughts?