Regarding archived requested item records

[bonsai]

I archived some "Requested Item" records because the number of records had increased.
Although records were created in the "ar_sc_req_item" table,
I was unable to view the contents of the Variable Editor field.

Is there a way to check the contents?
I would like to view them without restoring the records from the archive.

[Sandeep Rajput]

@bonsai The only way you can do this is by either creating a database view between ar_sc_req_item, sc_item_option_mtom and sc_item_option or by writing a background script to show fetch the data from sc_item_option_mtom and sc_item_option table by providing the sys_id of RITM. Once an RITM is archived it looses gets stored in ar_sc_req_item table and it looses links to sc_item_option_mtom and sc_item_option where the variable information is usually stored.

[Tanushree Maiti]

Hi @bonsai 

No, you cannot view the Variable Editor UI Formatter directly on archived records.

By design, ServiceNow's Variable Editor is a specialized formatter built exclusively to render on active tables like sc_req_item. It does not function on archive tables (ar_sc_req_item).

Refer: KB2446568 Service Catalog — Variables Not Visible on RITM or SC Task After Record Is Archived 

Resolution

1. Restore the archived record using the Restore Archived Data function in the System Archiving module.
2. After restoring the record, the variables associated with the request item or service catalog task will be visible on the RITM or SC Task form.

[Sarthak Kashyap]

Hi @bonsai 

If you want to check for particular RITM you can also glide on sc_item_option_mtom with RITM sys_id check below script 

var gr = new GlideRecord('sc_item_option_mtom');
gr.addQuery('request_item', '504a13c983c24f105efeb5a6feaad3d5');
gr.query();

while (gr.next()) {
    gs.info("Catalog Item Variable name = " + gr.sc_item_option.item_option_new.getDisplayValue() + ' & Value  = ' + gr.sc_item_option.value);
    gs.info("RITM = " + gr.request_item.getDisplayValue());

}

Please mark my answer correct and helpful if this works for you

Thanks and Regards,

Sarthak