Record Producer Values in Service Portal Ticket Fields Widget

[Nia McCash]

On my personal dev instance, I noticed that the Ticket Fields widget shows "variables" for an Incident that was created via the Password Reset record producer.

Can someone advise on where this data is stored (ie. where is the relationship/link between the incident and the record producer stored) or how this is achieved?  

I was able to trace it to this line of code in the widget's Server Script data.variables = $sp.getVariablesArray(); but was unable to find documentation on https://developer.servicenow.com/app.do#!/api_doc?v=istanbul&id=c_GlideSPScriptableScopedAPI for the getVariablesArray() function.

[Nia McCash]

I've just discovered that in the Istanbul version, there is an sc_item_produced_record table which relates a Task (table: task) record to the Record Producer (table: sc_cat_item_producer) that created the Task.

However, I'm still not sure where the variables are stored.

I've checked the sc_item_option_mtom table and they do are not there as far as I can tell.

[bnsapna · Accepted solution]

Hello,

You could check 'question_answer' table

[Nia McCash]

Yes, that's the table I was looking for. Thank you.

[Nolan3]

Nia,

Thanks for posting this question.   Could you tell me how you were able to get a newly created Record producer to show the options when submitted via the service portal?

I am trying to get a record producer I created that is on the sc_req_item table to capture these variables to be displayed in the options under the Tickets widget.

Thanks for your help in advance!

Nolan