Class DataObjectTemplatizedQuery

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

Inheritance

object

DataObjectQuery

DataObjectTemplatizedQuery

Inherited Members

DataObjectQuery.BindParams

DataObjectQuery.QueryExecutionTimeoutInSeconds

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Namespace: Oci.OpsiService.Models

Assembly: OCI.DotNetSDK.Opsi.dll

Syntax

public class DataObjectTemplatizedQuery : DataObjectQuery

Properties

FromClause

Declaration

[JsonProperty(PropertyName = "fromClause")]
public string FromClause { get; set; }

Property Value

Type	Description
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.

Type

Description

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.

GroupByList

Declaration

[JsonProperty(PropertyName = "groupByList")]
public List<string> GroupByList { get; set; }

Property Value

Type	Description
List<string>	List of items to be added into the GROUP BY clause of the query; items will be added with comma separation.

HavingConditionsList

Declaration

[JsonProperty(PropertyName = "havingConditionsList")]
public List<string> HavingConditionsList { get; set; }

Property Value

Type	Description
List<string>	List of items to be added into the HAVING clause of the query; items will be added with AND separation.

OrderByList

Declaration

[JsonProperty(PropertyName = "orderByList")]
public List<string> OrderByList { get; set; }

Property Value

Type	Description
List<string>	List of items to be added into the ORDER BY clause of the query; items will be added with comma separation.

SelectList

Declaration

[JsonProperty(PropertyName = "selectList")]
public List<string> SelectList { get; set; }

Property Value

Type	Description
List<string>	List of items to be added into the SELECT clause of the query; items will be added with comma separation.

TimeFilters

Declaration

[JsonProperty(PropertyName = "timeFilters")]
public DataObjectQueryTimeFilters TimeFilters { get; set; }

Property Value

Type	Description
DataObjectQueryTimeFilters

WhereConditionsList

Declaration

[JsonProperty(PropertyName = "whereConditionsList")]
public List<string> WhereConditionsList { get; set; }

Property Value

Type	Description
List<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')