Adding the results of a query or set

The results of queries or items in sets in your iBase database can be added to your chart. You can open the set or query and modify the contents before you add the items to the chart.

Before you begin

You must have a relevant query or set available:
  • For more information about creating a query, see Querying your data.
  • For more information about creating sets, see Sets.

About this task

You can use the Query Manager and Set Manager options to interact with the queries and sets that are present in your database.

Procedure

  1. To access the Data Sources pane, click the Home tab, and then in the Data Sources group, select Connect > Datasources Pane.
  2. Select whether to add the results of a query, or the contents of a set:
    • To view the available queries, select Query Manager.
    • To view the available sets, set Set Manager.
  3. Select the query or set to use and either review the items, or add them directly to the chart:
    • If you want to review the definition of the query, review the records found by the query, or see the contents of the set, click Open. Then, when you close the query or set, you are prompted to add the records to the current chart.
    • If you do not want to review the query or set, click Chart. The records are added to the current chart.