ITSM

[KritiK]

how to update a reference field of a target table if short description of target table contains a number of source table using transform map.

if anyone knows please let me know quickly

[Animesh Das2]

Hi @KritiK ,

If I understood your question correctly, you want to update reference field of a target table.

I think you can't update a reference field directly through transform map field mapping. if you are sending a new reference field value then you can use 'Choice action' to do either of the below options,

1. Create: To create a new record in ref table with new value coming from source.

2. Reject: Reject that entire record entry/update to the target table and go to the next record to transform.

3. Ignore: To ignore the reference field population in target table (since you sent a different value other than what is present in the reference table).

You can try one thing and see if that works, Write a onBefore transform script to update the reference table value first, based on the source field value coming in and through which you will glidequery the reference table in the onBefore script and update the value. After the onBefore script updates the value, the field mapping should pick the updated reference field value from the reference table.

If this address your question, please mark this response correct by clicking on Accept as Solution and/or Kudos.

You may mark this helpful as well if it helps you.

Thanks, 

Animesh Das

[KritiK]

I have tried this piece of code but it's not working.If need any modification on this code please let me know quickly if you will give answer for very helpful for me

onBeforeTransform(sourceRecord, targetRecord, context)

{

var sourceNumber = sourceRecord.u_number;

gs.info("Number: " + sourceNumber);

var shortDescription = targetRecord.short_description;

gs.info("short description: " + shortDescription);

 if (shortDescription && shortDescription.includes(sourceNumber.toString()))

{

    gs.info("check if condition: " + shortDescription && shortDescription.includes(sourceNumber.toString()));

targetRecord.u_requested_for = sourceRecord.PRID_requested;

gs.info('testing'+sourceRecord.PRID_requested);

}

else {

context.abortAction();

}

[Animesh Das2]

Hi @KritiK ,

Firstly, can you please elaborate your requirement first a bit more?

Secondly, simple onBefore tranform script construct should start like this '(function runTransformScript(source, map, log, target /*undefined onStart*/ ) {'.

Thirdly, Does the value of sourceRecord.PRID_requested exist in the reference table from where u_requested_for is coming? If not then what you want to do and if yes then what you want to do?

I am struggling to figure out what exact requirement you have and how you are trying to achieve that?

If this address your question, please mark this response correct by clicking on Accept as Solution and/or Kudos.

You may mark this helpful as well if it helps you.

Thanks, 

Animesh Das

[KritiK]

This is the actual code is working for background script but not working in transform map showing ignore in transform history.
this is coming from the source which is reference field and same field need to update in target 'PRID_requested' 
(function runTransformScript(source, map, log, target /*undefined onStart*/ ) {

        var sourceNumber = source.u_number;

        var gr = new GlideRecord('Target Table name');

        gr.addEncodedQuery('short_descriptionLIKE' + sourceNumber);

        gr.query();

        if (gr.next()) {

            var grUser = new GlideRecord('sys_user');

            grUser.addQuery('user_name', source.PRID_requested);

            grUser.query();

            if (grUser.next()) {

                //     gr.u_requested_for = grUser.getUniqueValue();

                gr.setValue('u_requested_for', grUser.getUniqueValue());

                gr.update();

            }

        // }

    }

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