Show:

Exposes API's to return total of all non-NULL values in the group. The non-standard total() function is provided as a convenient way to work around this design problem in the SQL language. The result of total() is always a floating point value.

Methods

and

(
  • column
)
ITotalClause

Used to specify AND condition between where clause.

Parameters:

  • column String

    Name of column on which condition need to be specified.

Returns:

ITotalClause:

ITotalClause Interface.

column

(
  • column
)
ITotal

Used to provide name of column for which total will be calculated.

Parameters:

  • column String

    Name of column.

Returns:

ITotal:

ITotal Interface.

execute

() Object

Used to get total, this method should be called in last to calculate total.

Returns:

Object:

Return total.

executeAsync

(
  • callback
)

Used to get total asynchronous, this method should be called in last to calculate total.

Parameters:

  • callback Callback

    Request Callback.

groupBy

(
  • columns
)
ITotal

Used to specify GROUP BY statement in conjunction with the aggregate functions to group the result-set by one or more columns.

Parameters:

  • columns String

    Name of columns.

Returns:

ITotal:

ITotal Interface.

having

(
  • column
)
ITotalClause

Used to specify HAVING clause to SQL because the WHERE keyword could not be used with aggregate functions.

Parameters:

  • column String

    Name of column on which condition need to be applied.

Returns:

ITotalClause:

ITotalClause Interface.

havingClause

(
  • havingClause
)
ITotal

Used to provide manually created Where clause, instead of using API's.

Parameters:

  • havingClause String

    Where clause.

Returns:

ITotal:

ITotal Interface.

or

(
  • column
)
ITotalClause

Used to specify OR condition between where clause.

Parameters:

  • column String

    Name of column on which condition need to be specified.

Returns:

ITotalClause:

ITotalClause Interface.

where

(
  • column
)
ITotalClause

Column name of which condition will be specified.

Parameters:

  • column String

    Name of column.

Returns:

ITotalClause:

ITotalClause Interface.

whereClause

(
  • whereClause
)
ITotal

Used to provide manually created Where clause, instead of using API's.

Parameters:

  • whereClause String

    Manually created where clause.

Returns:

ITotal:

ITotal Interface.