Data lookup for change requests

[andrea_s71]

As assignment group is a mandatory field in our change requests, I am looking for a way to set the assignment group for a particular service onChange. I thought I had found the solution with a data lookup rule but it's not working as intended. 

I used the following values:

Source table: change_request

Matcher table: dl_u_assignment

Matcher field: business_service

Setter fields: assigned_to, assignment_group

I then went to Assignment Lookup rules, set up a new rule, chose the service I want to match, and then the assignment group. Unfortunately, what now happens is that whenever any service is selected, no matter which one, it fills assignment group with the one I set up. Where did I go wrong, and how can I fix it?

[bammar]

Well there are many ways perhaps to do this. Here are several.

* if you type "Assignment" and then your rule is set here you have to make a filter  If service is x - assignment group = y- so i think there is no filter or query set --- doing this should work as long as the field hasnt been filled out manually

You could hide the Assignment Group until the Business Service is selected then if it is this one you mention then onChange show it prefilled with the group you want in read only.... 

[andrea_s71]

I am not sure I follow the first point. I type assignment where? Where do I set the filter?

I am implementing ServiceNow for my department only, and we share ITSM with our central IT, so I can't hide assignment group like that. I just want it so that when members from our department select our business service, the assignment group is auto-filled.