Relationship between catalog item and fulfillment groups

hemali1
Kilo Contributor

I am trying to have a list of all the catalog items and the fulfillment groups associated with the workflow on the item. What is the best way to establish such kind of relationsip?

1 ACCEPTED SOLUTION

Here are screenshots of my working database view:



Main Record:


find_real_file.png



Group table:


find_real_file.png



Value table:


find_real_file.png


View solution in original post

12 REPLIES 12

SanjivMeher
Kilo Patron
Kilo Patron

Hi Hemali,



You can run a pivot report on sc_task table. Do a group by on Request Item->Item and stack by Assignment Group.



Please mark this response as correct or helpful if it assisted you with your question.

I tried that but It doesn't work for the items that may not have been requested yet


For the ones which are not requested yet, you will have to go into each items workflow and find out.



Please mark this response as correct or helpful if it assisted you with your question.

That is the reason I need to establish a relationship. The number of such records are huge and its not feasible to go into each record and find the workflow >catalog task>fulfillment group for each of them. I need to have a list view of it showing both (catalog item and fulfillment group) showing side by side