Query Changes which contains specific change-tasks assignment-groups

[Benedikt Kaiser]

Hi,

in my current projekt I need to search for changes which have change-tasks with specific assignment-groups.

Currently I'm using: 

api/sn_chg_rest/v1/change?sysparm_query=statestate=1^assignment_groupLIKETS&sysparm_display_value=true

but assignment_group is not the correct field, as this is only the group from the change but not from the change-tasks.

Can I do this somehow in one go?

Best regards,

Benedikt

[Dr Atul G- LNG]

Hi @Benedikt Kaiser 

Create a report on change task table and filter the assignment group

or

assignment_group=477a05d153013010b846ddeeff7b1225

[Ankur Bawiskar · Accepted solution]

@Benedikt Kaiser 

I think you are using Change Management API. Are you giving this endpoint to some 3rd party and they want to fetch the details.

It doesn't support query on change_task table

You can search Change Task but using CHG SysId

Both the GET APIs cannot be used

So you need to use Scripted REST API and create a custom endpoint and once they hit the API the response can be shared by using GlideRecord in that scripted REST API

If my response helped please mark it correct and close the thread so that it benefits future readers.