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, function(row [, currentRow] [, query] ){} [, parallel] [, maxThreads]) → returns boolean

Member Function Syntax

query.some(function(row [, currentRow] [, query] ){} [, parallel] [, maxThreads])

querySome Argument Reference

query query
Required

query to filter entries from

callback boolean
Required

Closure or a function reference that will be called for each of the iteration.

Callback parameters:

  • row*struct : A struct with all of the columns for the current iteration
  • currentRow*numeric : The value for the current iteration
  • query*query : A reference of the original struct

parallel boolean
Default: false

Lucee 4.5+ true if the items can be executed in parallel
Values:
  • true
  • false

maxThreads numeric
Default: 20

Lucee 4.5+ the maximum number of threads to use when parallel = true

Links more information about querySome

Examples
Sample code invoking the querySome function

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

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

Expected Result: Some matches Record found!

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

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

Expected Result: No matches Record found!


Fork me on GitHub