Sript

[Rosy14]

I have list of sys_ids. I want to get the name of corresponding sys_ids in a list

var bData=fd_data.trigger.current.u_select_buying_agent_account;

var bDataL=bData.split(',');

var nameL=[], email=[],i=0;

var gr ;

//= new GlideRecord('customer_contact');

//gr.addEncodedQuery("companyLIKEcasa^ORcompanyLIKEli & Fung");

//gr.query();

for(i=0;i<bDataL.lenght;i++)

{

    gr = new GlideRecord('customer_contact');

    gr.query('sys_id',bDataL[i].toString());

    gr.query();

    nameL[i] = gr.getDisplayName('first_name')+' '+gr.getDisplayName('last_name');

    email[i] = gr.getDisplayName('email');

}

return nameL;

Not working

Please help.

[Anurag Tripathi]

Hi,

USe this

var bData=fd_data.trigger.current.u_select_buying_agent_account;
var bDataL=bData.split(',');
var nameL=[], email=[],i=0;
var gr ;

for(i=0;i<bDataL.lenght;i++)
{
    gr = new GlideRecord('customer_contact');
    gr.addQuery('sys_id',bDataL[i].toString()); // This should be addQuery not query
    gr.query();
if(gr.next()) //you were missing this
{
    nameL[i] = gr.getDisplayName('first_name')+' '+gr.getDisplayName('last_name');
    email[i] = gr.getDisplayName('email');
 }  
}

return nameL;
 

[Rosy14]

Tried still not working

[Anurag Tripathi]

What did you try , can you show the script?

[Rosy14]

I am taking a list collector variable in flow, then spliting