How to set manufacturer field to true in transform script

[Mayuri1711]

answer = (function transformEntry(source) {

    if(source.u_manufacturer){

    var gr_Manufacturer = new GlideRecord("core_company");

        gr_Manufacturer.addQuery('name', source.u_manufacturer);

        gr_Manufacturer.addQuery('u_source', source.u_data_source__manufacturer_);

        gr_Manufacturer.addQuery('u_external_id', 'CONTAINS', source.u_external_id__manufacturer_);

        gr_Manufacturer.query();

    if(gr_Manufacturer.next()){

        return gr_Manufacturer.sys_id;

    }

}

})(source);
After the 8th line need to add one more line where manufacturer field is true 

[vipinmathew · Accepted solution]

Hi @Mayuri1711 

Assume that you are using onBefore Transform Script 

updated the script with RED color

answer = (function transformEntry(source) {

    if(source.u_manufacturer){

    var gr_Manufacturer = new GlideRecord("core_company");

        gr_Manufacturer.addQuery('name', source.u_manufacturer);

        gr_Manufacturer.addQuery('u_source', source.u_data_source__manufacturer_);

        gr_Manufacturer.addQuery('u_external_id', 'CONTAINS', source.u_external_id__manufacturer_);

        gr_Manufacturer.query();

    if(gr_Manufacturer.next()){

            gr_Manufacturer.manufacturer = true;

           gr_Manufacturer.setWorkflow(false);

           gr_Manufacturer.update();

        return gr_Manufacturer.sys_id;

    }

}

})(source);

Assume that you are using field advanced Script 

answer = (function transformEntry(source) {

    if(source.u_manufacturer){

    var gr_Manufacturer = new GlideRecord("core_company");

        gr_Manufacturer.addQuery('name', source.u_manufacturer);

        gr_Manufacturer.addQuery('u_source', source.u_data_source__manufacturer_);

        gr_Manufacturer.addQuery('u_external_id', 'CONTAINS', source.u_external_id__manufacturer_);

        gr_Manufacturer.query();

    if(gr_Manufacturer.next()){

           return true;

    }

}

Please let me know if it works.

happy to help you 🙂 

Thank You 

Vipin Mathew

[SunilKumar_P]

Hi @Mayuri1711 , I think you are using the source script in the field mapping. If yes, you need to

return the true and select the required field in the target field.

answer = (function transformEntry(source) {

    if (source.u_manufacturer) {

        var gr_Manufacturer = new GlideRecord("core_company");

        gr_Manufacturer.addQuery('name', source.u_manufacturer);

        gr_Manufacturer.addQuery('u_source', source.u_data_source__manufacturer_);

        gr_Manufacturer.addQuery('u_external_id', 'CONTAINS', source.u_external_id__manufacturer_);

        gr_Manufacturer.query();

        if (gr_Manufacturer.next()) {

            return true;

        }

    }

})(source);