Multirow Variable set in Record Producer

[reginabautista]

Hi guys,

I have implemented multi row variable set in a record producer. Would anyone know how could I access the variable responses?

The solution that I see here points to sc_req_item which I don't have. I checked question_answer table also where the variable responses for record producers are stored but I couldn't find the responses entered in the multi row variable set. 

Has anyone implemented MRVS in a record producer and accessed the values? Thanks in advance - Regina

[reginabautista]

There seems to be a solution here. Trying this out now. 

[reginabautista · Accepted solution]

Hi guys

I was able to access the multirow variable set responses via a Business Rule. Please note that in the MRVS, the id that you need to pass is NOT the variable set name but rather the internal name. This wasn't visible on the form by default so you may need to bring this out or check value via Show XML. Hope this helps!

[Shubham Dhawan2]

Do we need to create this business Rule separately or is it present by default?

[Andrew Bettcher]

Hi Regina - I hope you're OK.

For this, I note that you refer directly to the MRVS. I'm looking for a way to do something similar that will work for ANY MRVS on a form.

The idea is that it will look for an MRVS and then create a RITM per row that contains all of the variables. I believe that the only way to do this is to push them all into a comment but I'm struggling to separate the array out per row. Are you able to advise?