// JWJ0215 10.30.24         -       Last tested on 10.30 @ 2.42 pm

// Project Insight Update Script

// This script will get needed data from the ServiceNow Project Request (before approved for a project), and

// push the data to Project Insight.

 

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

    var payload = {};

 

    // get user from user table

    var gr = new GlideRecord("sys_user");

    gr.addQuery("sys_id", current.requested_for);

    gr.query();

 

    if (gr.next()) {

        payload.requested_for = gr.email.toString();

    }

    // ***End get user***

 

    // Get Project Insight Records from the project Insight table **U_PROJECT_INSIGHT_RECORDS**

    // get the sys id

    var pigr = new GlideRecord("u_project_insight_records");

    pigr.addQuery("u_requested_item", current.sys_id);

    pigr.query();

 

    if (pigr.next()) {

        payload.u_project_insight_records_sysid = pigr.sys_id.toString();

        payload.u_project_insight_records_number = pigr.number.toString();

        payload.u_prioritization_group = pigr.u_prioritization_group.toString();

        payload.priority = pigr.priority.getDisplayValue();

        payload.u_expense = pigr.u_expense.toString();

        payload.u_project_request_status = pigr.u_project_request_status.toString();

        payload.short_description = pigr.short_description.toString();

        payload.description = pigr.description.toString();

        payload.u_status = pigr.u_status.toString(); // trying u_status

       

       

    }

 

        // Grab the Description from the task table ******************************************

    gr = new GlideRecord("task");

    gr.addQuery('description');

    gr.query();

 

    if (gr.next()) {

        gr.description.toString();

    }




    gr = new GlideRecord("sys_user");

    gr.addQuery("sys_id", current.variables.sponsor_manager_and_up_only_for_this_field);

    gr.query();

 

    if (gr.next()) {

        payload.sponsor_manager_and_up_only_for_this_field = gr.email.toString();

    }

 

    gr = new GlideRecord("sys_user");

    gr.addQuery("sys_id", current.variables.contact_name);

    gr.query();

 

    if (gr.next()) {

        payload.contact_name = gr.name.toString();

    }

 

    // which_location_is_the_project_for

    gr = new GlideRecord("cmn_department");

    gr.addQuery("sys_id", current.variables.which_location_is_the_project_for);

    gr.query();

 

    if (gr.next()) {

        payload.cost_center = gr.name.toString();

    }

 

    // ***End get Project Insight Records***

 

    // below information is from the **SC_REQ_ITEM** table.

    payload.sys_id = current.sys_id.toString();

    payload.u_project_approved_date = current.u_project_approved_date.toString();

    payload.number = current.number.toString();

    payload.u_project_type = current.u_project_type.toString();

    payload.request_created_on = current.variables.request_created_on.toString(); //sc_req_item  

    payload.contact_s_phone_number = current.variables.contact_s_phone_number.toString(); //sc_req_item

    payload.what_is_the_problem_you_are_trying_to_solve = current.variables.what_is_the_problem_you_are_trying_to_solve.toString();

    payload.u_estimated_hours = current.u_hours.toString();  // trying u_hours

 

    var PI = new ProjectInsightScriptInclude();

    var res = PI.send(payload);

 

})(current, previous);

 

//  Link

//  https://<instance>.service-now.com/now/nav/ui/classic/params/target/sys_script.do%3Fsys_id%3Da982dcdf87389e10fdd876a6cebb35ab%26sysparm_view%3D%26sysparm_record_target%3Dsys_script%26sysparm_record_row%3D2%26sysparm_record_list%3DORDERBYDESCsys_created_on%26sysparm_record_rows%3D6275