query.some()

This function calls a given closure/function with every element in a given query and returns true, if one of the closure calls returns true.

query.some( closure=function, parallel=boolean, maxThreads=number )

Returns: Boolean

Argument Description
closure
function, required

function/closure that implements the following constructor

function(struct row [, number rowNumber, query query]):boolean.

Alias: function, callback, udf

parallel
boolean, optional

execute closures parallel

maxThreads
number, optional

maximum number of threads executed, ignored when argument "parallel" is set to false

Alias: maxThreadCount

Examples

	people = QueryNew( "name,dob,age", "varchar,date,int", [
	    [ "Susi", CreateDate( 1970, 1, 1 ), 0 ],
	    [ "Urs" , CreateDate( 1995, 1, 1 ), 0 ],
	    [ "Fred", CreateDate( 1960, 1, 1 ), 0 ],
	    [ "Jim" , CreateDate( 1988, 1, 1 ), 0 ]
	]);

Dump( var=people, label="people - original query" );
/* Output:
| name | dob | age | ------------------------------------ | Susi | 1970-01-01 00:00:00 | 0 | | Urs | 1995-01-01 00:00:00 | 0 | | Fred | 1960-01-01 00:00:00 | 0 | | Jim | 1988-01-01 00:00:00 | 0 | */
// data validation - age between 0 and 120 valid = people.some(function(row, rowNumber, qryData){ return ((DateDiff('yyyy', row.dob, Now()) > 0) && (DateDiff('yyyy', row.dob, Now()) <= 100)) }); dump(var=valid, label='age between 0 and 120'); /* Output: true */
// data validation - age between 10 and 20 valid = people.some(function(row, rowNumber, qryData){ return ((DateDiff('yyyy', row.dob, Now()) > 1) && (DateDiff('yyyy', row.dob, Now()) <= 10)) }); dump(var=valid, label='age between 1 and 10'); /* Output: false */

See also