Show the list of applications based on assignment group in the Itask table

[SanikaK]

I have a requirement on the Itask table(u_incident_task).
I have created new field application name (u_applname) which is a reference filed (referring to cmdb_ci_appl). 
When the user selects the assignment group on u_incident_task, the u_applname should filter only those applications mapped to the selected assignment group.

Kindly help on this, understanding the relation between the tables and how to achieve this

Thanks in advance

[armanoj]

@SanikaK ,

there is any common field in both table?

[armanoj]

@SanikaK ,

in the cmdb_ci_appl table there is field called support group. Based on that we can populate the application name

example:

Assignment group you select is any of the support group then in the Application name populate which belongs to the support group.

[Ankur Bawiskar]

@SanikaK 

you can use advanced reference qualifier on that app name field like this

Example: I took support group to filter, you can filter based on the group field which you want

support_group -> field on cmdb_ci_appl

u_groupField -> field on your custom table

javascript:'support_group=' + current.u_groupField;

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏