Options
All
  • Public
  • Public/Protected
  • All
Menu

Namespace DataObjectTemplatizedQuery

Information required in a structured template to form and execute query on a data object.

Properties

Methods

Properties

Optional bindParams

bindParams: Array<DataObjectBindParameter>

List of bind parameters to be applied in the query.

Optional fromClause

fromClause: undefined | string

Unique data object name that will be added into the FROM clause of the query, just like a view name in FROM clause.

  • Use actual name of the data objects (e.g: tables, views) in case of Warehouse (e.g: Awr hub) data objects query. SCHEMA.VIEW name syntax can also be used here. e.g: SYS.DBA_HIST_SNAPSHOT or DBA_HIST_SNAPSHOT
  • Use name of the data object (e.g: SQL_STATS_DO) in case of OPSI data objects. Identifier of the OPSI data object cannot be used here.

Optional groupByList

groupByList: Array<string>

List of items to be added into the GROUP BY clause of the query; items will be added with comma separation.

Optional havingConditionsList

havingConditionsList: Array<string>

List of items to be added into the HAVING clause of the query; items will be added with AND separation.

Optional orderByList

orderByList: Array<string>

List of items to be added into the ORDER BY clause of the query; items will be added with comma separation.

Optional queryExecutionTimeoutInSeconds

queryExecutionTimeoutInSeconds: undefined | number

Timeout (in seconds) to be set for the data object query execution. Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Const queryType

queryType: string = "TEMPLATIZED_QUERY"

Optional selectList

selectList: Array<string>

List of items to be added into the SELECT clause of the query; items will be added with comma separation.

Optional timeFilters

timeFilters: model.DataObjectQueryTimeFilters

Optional whereConditionsList

whereConditionsList: Array<string>

List of items to be added into the WHERE clause of the query; items will be added with AND separation. Item can contain a single condition or multiple conditions. Single condition e.g: "optimizer_mode='mode1'" Multiple conditions e.g: (module='module1' OR module='module2')

Methods

getDeserializedJsonObj

getJsonObj