create relationship between assigned group and business service

[Jorge Huarcaya]

I need to create a dependency between the business service and assigned group fields, this in order that only certain groups can be assigned to certain incidents with a certain business service, for example. Business service 1> group 1, group 2 business service 2> group 1, group 3 when the incident has business service 1, only groups 1, 2 and not 3 could be assigned if the incident has business service 2, only group 1.3 could be assigned and not 2. can you please help me how to do it? Greetings.

[shill]

I'm going to assume this is more than just a few business services and groups.

If that is the case, I might create a new table with a reference field for a business service and a reference field for a group.

You would then populate a record for each group needed for a particular business service. In your example, there would be two records with business service 1, one for group 1 and one for group 2.

You would then need to create a script include to use as a reference qualifier passing the business service and querying against this table and returning the associated group in a comma delimited list of group sys ids.

You would also need to provide for clearing the value of the assignment group when the business service is changed, otherwise they could get around the qualifier.

This is a generalized path I might take if I had the same need.

[Jorge Huarcaya]

Hello, I do not know much about script, you can help me with the script, I can create the table if I understood it. thank you.

[Ajaykumar1]

Hi Jorge,

Shill is correct, you have to create a table to store relationships between your Business Services and groups.

Steps :

1. Create new table say, u_group_business_relation, in that create two reference type fields one will refer sys_user_group table and other to cmdb_ci_service.

2. Open in form and your business service and the group fill values, and create other records.

3. create a reference field on your incident form which will refer the table which you have created (u_group_business_relation).

4. R.click on your newly created Ref field which is configure dictionary > Advanced View(Under related Links) > enter business_service in dependent field.

5. Select Advanced in Use reference qualifier field and write javascript:current.business_service.

Regards,
Ajay

[Jorge Huarcaya]

Hi, I do not try it yet; but and my field assignment group should also be dependp?