What table(s) hold the variable and variable values for a request item?

[stevezadroga]

Team,

What table or tables in the database schema hold the variables and variable values?  For example, when I view a Request Item there is a section called variables with fields and values.  I am trying to understand what table or tables holds these values.  Ultimately, I am looking to JOIN these variable fields and values to the sc_req_item table.

[stevezadroga]

Troy,

Do you know what fields (keys) I should use to JOIN these 3 tables?  Assuming sys_id will be used...

[Troy Riblett · Accepted solution]

M2M table to request item
sc_item_option_mtom.request_item = sc_req_item.sys_id

M2M table to variable
sc_item_option_mtom.sc_item_option = sc_item_option.sys_id

[Bob Reynolds]

How do I adjust the size of variable table in the task form to show all the checkbox variable sets? They're complete in the RITM form but are truncated in the task form. 

[pradeep dasari]

Hi @stevezadroga , I have the same requirement, most challenging part is for reference variable the values are in sysid's and which cannot be dot walked as they are in value field(string) how did you fetched their display values could you share your code.

[milesallsmyles]

did you ever figure this out?