Appboard/2.4/builder/widgets/table

Revision as of 13:49, 29 October 2013 by imported>Jason.nicholls (→‎Sorting)

The Table Widget will show data from a Data Collection in a tabular format. The config for the table widget allows you to select the columns of data you want to see from the data collection, and lets you determine the order in which those columns appear. A simple client side sort operation is available by clicking on the table header.

Example of a plain table

Sample of a table without renderers

If you're using Sample.Data.ChartData, then select columns you'd like to see by pressing the add button and selecting the appropriate column name from the "Data Field".


Renderers

The Table widget provides a number of customization options around how data inside the table is rendered and displayed.


Column Renderers

Column Renderers alter way data is rendered for a selected column. All renders allow you Change the header text for the column, the column width, and set whether or not the column can be resized. Column Renderers include:

  • Text
Default renderer designed to render text strings. Text will be left aligned.
  • Status Shape
The Status shape renderer allows you to convert textual data into a status shape via Status Rules.
  • Date
The Date renderer allows you to adjust how date information is displayed. (MM/DD/YYYY, YYYY/MM/DD, etc.). The system ships with a large list of formats but this can also be extended, see the Client Date Formats documentation.
  • Icon
The Icon renderer allows you to represent textual data as an icon.
  • Number
The Number renderer allows you to adjust the format of numbers.
  • Sparkline
Display an associated data collection as an inline micro-area or micro-line chart. See the Sparkline Renderer page for more details.

The example below shows a Status Shape applied to the "Totals" column, and a "Date" renderer applied to the "Date" column.

Sample of a table with renderers


If you're using Sample.Data.ChartData, set the renderer for the "Totals" Data Field to be "Status Shape". Then set the following rules:

  1. Set the color to be "red" for "Totals" that are "Greater Than" the value "2100"
  2. Set the color to be "Yellow" for "Totals" that are "Greater Than" the value "2000"
  3. Set the color to be "Green" for "Totals" that are "Greater Than" the value "0"

Row Colors

The Table widget can dynamically set the row color based on values contained within the data collection.

The example below shows row status colors based on rules for the "Totals" column. These are the same rules that were used for the Status Shape column renderer.

Sample of a table with renderers


If you're using Sample.Data.ChartData, set the renderer for the "Totals" Data Field to be "Status Shape". Then set the following rules:

  1. Set the color to be "#FFCCCC" for "Totals" that are "Greater Than" the value "2100"
  2. Set the color to be "#FFFFCC" for "Totals" that are "Greater Than" the value "2000"
  3. Set the color to be "#CCFFCC" for "Totals" that are "Greater Than" the value "0"

Sorting

By default the data shown in the widget will be in the order returned by the AppBoard server. So if the data is pre-sorted, such external to AppBoard, or using Server Side Sorting on a data collection, then that is what is shown.

In addition the widget itself allows for a default set of sort columns to be configured. Note this will override the existing sort order of the data collection. To configure the sort columns click one or more columns in the widget Preview on the Visualization step when editing the widget.

  • single click: sort by this column, or reverse sort
  • CTRL + click: add additional columns to the sort, i.e. multi-column sorting
  • CTRL + SHIFT + click: remove a sort. If all sorts are removed the data shown will revert back to the ordering of the data collection.
Template-note.png
AppBoard Viewer users can sort the table any way they wish using the same controls as above. This is temporary and a client reload will restore the widget back to the configured sort settings. Also the Clear Sort action can be used to explicit revert the widget to the configured sort.

Filter Options

The "Options" tab provides several filter options that are particularly useful when combined with the Table widget.


Search

This option toggles a pill shaped text field in the header of the widget which allows you to quickly filter the data collection based on characters entered into this field. When you type characters into the field, AppBoard will search all rows of data for strings that match the characters that have been entered. Any rows that do not contain strings with matching characters are hidden from the view, leaving only the rows that have matching values visible. Combining this option with sort is a quick and easy way to find what your looking for.

Quick Filter

The "Quick Filter" option provides a set of toggle button controls in the bottom toolbar of the widget. These toggle buttons quickly filters data on the client based on associated rules. Only rows of data which match criteria defined by these rules will remain visible. Rows of data that do not match the rule are hidden from the view.