Setting Up Queries in the Predefined Query View

The following procedure describes how to set up a query in the Predefined Query view.

To set up a predefined query in the Predefined Query view

  1. Navigate to the Administration - Application screen, then the Predefined Queries view.

  2. In the Predefined Queries list, create a new record, and complete the necessary fields.

    Some fields are described in the following table.

    This table describes the fields to complete when setting up a predefined query.
    Field Comments

    Object

    Select the object on which the query is performed.

    Name

    Type the name that appears in the predefined query drop-down list.

    Private

    Select the check box to indicate the query is available only to the person who created it.

    When you clear the check box y to make a query public, the other users must first exit the Siebel application and reenter before they can see the newly public query.

    Query

    Type the SQL code for the query.

    When you create a query for a field that is a multi-value group, you can use the EXISTS operator to query nonprimary child records. For more information about the syntax, see information about operators, expressions, and conditions in Siebel Developer's Reference.

    Note: You cannot use SQL functions in the query for a predefined query.

    Cache Result

    Select the check box to indicate the query returns all rows up to the value of the DSMaxFetchArraySize parameter set for the data source. For information about setting DSMaxFetchArraySize, see information about modifying Named Subsystems in Siebel System Administration Guide.

    Note: Setting DSMaxFetchArraySize to -1 and Cache Result to Y can cause memory problems for queries returning many rows.