Select the source records for a query

By default, when you run a query, iBase searches the whole database, or case, for records for each entity or link type in the query. However, you can restrict the records that are searched, for example, to a single record, to the records in a set or the results of another query.

To select the scope of the query:

  1. Click the entity or link type in the structure diagram of the query and then click Assign Source.
  2. Select one of the following options:
    • All Records - all records in the database or case are searched.
    • This record only - use a single record, which you select. Once selected, the boxes show the Record ID and label of the record.
    • All except this record - all records in the database except the one selected are searched. Once selected, the boxes show the Record ID and label of the record.
    • Query - search on the results of a query, which you select. You can only select from queries that find records of the appropriate type.
    • All except the records in this query - all records in the database except those resulting from the selected query are searched.
    • Set - search on the records in a set, which you select. You can only select from sets that contain records of the appropriate type.
    • All except the records in this set - all records in the database except those in the selected set are searched.