record producer variable reporting

[Ravish Shetty]

hi all

which is a table where the variable to value information is stored for requests created using record producers?

[The Machine · Accepted solution]

The question_answer table is where its at.

[Uncle Rob]

For everything but the MRVS, which has its own question answer table.
#headdesk

[jammer]

Robert,

I've seen a few posts in this forum that say to look at the question answer table for record producer variable values.  

I agree that upon submission of a record producer form, the variable values are stored in the question answer table.  

But, what I'm seeing on my end is that those variable values don't get updated if a user changes the value at some point after submission.  Is this the expected behavior?

For example, I have a record producer that inserts a row into the Incident table.  Let's say the record producer form has a variable for 'Category'.  This is a select box and has just 2 options for simplicity... Category One and Category Two.  During the initial submit, I select Category One.  I can see in the question answer table that there is a row where category is 'Category One'.  Looks good at this point.  Then, I open that Incident that was created by the record producer and I change the category to 'Category Two' and save the form.  Now, when I check the question answer table again, it still shows category is 'Category One'.  The question answer table doesn't update variable values if they get changed after the form is submitted.  This seems odd to me that those variable values don't get updated in question answer table.

[Uncle Rob]

Hard to say.  Incident has its own field called Category.  
One of the mystical magical things about Record Producers is that if you have a variable with the same name as the destination table column, the value will be mapped automagically ON CREATION.

So if you're updating incident.category, there's no reason why the variable would also change.
If you're changing the variable itself, there's got to be some kind of mistake because a variable's answer is stored in one and only one place.