How Queries Work

The way queries work in Unifier is as follows:

  • You mine down to the information you want by choosing an element (field) in the database on which to base the query.
  • You test the data against conditions and values that you specify.

A condition is a state or restriction that the value in the data element (field) must meet. A condition of the value might be that it must be equal to a certain number (for example, 10) or that it must contain a certain string of letters (such as "due date of").

  • When (or if) the data meets the condition you specify, the system retrieves it from the database for use in a report, manager sheet, auto-creation, data picker, and so on.

This diagram displays how Unifier mines down to data to be used in other areas.