How to break GlideQuery forEach loop

TT3 · ‎12-23-2021

I have below script, I need to exist the loop when variable i is 2. However, break or return statement does not work here and ServiceNow keeps iterating till the end.

Any idea about how to exist foeEach?

var i = 0;
//There are 4 records with this condition
new GlideQuery(Constants.Order_Item_Table)
	.where('u_parent_inventory_id', '123')
	.select('u_inventory_id')
	.forEach(function (orderItem) {
  	   gs.print(orderItem.u_inventory_id);
           i=i+1;
  	   gs.print(i);
           if (i == 2){
  	    gs.print('in if'); //It prints, but continues with loop
            return;
           }
	});

Hitoshi Ozawa · ‎12-23-2021

To break out, throw an exception instead of return.

Example:

var BreakException = {};

try {
    var i = 0;
    //There are 4 records with this condition
    new GlideQuery(Constants.Order_Item_Table)
        .where('u_parent_inventory_id', '123')
        .select('u_inventory_id')
        .forEach(function(orderItem) {
            gs.print(orderItem.u_inventory_id);
            i = i + 1;
            gs.print(i);
            if (i == 2) {
                gs.print('in if'); //It prints, but continues with loop
                throw BreakException;
            }
        });
} catch (e) {
    if (e != BreakException) throw e;
}

Else, use GlideRecord instead when there is a need to break.

var i = 0;
var gr = new GlideRecord(Constants.Order_Item_Table);
gr.addQuery('u_parent_inventory_id', '123');
gr.query();
while (gr.next()) {
  var id = gr.u_parent_inventory_id;
  gs.print(gr.u_inventory_id);
  i=i+1;
  gs.print(i);
  if (i == 2){
    gs.print('in if'); //It prints, but continues with loop
    return;
  }
}

View solution in original post

vkachineni · ‎12-23-2021

can you try

break;

instead of return;

Please mark Correct and click the Thumb up if my answer helps you resolve your issue. Thanks!
Vinod Kumar Kachineni
Community Rising Star 2022

vkachineni · ‎12-23-2021

Is there a selectOne option instead of selecting more and looping

Please mark Correct and click the Thumb up if my answer helps you resolve your issue. Thanks!
Vinod Kumar Kachineni
Community Rising Star 2022

Allen Andreas · ‎12-23-2021

Hi,

You could just use .limit()?

It's preferable to use this before your .select line, example:

new GlideQuery('task')
    .orderBy('priority')
    .limit(10) // Good: calling GlideQuery's limit method
    .select('assigned_to', 'priority', 'description')
    .forEach(generateReport);

https://developer.servicenow.com/blog.do?p=/post/glidequery-p6/

Please mark reply as Helpful/Correct, if applicable. Thanks!

Please consider marking my reply as Helpful and/or Accept Solution, if applicable. Thanks!

TT3 · ‎12-23-2021

Actually, there is some check in forEach, just to make question simple I didn't mentioned here. However, based on check I would like to stop looping and come out of forEach.