Siminov Hybrid Siminov Hybrid

  • API Docs for Version: 2.0

    • APIs

    Show:

    IMax Class

    Defined in: /private/var/user/Documents/App/Hybrid/JavaScript/Siminov/Database/Design/IMax.js:56
    Module: Impl
    Parent Module: Database

    Exposes API's to returns the maximum value of all values in the group. The maximum value is the value that would be returned last in an ORDER BY on the same column. Aggregate max() returns NULL if and only if there are no non-NULL values in the group.

    Methods

    and

    (
    • column
    )
    IMaxClause

    Defined in /private/var/user/Documents/App/Hybrid/JavaScript/Siminov/Database/Design/IMax.js:97

    Used to specify AND condition between where clause.

    Parameters:

    • column String

      Name of column on which condition need to be specified.

    Returns:

    IMaxClause:

    IMaxClause Interface.

    column

    (
    • column
    )
    IMax

    Defined in /private/var/user/Documents/App/Hybrid/JavaScript/Siminov/Database/Design/IMax.js:147

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

    Parameters:

    • column String

      Name of column.

    Returns:

    IMax:

    IMax Interface.

    execute

    () Object

    Defined in /private/var/user/Documents/App/Hybrid/JavaScript/Siminov/Database/Design/IMax.js:157

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

    Returns:

    Object:

    Return maximum.

    executeAsync

    (
    • callback
    )

    Defined in /private/var/user/Documents/App/Hybrid/JavaScript/Siminov/Database/Design/IMax.js:167

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

    Parameters:

    • callback Callback

      Request Callback

    groupBy

    (
    • columns
    )
    IMax

    Defined in /private/var/user/Documents/App/Hybrid/JavaScript/Siminov/Database/Design/IMax.js:117

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

    Parameters:

    • columns Array

      Name of columns.

    Returns:

    IMax:

    IMax Interface.

    having

    (
    • column
    )
    IMaxClause

    Defined in /private/var/user/Documents/App/Hybrid/JavaScript/Siminov/Database/Design/IMax.js:127

    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:

    IMaxClause:

    IMaxClause Interface.

    havingClause

    (
    • havingClause
    )
    IMax

    Defined in /private/var/user/Documents/App/Hybrid/JavaScript/Siminov/Database/Design/IMax.js:137

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

    Parameters:

    • havingClause String

      Where clause.

    Returns:

    IMax:

    IMax Interface.

    or

    (
    • column
    )
    IMaxClause

    Defined in /private/var/user/Documents/App/Hybrid/JavaScript/Siminov/Database/Design/IMax.js:107

    Used to specify OR condition between where clause.

    Parameters:

    • column String

      Name of column on which condition need to be specified.

    Returns:

    IMaxClause:

    IMaxClause Interface.

    where

    (
    • column
    )
    IMaxClause

    Defined in /private/var/user/Documents/App/Hybrid/JavaScript/Siminov/Database/Design/IMax.js:77

    Column name of which condition will be specified.

    Parameters:

    • column String

      Name of column.

    Returns:

    IMaxClause:

    IMaxClause Interface.

    whereClause

    (
    • whereClause
    )
    IMax

    Defined in /private/var/user/Documents/App/Hybrid/JavaScript/Siminov/Database/Design/IMax.js:87

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

    Parameters:

    • whereClause String

      Manually created where clause.

    Returns:

    IMax:

    IMax Interface.