Difference between revisions of "Data Tables"

Revision as of 16:39, 19 September 2013

This topic is for AquilaCRS

Work in progress

Data Tables

Tabular data in AquilaCRS is presented inside a commonly used visual component; the Data Table:

Every data table has the following key features:

• Sorting
• Filtering
• Grouping

Sorting

To sort a data table by a column, click on the column header (avoiding the right hand edge of the column header which is reserved for filtering options).

To indicate a table is sorted by a specific column, that column will show a up or down arrow to the right hand side. Up or down indicates the direction of the sort, ascending or descending.

To sort by multiple fields:

• Click on the first column header.
• Hold down the Shift key and click on the secondary sort columns

Filtering

Hover your mouse over a column header to reveal a small filter icon. Click this and you will be presented with a drop down list of all the distinct values in the sub-set of data that the table represents, plus (All) and (Custom) options.

File:Data table filtering.png align="left"

• Ticking individual values will include that value in the data table. You can tick more than one box to easily create complex filters.
• Select the (All) option again to show all records.
• Select the (Custom) option to show a filter builder screen to allow you to specify more complex filters.

You can filter on more than one column simultaneously to create complex filters.

When the data table has been filtered, the column header shows a highlighted filter icon, and the filter itself is displayed at the foot of the data table. The Customise... button has the same effect as selecting (Custom) from the drop down.

The X to the left of the filter will remove the filter and show all records again.

The drop-down arrow to the right of the filter text shows recently used filters so you can easily switch.

Grouping

(TODO: grouping)