Adding RITM variables in Database view for RITM and Approvers

[Ravish Shetty]

is it possible to add sc_req_item variables in a database view between sysapproval_approver and sc_req_item? when i try to generate a report on this DB view, i cannot select the variables for filtering or for report columns.

[poyntzj]

You need to look and use the sc_item_option_mtom table.  Going to get one row per question though

[Ravish Shetty]

they were just interested in one variable which was a reference field pointing to sys_user. as values are stored as sys_id, I had to combine multiple tables here to get the final result. Not sure if thee is an easy way to do this.

[Prateek kumar]

Why not create a field on RITM table, make it calculated and fill it with variable value.

[Ravish Shetty]

we would like to keep custom fields to a minimum. it's like adding 1 field in RITM table for this 1 user. imagine if 100 others come up with such requirement.