Get the number of groups for requested Items

[Rakshanda Kunte]

Hi All,

Req: Need to create a new catalog item where input will be 'Item' and we get the output that 'how many groups have raised requests using 'ABC'(this is input of the catalog item) catalog item. I also need to create a Flow designer.

Variables:

1. Item

Output should be:

1. Showcase Number of Groups/teams raised request using ABC catalog item.

2. Names of Groups/Teams raised request using ABC Catalog item.

3. Showcase Number of Groups/teams who have not raised any request using ABC catalog item.

4. Names of Groups/Teams who have not raised request using ABC Catalog item.

I can do the scripting in flow designer.

Can anyone help with scripting?

Thank you..

[Ankur Bawiskar]

@Rakshanda Kunte 

you usually raise catalog item to fulfill some request.

what's the business requirement in your case?

[Rakshanda Kunte]

Hi @Ankur Bawiskar , 

Team needs the data how many families have raised the request using their catalog item. 

Basically, that catalog item is for compliance testing.

So, they need the numbers/names to identify how many departments have tested(raised request) and how many did not (didn't raised request)

For, this we came up with idea of new catalog item where they will just need to select the catalog item for which they need this data. And, in output we will provide number/names of departments.

[Ankur Bawiskar]

@Rakshanda Kunte 

where are you planning to show the output? will you send an email to the user who raised the request?
if yes then you can use email notification and email script to share the details over email

[Rakshanda Kunte]

@Ankur Bawiskar 

I am planning to update work notes of RITM.

I am facing issue with scripting. As mainly, I need to use 'Group by' in scripting and need to dot walk 2-3 tables.

Can we do this using scripting?