question Re: Onbefore Transform map not updating the record, only inserting even though matches with theCondi in GRC forum

Onbefore Transform map not updating the record, only inserting even though matches with theCondition

Community Alums — Mon, 01 Jul 2024 19:47:36 GMT

Following is my field map

following is onbefore script

here I am checking if entity and current_ram combination exits, if yes then update the record.

I am mapping ram with the expected ram

if combination does not exits then create new record

for reference this is the table and following is the form

Following is the script

(function runTransformScript(source, map, log, target /*undefined onStart*/ ) {

var up = new GlideRecord("sn_risk_advanced_risk_assessment_scope");

up.addEncodedQuery("entity.nameSTARTSWITH"+ source.u_entity + "^risk_assessment_methodology.nameSTARTSWITH" + source.u_current_ram);

up.query();

if(up.next())

{

action = 'update';

}

else{

ignore = true;

}

})(source, map, log, target);

Re: Onbefore Transform map not updating the record, only inserting even though matches with theCondi

Marco0o1 — Mon, 01 Jul 2024 21:14:12 GMT

Hi @Community Alums ,

You can just not use a scripted action and just put your u_expected_ram and u_entity as a Coalesce fields, this will have a similar result:

If that doesnt work to you maybe you can try not use a onbefore script and change to just run the script at the start because your script[onBefore] run when the record was already created:

Regards,

Marco

Re: Onbefore Transform map not updating the record, only inserting even though matches with theCondi

Community Alums — Tue, 02 Jul 2024 02:49:12 GMT

Hi @Marco0o1 ,

Tried running through run script still inserting record. I just want to update the record rather than inserting it.

Re: Onbefore Transform map not updating the record, only inserting even though matches with theCondi

Deepak Shaerma — Tue, 02 Jul 2024 03:18:42 GMT

Hi @Community Alums

Create a onBefore Transform Script and use the code below:

if(action == 'insert'){ ignore = true; }

Also make a field coalesce true through which you want to update the record.
Please Mark this Helpful and Accepted Solution. If this Helps you to understand. This will help both the community and me..
- Keep Learning ‌‌
Thanks & Regards
Deepak Sharma

Re: Onbefore Transform map not updating the record, only inserting even though matches with theCondi

Community Alums — Tue, 02 Jul 2024 03:32:29 GMT

Hi @Deepak Shaerma

Actually I can not use coalesce here, I want to check current_ram column with ram from target table, if combination exists then update it with expected RAM, can I update it in the script rather than Ignoring it.

Re: Onbefore Transform map not updating the record, only inserting even though matches with theCondi

Deepak Shaerma — Tue, 02 Jul 2024 03:40:47 GMT

try using this script"

Please Mark this Helpful and Accepted Solution. If this Helps you to understand. This will help both the community and me..
- Keep Learning ‌‌
Thanks & Regards
Deepak Sharma

Re: Onbefore Transform map not updating the record, only inserting even though matches with theCondi

Community Alums — Tue, 02 Jul 2024 05:56:22 GMT

Hi @Deepak Shaerma ,

target.update I can not use, they are having their best practice set while saving the code, throws error message target.update can not be used in onbefore