Error in Business rule displaying the same sys_id

[mregragui_ext]

This is my BR when displaying the array of compnay i am having expected result here is the log 

array of company  FRPA88,C023

but when trying to get the sys_id like in the code i am getting diplicated sys_id of the first company 

Company to display : cd0a95371b1ef07206ea0ce54bcb58,cd0a95371b1ef07206ea0ce54bcb58

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

    // Add your code here

    var hrScopeManagementService = [];

    var departmentService = [];

    var hrLegalCompany = [];

    var legalCompany = [];

    var hrScopeManagement = new GlideRecord("u_hr_scope_mgmt");

    hrScopeManagement.addEncodedQuery("u_user=" + gs.getUserID());

    hrScopeManagement.query();

    while (hrScopeManagement.next()) {

        hrScopeManagementService.push(hrScopeManagement.u_services.toString());

        hrLegalCompany.push(hrScopeManagement.u_legal_entities.toString());

    }

    gs.info('array of departement' + hrScopeManagementService.toString() );

    gs.info('array of company' + hrLegalCompany.toString() );

    //Department or service

    var department = new GlideRecord("cmn_department");

    department.addEncodedQuery("idIN" + hrScopeManagementService);

    department.query();

    while (department.next()) {

        departmentService.push(department.sys_id);

    }

    //Company or legal entity

    var company = new GlideRecord("core_company");

    company.addEncodedQuery("u_idIN" + hrLegalCompany);

    company.query();

    while (company.next()) {

        legalCompany.push(company.sys_id);

    }

    // Now filter HR Profiles

    current.addEncodedQuery("user.department.sys_idIN"+departmentService.join(",")+'^ORu_etablissement_juridique.sys_idIN'+legalCompany.join(",")); // Apply

    // Log result

    gs.info("department to display : "+ departmentService.join(","));

    gs.info("Company to display : "+ legalCompany.join(","));

})(current, previous);

This is my BR when displaying the array of compnay i am having expected result here is the log 

array of company  FRPA88,C023

but when trying to get the sys_id like in the code i am getting diplicated sys_id of the first company 

[Brad Bowman · Accepted solution]

Any time you use a sys_id in a GlideRecord, you need to force it .toString() or use getValue so that you don't retrieve the position in memory, which will result in an array of the same sys_id in this case:

departmentService.push(department.getValue('sys_id'));

[Ankur Bawiskar · Accepted solution]

@mregragui_ext 

try this

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

    // Add your code here
    var hrScopeManagementService = [];
    var departmentService = [];
    var hrLegalCompany = [];
    var legalCompany = [];

    var hrScopeManagement = new GlideRecord("u_hr_scope_mgmt");
    hrScopeManagement.addEncodedQuery("u_user=" + gs.getUserID());
    hrScopeManagement.query();
    while (hrScopeManagement.next()) {
        hrScopeManagementService.push(hrScopeManagement.u_services.toString());
        hrLegalCompany.push(hrScopeManagement.u_legal_entities.toString());
    }
    gs.info('array of department: ' + hrScopeManagementService.toString());
    gs.info('array of company: ' + hrLegalCompany.toString());

    // Department or service
    var department = new GlideRecord("cmn_department");
    department.addEncodedQuery("idIN" + hrScopeManagementService.join(','));
    department.query();
    while (department.next()) {
        departmentService.push(department.sys_id.toString());
    }

    // Company or legal entity
    var company = new GlideRecord("core_company");
    company.addEncodedQuery("u_idIN" + hrLegalCompany.join(','));
    company.query();
    while (company.next()) {
        legalCompany.push(company.sys_id.toString());
    }

    // Now filter HR Profiles
    current.addEncodedQuery("user.department.sys_idIN" + departmentService.join(",") + '^ORu_etablissement_juridique.sys_idIN' + legalCompany.join(","));
    
    // Log result
    gs.info("department to display: " + departmentService.join(","));
    gs.info("Company to display: " + legalCompany.join(","));

})(current, previous);

If my response helped please mark it correct and close the thread so that it benefits future readers.

[mregragui_ext]

Exactly what i want Thanks to all of you !

[terrillc]

did you find the solution