Related table

[dev_K]

Hi all,

I was wondering how can I check what is the name of the table from the Catalo Item available tabs. Eg. In the example below I want to check the "Available To" records. Thanks!

[ProdiptoL · Accepted solution]

Hi @dev_K 

Right click on the yellow mark filter and open the URL in new tab. The table name is Catalog Item Available for [sc_cat_item_user_criteria_mtom]. This table store the relation between the sc_cat_item table record and user_criteria table record.

[Sid_Takali]

Hi @dev_K you can see Available For stored in "sc_cat_item_user_criteria_mtom_list"  Catalog Item Available For table.

Right Click >> Open in New Window 

Please Mark my answer Correct/Helpful

Regards,

Siddharam 

[swathisarang98]

Hi @dev_K ,

The table is Catalog Item Available for (sc_cat_item_user_criteria_mtom)  but when you create a record using new it will create in User Criteria(user_criteria) table and maps the catalog item and user criteria  

Please mark this comment as Correct Answer/Helpful if it helped you.

Regards,

Swathi Sarang