Siminov Hybrid Siminov Hybrid

  • API Docs for Version: 2.0

    • APIs

    Show:

    IGroupConcat Class

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

    Exposes API's to get group concat that returns a string which is the concatenation of all non-NULL values of X. If parameter Y is present then it is used as the separator between instances of X. A comma (",") is used as the separator if Y is omitted. The order of the concatenated elements is arbitrary.

    Methods

    and

    (
    • column
    )
    IGroupConcatClause

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

    Used to specify AND condition between where clause.

    Parameters:

    • column String

      Name of column on which condition need to be specified.

    Returns:

    IGroupConcatClause:

    IGroupConcatClause Interface.

    column

    (
    • column
    )
    IGroupConcat

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

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

    Parameters:

    • column String

      Name of column.

    Returns:

    IGroupConcat:

    IGroupConcat Interface.

    delimiter

    (
    • delimiter
    )
    IGroupConcat

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

    Used to specify separator if Y is omitted.

    Parameters:

    Returns:

    IGroupConcat:

    IGroupConcat Interface.

    execute

    () Object

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

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

    Returns:

    Object:

    Return group concat.

    executeAsync

    (
    • callback
    )

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

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

    Parameters:

    • callback Callback

      Request Callback

    groupBy

    (
    • columns
    )
    IGroupConcat

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

    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:

    IGroupConcat:

    IGroupConcat Interface.

    having

    (
    • column
    )
    IGroupConcatClause

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

    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:

    IGroupConcatClause:

    IGroupConcatClause Interface.

    havingClause

    (
    • havingClause
    )
    IGroupConcat

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

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

    Parameters:

    • havingClause String

      Where clause.

    Returns:

    IGroupConcat:

    IGroupConcat Interface.

    or

    (
    • column
    )
    IGroupConcatClause

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

    Used to specify OR condition between where clause.

    Parameters:

    • column String

      Name of column on which condition need to be specified.

    Returns:

    IGroupConcatClause:

    IGroupConcatClause Interface.

    where

    (
    • column
    )
    IGroupConcatClause

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

    Column name of which condition will be specified.

    Parameters:

    • column String

      Name of column.

    Returns:

    IGroupConcatClause:

    IGroupConcatClause Interface.

    whereClause

    (
    • whereClause
    )
    IGroupConcat

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

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

    Parameters:

    • whereClause String

      Manually created where clause.

    Returns:

    IGroupConcat:

    IGroupConcat Interface.