How to break or return from DataTable() each() function

jkrishna

In my DataTable one of the column as unique values , I want to iterate through the column to find the one of the unique value & get the rowIndex , I tried using each() , I am able to get the rowIndex of the matched column value , but could not break the loop using return statement , is there any other way to break the each() function when a condition is met .I have 10,000 records so the each() function is iteration the 10000 records even when a match is found in 5th record.

Ref: https://datatables.net/reference/api/each()
Test code:

var count=0;
var temp="10021"
var table = $('#example').DataTable();
    table.column( 0 ).data().each( function ( value, index ) {
    count++;
    if(value == temp)
        { console.log("matched rowIndex"+index); return true;   
        }

} );
console.log("count="+" count)

I always get count=10000 , even the matched column rowIndex is 5.

tangerine

From the docs:

The each() method is a proxy for the Javascript Array.prototype.forEach method

Further research reveals this note:

Note: There is no way to stop or break a forEach() loop other than by throwing an exception.

https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Array/forEach

jkrishna

Thank you tangerine, is there any other alternative effective way to get the rowIndex.

allan

You could use rows().indexes() to get an array of indexes and then use a standard for loop to spin over it. You can then break out of that.

Allan

jkrishna

Than you allan.