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

Method Signature

QuerySome(query=[query], callback=[function:Predicate], parallel=[boolean], maxThreads=[integer], initialValue=[any])

Arguments

Argument	Type	Required	Description	Default
query	query	true	The query to iterate over
callback	function:Predicate	true	The function to invoke for each item. The function will be passed 3 arguments: the row, the currentRow, the query.
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
initialValue	any	false

Examples

The simple Querysome example

Here,we've example to check whether the 75 is exists or not in myquery mark column value.

<bx:script>
	myQuery = queryNew( "id,name,mark", "integer,varchar,integer", [
		[
			1,
			"Rahu",
			75
		],
		[
			2,
			"Ravi",
			80
		]
	] );
	result = querySome( myQuery, ( Any details ) => {
		return details.MARK == 75;
	} );
	writeOutput( (result ? "Some" : "No") & " matches  Record found!" );
</bx:script>

Result: Some matches Record found!

The Query Member Function example

Here,we've example to check whether the 85 is exists or not in myquery mark column value using query member function.

<bx:script>
	myQuery = queryNew( "id,name,mark", "integer,varchar,integer", [
		[
			1,
			"Rahu",
			75
		],
		[
			2,
			"Ravi",
			80
		]
	] );
	result = myQuery.Some( ( Any details ) => {
		return details.MARK == 85;
	} );
	writeOutput( (result ? "Some" : "No") & " matches  Record found!" );
</bx:script>

Result: No matches Record found!

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

Related

• QueryRecordCount

• QueryColumnList

• QueryRowSwap

• QuerySort

• QueryEach

• QueryKeyExists

• QueryColumnCount

• QueryReduce

• QueryCurrentRow

• QueryColumnData

• QueryRowData

• QueryFilter

• QueryAddRow

• QueryNew

• QueryReverse

• QueryPrepend

• QueryColumnExists

• QueryAddColumn

• QueryGetCell

• QueryGetResult

• QueryMap

• QueryEvery

• QueryRecordCount

• QueryDeleteColumn

• QuerySetCell

• QueryInsertAt

• QueryClear

• QuerySetRow

• QueryColumnArray

• QueryDeleteRow

• QueryAppend

• QuerySlice

• QueryRegisterFunction