Guidelines for Setting Up Queries

When setting up queries, remember:

• The Administrator can define a PDQ using both displayed and nondisplayed fields.

• You can reference only fields from the current applet’s business component in your query.

• On occasion, using the asterisk (*) wildcard character to find all entries in a field can cause a performance problem. If you encounter a performance problem, then use IS NOT NULL instead. For more information about query operators, see Siebel Fundamentals Guide.

  Predefined queries are defined on a business object. All screens that are based on the same business object display all the predefined queries created for that business object.

• Querying on fields of data type DTYPE_NOTE is not supported on some databases.