QuerySome()

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.

QuerySome( query=query, closure=function, parallel=boolean, maxThreads=number );

Returns: Boolean

Argument Description Default
query
query, required

query to iterate

Alias: object

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

20

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 ]
	]);
	valid = querySome(people,function(row, rowNumber, qryData){
	    return ((DateDiff('yyyy', row.dob, Now()) > 0) && (DateDiff('yyyy', row.dob, Now()) <= 100))
	});
	writeDump(valid);

See also