Package com.oracle.bmc.opsi.model

Class DataObjectTemplatizedQuery

  • @Generated(value="OracleSDKGenerator",
           comments="API Version: 20200630")
public final class DataObjectTemplatizedQuery
extends DataObjectQuery
    Information required in a structured template to form and execute query on a data object.
    Note: Objects should always be created or deserialized using the DataObjectTemplatizedQuery.Builder. This model distinguishes fields that are null because they are unset from fields that are explicitly set to null. This is done in the setter methods of the DataObjectTemplatizedQuery.Builder, which maintain a set of all explicitly set fields called DataObjectTemplatizedQuery.Builder.__explicitlySet__. The hashCode() and equals(Object) methods are implemented to take the explicitly set fields into account. The constructor, on the other hand, does not take the explicitly set fields into account (since the constructor cannot distinguish explicit null from unset null).

    • Method Detail

      • getSelectList

        public List<String> getSelectList()
        List of items to be added into the SELECT clause of the query; items will be added with comma separation.
        Returns:
        the value

      • getFromClause

        public String getFromClause()
        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.
        Returns:
        the value

      • getWhereConditionsList

        public List<String> getWhereConditionsList()
        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’)

        Returns:
        the value

      • getGroupByList

        public List<String> getGroupByList()
        List of items to be added into the GROUP BY clause of the query; items will be added with comma separation.
        Returns:
        the value

      • getHavingConditionsList

        public List<String> getHavingConditionsList()
        List of items to be added into the HAVING clause of the query; items will be added with AND separation.
        Returns:
        the value

      • getOrderByList

        public List<String> getOrderByList()
        List of items to be added into the ORDER BY clause of the query; items will be added with comma separation.
        Returns:
        the value

      • toString

        public String toString​(boolean includeByteArrayContents)
        Return a string representation of the object.
        Overrides:
        toString in class DataObjectQuery
        Parameters:
        includeByteArrayContents - true to include the full contents of byte arrays
        Returns:
        string representation