Fields are not populating after submitting record producer

sinu2
Tera Expert

HI Team,

 

I have a record producer. Inside record producer i have created a multi row variable set name calle d as "item_list". Inside multi row variable set i had 6 variables. 

As soon as i submit the record producer from portal,  A record is creating to that table but fields are showing empty.

So how can i map those MRVS variable content inside native view table fields?

\

I had created a before Business rule to map MRVS to table fields but not working

the MRVS log is showing error like below

 

find_real_file.png

(function executeRule(current, previous /*null when async*/) {

var value = current.variables.items_list; //  MRVS variable name here
	gs.log('Inside :', value);

var parser = JSON.parse(value);
gs.log(parser);
var addtable = new GlideRecord('x_pl4_move4u_item');

for(var i=0;i<parser.length;i++){

addtable.name = parser[i].name;
addtable.move_request = parser[i].move_request;
addtable.is_fragile = parser[i].is_fragile;
addtable.category = parser[i].category;
addtable.short_description = parser[i].short_description;
addtable.volume = parser[i].volume;
addtable.insert();

}

})(current, previous);
1 ACCEPTED SOLUTION

are you using correct variable name within mrvs here?

var parserList = JSON.parse(producer.items_list);

current.name = parserList[0].name;
current.move_request = parserList[0].move_request;
current.is_fragile = parserList[0].is_fragile;
current.category = parserList[0].category;
current.short_description = parserList[0].short_description;
current.volume = parserList[0].volume;

Regards
Ankur

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

View solution in original post

27 REPLIES 27

You dont have to glide in record producer script, there are two objects OOB : current and producer to update the record.

 

current.target_table_field_name = parser[0].name will work.


Raghav
MVP 2023

Ankur Bawiskar
Tera Patron
Tera Patron

Hi,

I consider your business rule is after insert on the target table of record producer

it seems you are not using correct variable set name

Regards
Ankur

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

HI ANkur,

 

My BR is in before insert not after and i used variavle set backend name.

 

find_real_file.png

please make BR as after insert.

Is your record producer target table different than x_pl4_move4u_item?

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

Nope. My record producer table and Br ara in same table x_pl4_move4u_item