UBQL

UBQL

UnityBase Query Language formal definition. Recommended way to create a UBQL is ClientRepository.

UBQL JSON representation can be retrieved from Repository using ClientRepository.ubql()

Constructor

new UBQL()

Extends

Members

entity: string

Entity name

fieldList: Array.<string>

Attributes array

groupBy: Array.<string>

Optional array of attributes names to use in group by clause

ID: number

Optional ID. If exists then this is equal to adding a where condition ID = IDValue but bypass cache for cached entities

joinAs: Array.<string>

Optional array of condition names to use in join clause instead of where clause of result SQL

logicalPredicates: string

Optional logical concatenation of WHERE conditions

method: string

Method name

options: Object

Optional options for building SQL. See CustomRepository.misc documentation for possible values

orderBy: Object.<string, UBQLOrderItem>

Optional order by

whereList: Object.<string, UBQLWhere>

Optional named conditions. Object keys is condition name