Relationship between catalog item and fulfillment groups

[hemali1]

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?

[SanjivMeher]

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.

[hemali1]

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

[SanjivMeher]

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

[hemali1]

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