How to access to the values of a MultiRow Variable Set in a Business rules

Facundo Prado
Tera Expert

Hi!! I need to get the values form a MultiRow Variable Set in a business rules. Because I need to populate this values (from MRVS) into a new table.

MRVS:

FacundoPrado_3-1682536642274.png

FacundoPrado_2-1682536638986.png

 


Business Rule:

FacundoPrado_1-1682536582068.png

FacundoPrado_0-1682537826737.png

 



I need to populate those values into a new table.

New table:

FacundoPrado_4-1682536742997.png


Thanks

6 REPLIES 6

DrewW
Mega Sage
Mega Sage

You posted a bunch of screen shots.  Does the code you posted not work?

Last time I did anything with a MRV's I did

 

var mrv = JSON.parse("" + current.variables.MRV_VAR_NAME);

 

and that gave me an array of objects that had the rows of the MRV and each column could be accessed by doing

 

mrv[0].FIELD1

mrv[0].FIELD2

mrv[0].FIELD3

 

So what exactly is the issue?  Does your code not work?  Is it throwing an error and if so what is it?

 

My code is not working... I create a ticket but I cant populate the values of the MRVS into the table

So have you tried

var mrv = JSON.parse("" + current.variables.booking_details);

 

and then something like this to get at the values

mrv[0].FIELD1

mrv[0].FIELD2

mrv[0].FIELD3

 

Yes, I have.. And I find this error on Logs

FacundoPrado_0-1682539049977.png