How To get an extract of Assignment groups associated to "Create Catalog Task" in Flow designer

[Nabil EL FILALI]

Dears,

Could you please advise how can I get all the created catalog tasks in Flow Designer with the assignment groups associated ? 

Thanks a lot

[Aditya_hublikar]

Hello @Nabil EL FILALI ,

Im not getting your exact requirnment but if you want all catalog tasks record that are created by its corresponding ritm then you can use Look up records action  on table sc_task table and add condition like Request item is your_request_item then you will get all records . After that you can perform operation using for each loop on that records if you have to perform .

If this helps you then mark it as helpful and accept as solution.

Regards,

Aditya,

Technical Consultant

[Nabil EL FILALI]

Hello,

the objective is to extract from the flows the action "Create Catalog Task" when it's assigned to a group called "L3 Support"  for example.

[Aditya_hublikar]

Hello @Nabil EL FILALI ,

In Flow Designer, the “Create Catalog Task” action cannot be directly extracted. Instead, we identify the Catalog Task records (sc_task) created by the flow and apply conditions such as Assignment Group = L3 Support to filter the required data.

[yashkamde]

Hello @Nabil EL FILALI , 

As far I get your requirement I assume that you want to extract all the created catalog tasks in Flow Designer with the assignment groups associated,

So this code I tried in script- background which is giving me the list and count of all the created catalog tasks through flow designer (as it has requested item RITM associated with it) also having assignment group associated..

var gr = new GlideRecord('sc_task');
gr.addQuery('request_item','!=', '');
gr.addQuery('assignment_group', '!=', '');
gr.query();

while(gr.next()){
	gs.print(gr.number);
}
gs.print(gr.getRowCount());

If my response helped mark as helpful and accept the solution.