Setting up query conditions in simple mode

When you are setting up a query in simple mode, the entity type should appear as an icon in the lower left corner of the dialog. You can enter conditions for the fields of an entity which must be met when you perform the query. These conditions are in the form of field name, operator and value, for example last name starts with de.

To enter conditions for an entity type:
  1. Click in the box in the first line of the grid below the Field heading. Select the field name from the drop-down list for which you want to set conditions.
  2. Move to the Operator box in the grid by pressing the Tab key and select an operator from the list.
  3. Move to the Value 1 box in the grid by pressing the Tab key and select a value from the drop-down list or enter a value using the keyboard. us

    If you chose the BETWEEN operator, you will also need to enter a value in the Value 2 box. Value 1 must be before Value 2. For example, if you enter BETWEEN Dec 31 1999 and Jan 01 1999 no records are produced.

    If you enter an incorrect value, press the Esc key and the previous value is restored.

    Note: The at (@) sign is a special character that is used when specifying parameters in parameterized queries, if any values in the Value 1 column of the Query dialog start with an at (@) sign then you must prefix the entire value with an additional at (@) sign if you do want to be prompted for a search value each time the query is performed. For example, if the value in the Value 1 column is @123 then you must enter @@123.
  4. To add a bracket, just double-click in the box where you want the bracket to appear. Double-click a second time to remove the bracket again.

    Brackets allow you to specify how iBridge interprets your query. Anything within brackets is interpreted as one part of the query. For example, Sex is male and age is greater than 20 or eye color is blue could be interpreted as all males over the age of 20 or anyone with blue eyes. Alternatively, the same sentence could be interpreted as all males who are either over 20 or have blue eyes. You can use brackets to clarify this:

    (Sex is male and age is greater than 20) or eye color is blue gives the first interpretation.

    Sex is male and (age is greater than 20 or eye color is blue) gives the second interpretation.
  5. To select a row and make it current, click in the box at the very left end of the row. An asterisk (*) appears in the box. When you have selected a row you can:
    1. click on Insert to add an empty row above the current one
    2. click on Delete to delete the current row
    3. click on the up or down arrow button to move the current row up or down
  6. To check the position of your brackets, you can select a bracket and press the F3 key. The block of text within the bracket and the other half of its pair will be highlighted. To remove the highlight, click anywhere in the grid.
  7. Now you can perform your query.