Not able to get all accounts from script include JSON

[Community Alums]

Hi Team,

Below is my Script Include:

 getAccountList: function() {

        var account = {};

        var accountList = [];

        var rel = new GlideRecord('sn_customerservice_contact_relationship');

        rel.addQuery('sys_id', this.getParameter('sysparm_sys_id'));

        rel.query();

        if (rel.next()) {

            var acc = new GlideRecord('customer_account');

            acc.addEncodedQuery('account_parent.account_pathSTARTSWITH' + rel.company.account_parent.account_path.getDisplayValue());

            acc.query();

            gs.info('Total Account Path Cos:' + acc.getRowCount());

            while (acc.next()) {

                account.name = acc.name.getDisplayValue();

                account.sys_id = acc.sys_id.toString();

            }

gs.info('Name of All accounts:'+account.name);  

            accountList.push(account);

        }

        return JSON.stringify(accountList);

    },

    type: 'GetAccountsAjax'

});

In  line gs.info('Total Account Path Cos:' + acc.getRowCount());  I am getting 3 records. But when I do

 gs.info('Name of All accounts:'+account.name);   This is giving me 3 records which is fine. But When I am pushing its not giving 3 records but 1.

[Astik Thombare · Accepted solution]

Hi @Community Alums  ,

I tried similar code in my PDI, which I shared with you, and it is working fine for me. Please have a look at the code and screenshots

Code -

var accountList = [];

var rel = new GlideRecord('sn_customerservice_contact_relationship');
rel.addQuery('sys_id','76d50803910b3410f87731ea9e8493d0');
rel.query();

if (rel.next()) {

  var acc = new GlideRecord('customer_account');
  acc.addEncodedQuery('nameSTARTSWITHBoxeo');
  acc.query();
  gs.info('Total Account Path Cos:' + acc.getRowCount());

  while (acc.next()) {
    var account = {}; // Create a new object for each record
    account.name = acc.name.getDisplayValue();
    account.sys_id = acc.sys_id.toString();
    accountList.push(account); // Add the object to the array
  }

  //gs.info('Name of All accounts:' + accountList[0].name); // This will print the first record's name (optional)
  gs.print( JSON.stringify(accountList));
}

   If my reply helped with your issue please mark helpful 👍 and correct ✔️ if your issue is resolved.

                         By doing so you help other community members find resolved questions which may relate to an issue they're having

Thanks,

Astik

[Astik Thombare · Accepted solution]

Hi @Community Alums  ,

I tried similar code in my PDI, which I shared with you, and it is working fine for me. Please have a look at the code and screenshots

Code -

var accountList = [];

var rel = new GlideRecord('sn_customerservice_contact_relationship');
rel.addQuery('sys_id','76d50803910b3410f87731ea9e8493d0');
rel.query();

if (rel.next()) {

  var acc = new GlideRecord('customer_account');
  acc.addEncodedQuery('nameSTARTSWITHBoxeo');
  acc.query();
  gs.info('Total Account Path Cos:' + acc.getRowCount());

  while (acc.next()) {
    var account = {}; // Create a new object for each record
    account.name = acc.name.getDisplayValue();
    account.sys_id = acc.sys_id.toString();
    accountList.push(account); // Add the object to the array
  }

  //gs.info('Name of All accounts:' + accountList[0].name); // This will print the first record's name (optional)
  gs.print( JSON.stringify(accountList));
}

   If my reply helped with your issue please mark helpful 👍 and correct ✔️ if your issue is resolved.

                         By doing so you help other community members find resolved questions which may relate to an issue they're having

Thanks,

Astik

[Sohail Khilji · Accepted solution]

Hi @Community Alums ,

try :

getAccountList: function() {
    var accountList = [];
    var rel = new GlideRecord('sn_customerservice_contact_relationship');
    rel.addQuery('sys_id', this.getParameter('sysparm_sys_id'));
    rel.query();
    if (rel.next()) {
        var acc = new GlideRecord('customer_account');
        acc.addEncodedQuery('account_parent.account_pathSTARTSWITH' + rel.company.account_parent.account_path.getDisplayValue());
        acc.query();
        gs.info('Total Account Path Count:' + acc.getRowCount());
        while (acc.next()) {
            var account = {};
            account.name = acc.name.getDisplayValue();
            account.sys_id = acc.sys_id.toString();
            gs.info('Name of Account: ' + account.name);
            accountList.push(account);
        }
    }
    return JSON.stringify(accountList);
},
type: 'GetAccountsAjax'