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?

[hemali1]

I replicated the above mentioned fields but I get the following error:

Where clause in view u_catalog_item_fulfillment_group has an invalid field or a field that is not visible (var_variable)

[Michael Ritchie · Accepted solution]

Here are screenshots of my working database view:

Main Record:

Group table:

Value table:

[shivanipatel]

Hemali,

We are glad you took advantage of the ServiceNow Community to learn more and to get your questions answered. The Customer Experience Team is working hard to ensure that the Community experience is most optimal for our customers.

If you feel that your question was answered, we would greatly appreciate if you could mark the appropriate thread as "Correct Answer". This allows other customers to learn from your thread and improves the ServiceNow Community experience.

If you are viewing this from the Community inbox you will not see the correct answer button.   If so, please review How to Mark Answers Correct From Inbox View.

Thanks,

Shivani Patel