Class DataObjectStandardQuery

Information required to execute query on data objects. Query is given in standard SQL syntax providing flexibility to form complex queries such as queries with joins and nested queries.

Inheritance

object

DataObjectQuery

DataObjectStandardQuery

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 DataObjectStandardQuery : DataObjectQuery

Properties

Statement

Declaration

[JsonProperty(PropertyName = "statement")]
public string Statement { get; set; }

Property Value

Type

Description

string

SQL query statement with standard Oracle supported SQL syntax. When Warehouse (e.g: Awr hub) data objects are queried, use the actual names of underlying data objects (e.g: tables, views) in the query. The same query that works through JDBC connection with the OperationsInsightsWarehouseUsers credentials will work here and vice-versa. SCHEMA.VIEW syntax can also be used here. When OPSI data objects are queried, use name of the respective OPSI data object, just like how views are used in a query. Identifier of the OPSI data object cannot be used in the query.

TimeFilters

Declaration

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

Property Value

Type	Description
DataObjectQueryTimeFilters