Find the table name of Table sys id in attachments - Before catalog item submission

[Anish Reghu]

Dear experts,

The Table sys id highlighted in the pic above, how do I find the table name of that sys_id?

It is not sc_cat_item nor is it, sc_cart_item.

This is the attachment entry created before submission of the catalog item.

Regards,

Anish

[Ankur Bawiskar · Accepted solution]

@Anish Reghu 

It seems you are adding file to some record producer or catalog item during submission

The sysId you are seeing is not any record of some table

It's a temporary GUID which ServiceNow generates and links it to sc_cart_item table during catalog form submission

More detailed discussion here

Is there a way to get the cart item id in portal

Regards
Ankur

[cmcdowellaus]

I recently had this same requirement and i was able to obtain the value from the angular element.

The attachment object is found at: window.angular.element('#sc_cat_item').scope().$parent.attachmentHandler

I was able to get the following values in a client script using the following paths:

var tableName = window.angular.element('#sc_cat_item').scope().$parent.attachmentHandler.tableName;

var tableId = window.angular.element('#sc_cat_item').scope().$parent.attachmentHandler.tableId;

Hope this helps someone.

Regards

Chris

[aniruddhnow]

Hi @Anish Reghu ,

Go to the Global Search and search for this sys_id so you will get the record.

Open that record and in the URL bar, you will find the table name.

Thanks,

Aniruddha Dhandar