Bookshelf Home | Contents | Index | PDF     

Using Siebel Tools > Using Siebel Tools > Using Menus and Running Queries >

Running Queries

This topic describes how to run a query in Siebel Tools. If you use the Query Menu, then Siebel Tools searches for objects according to the conditions you enter in one or more properties in the Object List Editor. You can use a simple query or a compound query. You can create, refine, or activate a query from the Query menu or from the List toolbar. You can also use shortcut keys instead of using the Query menu.

Using the Query Menu to Run a Query

This topic describes how to use the Query Menu to run a query.

To use the Query Menu to run a query

  1. In the Object Explorer, click the object type you must locate.
  2. Choose the Query menu, and then click New Query.

    Siebel Tools displays an empty record in the Object List Editor.

  3. In the Object List Editor, enter the query.

    For more information, see Using a Simple Query and Using a Compound Query.

  4. Choose the Query menu, and then click Execute Query.

    Siebel Tools displays the records that meet the query criteria you entered.

  5. (Optional) To refine the query, do the following:
    1. Choose the Query menu, and then click Refine.
    2. In the Object List Editor, add more query conditions.
    3. Choose the Query menu, and then click Execute Query.

Using Shortcut Keys to Run a Query

You can use a shortcut key to run a query.

To use shortcut keys to run a query

  1. In the Object Explorer, click the object type you must locate.
  2. In the Object List Editor, enter CTRL + Q.
  3. In the Object List Editor, enter the query.

    For more information, see Using a Simple Query and Using a Compound Query.

  4. Press the ENTER key.

    Siebel Tools displays the query results.

Using a Simple Query

Table 3 describes the operators you can use to create a simple query. A simple query is a type of query that locates records according to one condition. A check mark in a property that can contain a Boolean value represents TRUE. The Changed property is an example of a property that contains a Boolean value. For more information about query operators and Siebel data types, see Siebel Developer's Reference.

Table 3. Simple Query Operators
Operator
Description

=

Equal to.

<

Less than.

>

Greater than.

<>

Not equal to.

<=

Less than or equal to.

>=

Greater than or equal to.

*

A wildcard. An asterisk (*) can represent any number of characters, including no characters.

?

A wildcard. A question mark (?) can represent any single character.

IS NOT NULL

Queries for a property that is not empty.

IS NULL

Queries for an empty property.

LIKE

Queries for a value that begins with the string you enter.

NOT LIKE

Queries for a value that does not start with the string you enter.

" "

Queries for a string that includes a special character. For example, to query for the MyQuery's Text string, you enter "MyQuery's Text". If your query text includes a special character, then you must use quotes to enclose the query.

EXISTS ( )

Queries for a value that exists in a multi-value group.

~

Forces the case of the text string to use the case that follows the tilde (~).

Using a Compound Query

A compound query is a type of query that locates records according to more than one condition. You can use parentheses to control the order that Siebel Tools uses to do a compound query. Siebel Tools runs the query according to the expression you enter. It starts with the inside parentheses first, in left to right order.

Table 4 describes operators you can use for a compound query. You can combine simple conditions and compound conditions in a single query. For more information, see Siebel Developer's Reference.

Table 4. Compound Query Operators
Operator
Description

AND

All the conditions that the AND operator connects must be true.

OR

At least one of the conditions that the OR operator connects must be true.

NOT

The condition that the NOT operator precedes must be false.

To use a compound query

  • Do one of the following:
    1. Enter conditions in two or more properties.

      When you run the query, Siebel Tools uses an AND operator between the conditions you enter.

    2. Use OR, AND, and NOT operators in a single property.
    3. Use any combination of the conditions you enter for Step a and Step b.

Removing Query Results from the Object List Editor

You can remove query results from the Object List Editor.

To remove query results from the Object List Editor

  1. Choose the Query menu, and then click New Query.
  2. Do not enter any values in the Object List Editor.
  3. Choose the Query menu, and then click Execute Query.
    
Using Siebel Tools Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices.