Creating an extended query

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. Right-click on the chart background, and from the shortcut menu, select New Query to display the Query dialog in extended mode.
  2. Enter the following name for your query:
    People who opened an account after 30 Oct 1998
  3. In the lower half of the Query dialog, drag a Person icon and an Account icon from the palette onto the chart area of the dialog.
  4. Select the Account Owner link type from the drop-down list and draw a link between the Account and Person entities.
  5. Click on the Account entity and add the following criterion in the upper half of the dialog in the same way as you added conditions in Creating a simple query:
    Field Operator Value 1
    Date Opened after 30 Oct 1998
  6. To see the results of your query, click Next. The query finds four people who opened accounts after 30 Oct 1998 together with four accounts and the Account Owner links between them.
  7. Click Finish. The people, accounts and links are placed on the chart.
    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.