Query Results

From EHS Help
Revision as of 17:10, 19 September 2013 by Admin (Talk | contribs)

Jump to: navigation, search
AquilaCRS icon.png

This topic is for AquilaCRS


(TODO: Work in progress)

Introduction

The query results are divided into two sections: the data table and the Pivot Table


Results Data Table

Query results are presented in a data table which allows local filtering, sorting and grouping.

IBID Query Results.png

See the Data Tables topic for more details on sorting, filtering and grouping.

Record Limits

For speed of response, only the first 200 records of any query are returned. To return more, or all records, select View > Max Records and set the appropriate value.

Max records.png

Transferring large amounts of data across the network can result in slow response times or time-outs. Try and restrict your results by carefully entering your Query Filter and Output Field list.

Exporting data

From version 1.2 users will need the Export permission in order to take data out of the database


Results Pivot Table