Related table

dev_K
Tera Contributor

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!

 

 

dev_K_0-1713959656875.png

 

1 ACCEPTED SOLUTION

ProdiptoL
Tera Expert

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.

View solution in original post

7 REPLIES 7

Ankur Bawiskar
Tera Patron
Tera Patron

@dev_K 

this table sc_cat_item_user_criteria_mtom holds the mapping of User criteria with catalog item

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

sure, but how can I find myself what are the names of these tables?

@dev_K 

simply open the record in new tab and see the table name in url

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Ranjit Nimbalka
Mega Sage

Hi @dev_K ,

 

sc_cat_item_user_criteria_mtom in this table those record are stored.

 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.
Regards,
Ranjit