Tips for Queries

Note the following tips when you create and execute queries:

• The 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. For more information, see How Siebel CRM Handles Wildcard Search.

• 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 navigate to the current screen again 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 when running a query, then your application returns records that are checked and records that are unchecked.