The CreatorCon Call for Content is officially open! Get started here.

How to get catalog item variable sys_id?

Annie10
Tera Contributor

Hello,

 

I would like to learn how to get catalog item variable sys_id.  Could someone please provide suggestions?

 

Thank you so much!

1 ACCEPTED SOLUTION

Hi @Annie10 some ways to do that:

 

1. Try to find your variable on item_option_new table. There's a column called "Catalog Item" and other called "Variable set" then you can confirm if the variable is related to the item or the variable set you want and just copy sys_id using right click on form header.

 

2. Open the catalog item on sc_cat_item table, then in the related list "variables" you can simply right click on the desired variable and select copy sys_id

Screen Shot 2022-10-11 at 15.12.49.png

 

View solution in original post

6 REPLIES 6

No problem, glad to help you 🙂

Shree22
Tera Contributor

Hi,

   Please find Variables Table (item_option_new_list.)item_option_new_list.Variables.png

 

Which one variable do you want sys_id Right click on this variable and select "copy sys_id" and you will get the sys_id particular variable.Variables.png

 

 

If it helps you Please Mark HELPFUL