Tips for Queries

Note the following tips when you create and execute queries:

The Siebel application automatically adds a wildcard to the end of your query. If you search for Siebe, then all words beginning with the letters Siebe are found.
When you create a query, the records matching the query criteria appear in a list. While you work with the records in the list and move through the views within the current screen, the list continues to show the records that were found when you executed the query. The list is reset to the default list of records when you leave and then again access the current screen.
If you no longer need the list of records in a query and want to reset the list, then click the current screen tab to return to the default set of records.
If a predefined query created by your organization appears in the drop-down list for the Saved Queries field, then you cannot delete this query from the list. However, you can modify the query criteria and save the query using another name. For more information, see "Refining Queries".
You cannot query on Notes views when you are connected to the server.
Any queries that execute in Administration screens against multi-value group fields are automatically appended by EXISTS(). Consequently, you can see every record, regardless of whether it is a primary record.
When you create a query and navigate through the views, use the hyperlinks on the link bar to return to the queried list of records.
If you execute a query that includes more than one consecutive blank space, and if you do not place quotes around the query, then the spaces are ignored, and you see inaccurate results.
When the query results appear in list format, the first record is highlighted. It might appear as though the record you select before running the query appears again, but you are actually seeing a new set of records resulting from your query.
In query mode, check boxes have three states: checked, unchecked, and intermediate. If you specify intermediate in a check box field while running a query, your Siebel Business application will return records that are checked and records that are unchecked.

Note:
The visual representation of the intermediate state of the check box is browser dependant.