Querying For Data In The Siebel UI

1) Inline Querying

2) Query Operations

3) Refine Queries

4) Save Queries

5) Query Assistant

6) Predefined and saved Queries

1) Inline Querying : Create And execute queries from with in dialog boxes

• Users no longer need to navigate to a separate dialog box to enter query criteria .
• Helps users quickly find the data they want within dialog boxes .
  

2) Query Operators : Wildcards can be used to search for multiple characters

• *(asterisk) returns records containg the string or containing the string plus any additional characters.
  
• For Example by typing MA will find Madrid and San Mateo
  
• Mateo , but by typing *Ma* will find Madrid and San Mateo
  

• * cannot be used in data or numeric fields
  

• ? (question mark ) returns records containing the characters specified int he string such that any single character may appear at the location of the ?

• For example by typing ? will find type, tape , but not tripe
  
• < = (less than or equal to) can be used on numeric or date fields
  
• <> (not equal ) can be used on all fields
  
• OR allows entry of more than one value for a field
  

3) Refine Queries : Use Refine Query to modify an existing query .

4). Save Queries : Use the Application-level Query menu to save a query .

5) Predefined and saved Queries : Predefined queries are provided by your administrator

Saved queries are created and saved by the user .

6 ) Record Count : Provides the total number of matching records in the query .