Query Builder - ad-hoc reports

Submitted by ckelley on Wed, 12/30/2009 - 16:17

The Query Builder enables the user to make ad-hoc reports in the ZEPRS application. The Query Builder uses the application's "awareness" of shared fields in order to aggregate data that is stored in multiple fields. For instance, BP values are taken in multiple forms and stored in multiple tables. Since the BP values are a "shared field," the system is able to identify those fields and make the appropriate joins.

Query builder

The Field dropdown displays the tables used to query a particular field - note that some of these fields have multiple tables. These fields are "shared fields."

Query Builder Fields