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.