How to get catalog item variable sys_id?

[Annie10]

Hello,

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

Thank you so much!

[Mike_R]

Need a little more context. Are you just trying to obtain the sys_id for one specific catalog variable? Or are you trying to obtain using a script? Something different?

[Annie10]

Hi,

I just want to learn how obtain the sys_id for one specific catalog variable.

Thanks

[gcm1 · 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

[Annie10]

Thank you so much for helping.