QueryReduce

This function reduces the query to a single value.

Method Signature

QueryReduce(query=[query], callback=[function:BiFunction], initialValue=[any])

Arguments

Argument	Type	Required	Description	Default
query	query	true	The query to iterate over
callback	function:BiFunction	true	The function to invoke for each item. The function will be passed 4 arguments: the accumulator, the current item, the current index, and the query. You can alternatively pass a Java Predicate which will only receive the first 2 args.
initialValue	any	true	The initial value to use for the reduction

Examples

Reduce column to total

Sum one query column

Run Example

fruits = queryNew( "fruit,amount", "varchar,integer", [ 
	{
		"fruit" : "apples",
		"amount" : 15
	},
	{
		"fruit" : "pineapples",
		"amount" : 3
	},
	{
		"fruit" : "strawberries",
		"amount" : 32
	}
] );
total_fruits = queryReduce( fruits, ( Any a, Any b ) => {
	return a + b.AMOUNT;
}, 0 );
writeOutput( total_fruits );

Result: 50

Additional 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
	]
] );
date = createDateTime( 2016, 3, 13, 17, 0, 0 );
totalAge = queryreduce( people, ( Any age = 0, Any row, Any rowNumber, Any recordset ) => {
	return age + DateDiff( "yyyy", recordset.DOB, date );
} );
writeDump( totalAge );

Related

• QueryAddColumn

• QueryAddRow

• QueryAppend

• QueryClear

• QueryColumnArray

• QueryColumnCount

• QueryColumnData

• QueryColumnExists

• QueryColumnList

• QueryCurrentRow

• QueryDeleteColumn

• QueryDeleteRow

• QueryEach

• QueryEvery

• QueryFilter

• QueryGetCell

• QueryGetResult

• QueryInsertAt

• QueryKeyExists

• QueryMap

• QueryNew

• QueryNone

• QueryPrepend

• QueryRecordCount

• QueryRecordCount

• QueryRegisterFunction

• QueryReverse

• QueryRowData

• QueryRowSwap

• QuerySetCell

• QuerySetRow

• QuerySlice

• QuerySome

• QuerySort