I'm trying to create a database view to show the following information:
Catalog Item Name and which User criteria is using under the Available for and Not Available for. Also I will like to show which groups are part of each user criteria.
I was trying to use the following tables, not all together but combining one or two.
- sc_cat_item_user_mtom
- sc_cat_item_user_no_mtom
- sc_cat_item_user_criteria_no_mtom
- sc_cat_item_user_criteria_mtom
- sc_cat_item
- user_criteria
The end goal is to identify which groups can view the catalog item and present that information in a dashboard with maybe an interactive filter where we search for the catalog item, and then present the user criteria, user group and user that have access.
