QueryEvery

Executes a callback/closure against every row in a query and returns true if the callback/closure returned true for every row.

Method Signature

QueryEvery(query=[query], closure=[function:Predicate], parallel=[boolean], maxThreads=[integer])

Arguments

Argument	Type	Required	Description	Default
query	query	true	The query to iterate over
closure	function:Predicate	true	The function to invoke for each item. The function will be passed 3 arguments: the row, the currentRow, the query. You can alternatively pass a Java Predicate which will only receive the 1st arg.
parallel	boolean	false	Specifies whether the items can be executed in parallel	false
maxThreads	integer	false	The maximum number of threads to use when parallel = true

Examples

All values greater than 50

Find out if every value in the query is greater than 50

<bx:script>
	data = query( foo=[
		51,
		52,
		535
	] );
	allGT50 = queryEvery( ( Any row ) => {
		return row.FOO > 50;
	} );
</bx:script>

Result: true

Additional Examples

Run Example

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.every( ( Any row, Any rowNumber, Any qryData ) => {
	return ((DateDiff( "yyyy", row.DOB, Now() ) > 0) && (DateDiff( "yyyy", row.DOB, Now() ) <= 100));
} );
dump( var=valid, label="valid - age between 0 and 120" );
/* Output: true */
// data validation - age between 40 and 50
valid = people.every( ( Any row, Any rowNumber, Any qryData ) => {
	return ((DateDiff( "yyyy", row.DOB, Now() ) > 40) && (DateDiff( "yyyy", row.DOB, Now() ) <= 50));
} );
dump( var=valid, label="valid - age between 40 and 50" );
 /* Output: false */

Related

• QueryRecordCount

• QueryColumnList

• QueryRowSwap

• QuerySort

• QueryEach

• QueryKeyExists

• QueryColumnCount

• QueryReduce

• QueryCurrentRow

• QueryColumnData

• QueryRowData

• QueryFilter

• QueryAddRow

• QueryNew

• QueryReverse

• QueryPrepend

• QueryColumnExists

• QueryAddColumn

• QueryGetCell

• QueryGetResult

• QueryMap

• QueryRecordCount

• QuerySome

• QueryDeleteColumn

• QuerySetCell

• QueryInsertAt

• QueryClear

• QuerySetRow

• QueryColumnArray

• QueryDeleteRow

• QueryAppend

• QuerySlice

• QueryRegisterFunction