how to map the variables values from a MULTI ROW VARIABLE SET variables to a custom table .

surya76
Tera Contributor

Created a multi row variable set in portal:

image

these are getting to a RITM in my requested items . from there how to map MULTI ROW VARIABLE SET variables to a custom table

how to map the variables values from a MULTI ROW VARIABLE SET variables to a custom table .

i am able to map the variables values from a single row variable set to a custom table using a business rule to run run on set_req_item table :

var cret = new GlideRecord('u_police_fir');
cret.initialize();
 cret.fir_type = current.variables.case_no;
cret.insert();

 

HOW TO DO THE SAME FOR MULTI ROW VARIABLE SET:

when i click on request in service portal

Row 1=>date and location to be mapped in a ticket =>1001

Row 2=>date and location to be mapped in a ticket =>1002

Row 3=>date and location to be mapped in a ticket =>1003

For every row an individual ticket should be created

In ticket 1001 contains u_date field and u_location field

There Row 1=>date and location to be mapped in a ticket

In ticket 1002 contains u_date field and u_location field

Row 2=>date and location to be mapped in a ticket =>1002

In ticket 1003 contains u_date field and u_location field

There Row 3=>date and location to be mapped in a ticket

 

5 REPLIES 5

@Wasim9 

Due to recently community platform many links got archived.

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader