Catalog Builder: how do I get the sys_id of the item I'm currently working on?

[tahnalos]

What the title says.

Is there a process or a script keyword in which I can get the sys_id of the catalog item that I'm currently building in the Catalog Builder so I can use it in a reference?

I have tried with the Current keyword but that does not work.  It would appear that the current keyword only deals with either the Catalog variable you are building or the record producer (if you're using a service fulfillment step).

[Bert_c1]

Hi @tahnalos,

find the record in the 'sc_cat_item' table. See example from a list view of those records. Hover you mouse over the name, then right-click to get the menu shown. You can "Copy..." it and paste in where you want.

Here, my mouse was over "Standard Laptop". I have no idea what you tried, but you can query the table in a script using whatever conditions, then access the sys_id field.

[tahnalos]

Sorry, I need to clarify.

This needs to be automated.  I need to get the sys_id as this info is being sent to another table as the Catalog Item is being built.  We have some third party automated processes that are being triggered when we create an item via the Catalog Builder and the one thing they require is the sys_id of the item we are building.

Can this be done via an automated process?

[Bert_c1]

Hi @tahnalos,

Yes, you can defined a Business Rule on the sc_cat_item table. What do you mean by 'third party automated processes'?  If any are a business rule, how is that BR defined? As 'current.sys_id' is available to BRs. Sometimes, the sys_id needs to be converted to a string a value for use. But we have no idea what needs the sys_id of the record being built. An OnChange Client Script runs while a record is updated.

[tahnalos]

Not sure if a business rule will help.  Mostly because when the item is built on the Catalog Builder, I want to track the sys_id as the item is being built in the builder.  We have set up our catalog builder to automatically create a process in a third party application the moment the Catalog Builder is initiated.  I can't be more specific, but I can only tell you that the Catalog Builder has been customized to send instructions to the third party application.  What we're missing is the sys_id if the catalog item while it is in the builder.  That's what we are trying to get.  Once we have that info, we can plug it to our customization.

Is there any way to obtain this info?

Thanks