When you click Search, you will be taken to the Search Grid with your results.

• Text fields:
  • Logical OR: Separate terms with OR, a comma or a semi-column
  • Logical AND: Separate terms with AND or a plus sign
• Number and Date fields:
  •  Same as for text, plus the following operators are allowed: <, <=, >=, >, =

2. Field Type

• Select one of Date, Number or Text

3. Fields to search

• Enter one or more fields to search
• The dropdown lists all fields of the selected type (section 2 above)
• Leave it blank to search all fields of the selected type
• If more than one field is entered, these will be OR'ed

4. Source View

• Leave blank to search all items in the IQBase
• To limit the search to item in a particular grid, select it from the dropdown list

5. Results in

• By default, the search results are shown in the Search grid
• To show results in another grid, select it from the dropdown list. Note however the following:
  1. The grid source and filter will be changed, so to show the original list of items of this grid, both the grid source and filter will need to be reassigned
  2. The grid source will be set to (All Items) if the source view (section 4 above) is blank. Otherwise the grid source will be set to the source view grid source
  3. The grid filter will be that to meet the advanced search criteria
  4. If all you want is to view the search results with a specific set of columns, a better method is to leave it blank (Search grid) and apply a specific columns set. See 4. Grid Columns and Column Sets

Hints:

• When doing an advanced search, you are actually just applying a filter to a grid. If you look at the resulting search grid, you will notice the filter field has been populated with the SQL representation of what you put in search.