Creating a simple query

This example explains how to find all of the males in the Accounts Example 3 database whose last name begins with Br. This is a query involving only conditions on the Person entity: the fact that the person is male and that his last name begins with Br.

This example assumes that the Accounts Example 3 database is already open within Analyst's Notebook. For more information about opening a database, refer to Opening an iBridge database.

  1. Select the database palette by selecting Accounts Example 3 from the drop-down list of palettes.
  2. Holding down the Ctrl key, drag a person icon from the Accounts Example 3 palette onto your chart.

    The Query dialog opens in simple mode with the Person entity type already set. This means that you only need to add the conditions on the person entity to complete your query.

  3. Enter the following name for your query into the Query Name box:
    Males whose last name begins with Br
  4. Enter the following conditions for your query in the first row of the Conditions box:
    1. Click in the Field area of the first line and select Sex from the list. You may need to scroll down the list of fields to see the one you want to select.
    2. Click in the Operator box of the first line and select the operator equal to from the drop-down list. Again you may need to scroll down the list to find this operator.
    3. Enter Male into the Value 1 box.
  5. You have now set up the first criterion of your query. To set the second:
    1. Click in the Field box of the second line and select Last Name from the list.
    2. Click in the Operator box of the second line and select the operator starts with from the drop-down list. An AND will also appear at the beginning of the line.
    3. Enter Br into the Value 1 box.
  6. To see the results of you query, click Next. The query finds two males in the example database whose last name begins with Br: Arthur Bradly and Stewart Brandon.
    Note: You may perform a query that displays more than one item in the results list. By default iBridge turns on all of the check boxes in the results list which means that all of the items will be charted when you click the Finish button. You can choose individual items to chart from the results list by either turning on or turning off the check box next to the item. The Clear All button turns off all the check boxes and the Select All button turns on all of the check boxes again.
  7. Click Finish. The two people are placed on the chart at the top left corner of your screen.