question Re: GlideRecord Query within Loop Not Working in ITSM forum

GlideRecord Query within Loop Not Working

sareshnaroji — Thu, 25 Aug 2016 11:36:18 GMT

Hello,

We have an Wrapper Function with GlideRecord Query called within a For loop. The GlideRecord Query executes for the first time. However, for subsequent iterations .next(), .has next() returns false.

Any suggestion on using a GlideRecord Query within a for loop will be highly appreciated.

Regards,
Saresh

Re: GlideRecord Query within Loop Not Working

tanumoy — Thu, 25 Aug 2016 11:41:09 GMT

Could you please post your code here.

Re: GlideRecord Query within Loop Not Working

sareshnaroji — Thu, 25 Aug 2016 15:14:20 GMT

OnBefore Business Rule Insert/Update

getAffectedClients();

function getAffectedClients(){

var affected_clients = current.u_affected_clients.getDisplayValue(); //affected clients list

var array_clients = affected_clients.split(",");

if(array_clients.length !=0){

for(var count =0; count < array_clients.length; count++){

getRelManagers(array_clients[i]);

}

function getRelManagers(rm_name){

var gr_rm = new GlideRecord('u_rel_mamager_list');

gr_rm.addQuery("u_client_name", rm_name);

gr_rm.query(); //only first iteration runs successfully

while (gr_rm.next()) { //does not iterate second time gr_rm.next returns false

var rel_manager = gr_rm.email.toString();

gs.addInfoMessage(rel_manager); //prints only records of first array object

gs.eventQueue("affectedclients.notify", current, rm_name, rel_manager);

}

Re: GlideRecord Query within Loop Not Working

Abhinay Erra — Thu, 25 Aug 2016 15:20:32 GMT

Saresh,

Use this script

getAffectedClients();

function getAffectedClients(){

   var affected_clients = current.u_affected_clients.getDisplayValue();

   if(affected_clients.length!=0){//affected clients list

   getRelManagers(affected_clients);

}



function getRelManagers(rm_name){

   var gr_rm = new GlideRecord('u_rel_mamager_list');

   gr_rm.addQuery("u_client_name",'IN', rm_name);

   gr_rm.query();           //only first iteration runs successfully

   while (gr_rm.next()) {   //does not iterate second time gr_rm.next returns false

   var rel_manager = gr_rm.getValue('email');

   gs.addInfoMessage(rel_manager); //prints only records of first array object

   gs.eventQueue("affectedclients.notify", current, rm_name, rel_manager);

}

}

}

Re: GlideRecord Query within Loop Not Working

tanumoy — Thu, 25 Aug 2016 15:54:18 GMT

Try something like below:

getAffectedClients();

function getAffectedClients(){

var affected_clients = current.u_affected_clients.getDisplayValue(); //affected clients list

var array_clients = affected_clients.split(",");

if(array_clients.length !=0){

for(var count =0; count < array_clients.length; count++){

getRelManagers(array_clients[count]);

}

function getRelManagers(rm_name){

var gr_rm = new GlideRecord('u_rel_mamager_list');

gr_rm.addQuery("u_client_name", rm_name);

gr_rm.query(); //only first iteration runs successfully

while (gr_rm.next()) { //does not iterate second time gr_rm.next returns false

var rel_manager = gr_rm.email.toString();

gs.addInfoMessage(rel_manager); //prints only records of first array object

gs.eventQueue("affectedclients.notify", current, rm_name, rel_manager);

}

Re: GlideRecord Query within Loop Not Working

Abhinay Erra — Thu, 25 Aug 2016 16:01:38 GMT

This is incorrect. Why are you using current.rm_name?? rm_name is just a parameter passed to the function.

Re: GlideRecord Query within Loop Not Working

sareshnaroji — Thu, 25 Aug 2016 16:01:58 GMT

Thanks Abhinay, but affected_clients is a list and i want to process each of the list items with the GlideRecord.

Let me try this and see if it works

Tanumoy,

getRelManagers(array_clients[count]); "i" was a typo from my side

Thanks

Re: GlideRecord Query within Loop Not Working

Abhinay Erra — Thu, 25 Aug 2016 16:03:29 GMT

You can always pass the entire thing and use IN operator in the glideRecord query. You do not need for loop at all.

Re: GlideRecord Query within Loop Not Working

tanumoy — Thu, 25 Aug 2016 16:06:05 GMT

Sorry for the mistake. corrected it.

Re: GlideRecord Query within Loop Not Working

Abhinay Erra — Thu, 25 Aug 2016 16:07:18 GMT

Np. Just letting you know

Re: GlideRecord Query within Loop Not Working

sareshnaroji — Fri, 26 Aug 2016 13:18:49 GMT

Thank you Abhinay, passing the entire list works fine for looping within the list items