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

[Elizabeth26]

I am not sure how to get them to match. I did try a query like you showed above but how do I get a 1:1 match like this sys id = this record #

[Anurag Tripathi]

How are you trying? Some script or something?

[Elizabeth26]

I was just trying to do a query in SN and then export to excel and match things up.

I can get the sys id of the record but how do I match that up to the actual record number? I have hundreds of sys ids I need to match to record numbers.