Record producer table?

[Elizabeth26]

I discovered we had an issue with record producers not copying the contents of the form to the record/case in the destination table. This happened for many years it didn't have anything on the form the customer inputted.

I was wondering if when a record producer is submitted if all of the contents are stored anywhere with all the fields the customer inputted? I was looking for something like sc_req_item table but for record producers?

Does such a thing exist?

Thanks!

[Anurag Tripathi · Accepted solution]

Hi,

When a record producer is submitted you can find the Variables and values entered by a user on question_answer table.

I just created an incident via record producer and here are the values i entered

[Anurag Tripathi · Accepted solution]

Hi,

When a record producer is submitted you can find the Variables and values entered by a user on question_answer table.

I just created an incident via record producer and here are the values i entered

[Sandeep Rajput · Accepted solution]

@Elizabeth26 The record producers are stored in sc_cat_item_producer table.

The responses are stored in Question Answer (question_answer)table.

[Elizabeth26]

Thank you the question_answer table had the information I need. 

Is there any way to tie this information back to a specific record/case? 

[Anurag Tripathi]

Hey,

You can use Table and Table sys id field on the question answer table to tie this to the parent record.

Table refers to the table of course and table sys id is the record's sys id on the table(eg incident record)