Class DataObjectTemplatizedQuery
Information required in a structured template to form and execute query on a data object.
Inherited Members
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.
|
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') |