Difference between revisions of "Query Results"
(Added export functions) |
m (→CSV (Comma Separated Values)) |
||
| Line 47: | Line 47: | ||
The CSV format is a commonly used data inter-change format. Exporting to CSV can be used when you need to import the data into a database or spreadsheet product other than Excel. | The CSV format is a commonly used data inter-change format. Exporting to CSV can be used when you need to import the data into a database or spreadsheet product other than Excel. | ||
| − | The data is exported in a format similar to this: | + | The data is exported in a format similar to this snippet (with headers): |
| − | " | + | "UK Postcode District","Year","Month","Injury Week" |
| + | "SK3","1987","5","16" | ||
| + | "SK9","2002","5","16" | ||
When choosing to export to this format you are prompted to set specific values for the delimiter, separator and other values: | When choosing to export to this format you are prompted to set specific values for the delimiter, separator and other values: | ||
Revision as of 17:40, 19 September 2013
This topic is for AquilaCRS
(TODO: Work in progress)
Contents
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.
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.
Transferring large amounts of data across the network can result in slow response times or time-outs. Try to restrict your results by carefully entering your Query Filter and selecting only the necessary fields in the Output Field list.
Exporting data
From version 1.2 users will need the Export permission in order to take data out of the database
Excel
Menu: Export > Export to Excel...
Since version 1.1.8 it is no longer necessary to have Excel installed on your machine in order to export to Excel.
Selecting this menu option will prompt you for a folder and file name, and also a file type that is equivalent to the different versions of Excel files.
Navigate to your required folder and enter a meaningful filename & press OK.
Once the export has completed Windows Explorer will be opened with your file highlighted. If you have Excel installed you can double click to open the worksheet directly.
CSV (Comma Separated Values)
Menu: Export > Export to CSV...
The CSV format is a commonly used data inter-change format. Exporting to CSV can be used when you need to import the data into a database or spreadsheet product other than Excel.
The data is exported in a format similar to this snippet (with headers):
"UK Postcode District","Year","Month","Injury Week" "SK3","1987","5","16" "SK9","2002","5","16"
When choosing to export to this format you are prompted to set specific values for the delimiter, separator and other values:
Select the folder * filename. Generally you will leave the remaining options as is, unless you have a specific requirement. Press OK to export.
Once the export has completed Windows Explorer will be opened with your file highlighted. You can now work with your file independently.
