Appboard/2.4/builder/widgets/table - Revision history

imported>Jason.nicholls at 08:27, 14 December 2013

2013-12-14T08:27:24Z

← Older revision		Revision as of 08:27, 14 December 2013
Line 1:		Line 1:
	{{DISPLAYTITLE:Table Widget}}		{{DISPLAYTITLE:Table Widget}}
			[[Category:AppBoard 2.4]]
	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.		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.

imported>Jason.nicholls at 15:07, 29 October 2013

2013-10-29T15:07:47Z

← Older revision		Revision as of 15:07, 29 October 2013
Line 2:		Line 2:
	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.		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'''~~

	[[Image:DataGrid_Plain.png\|~~Sample of a table without renderers~~]]		[[Image:DataGrid_Plain.png\|frame\|Example Table widget]]

	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".		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".

imported>Jason.nicholls: /* Sorting */

2013-10-29T14:40:11Z

Sorting

← Older revision		Revision as of 14:40, 29 October 2013
Line 62:		Line 62:
	In addition the widget itself allows for a default set of sort columns to be configured. 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.		In addition the widget itself allows for a default set of sort columns to be configured. 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		* single click: sort by selected column, or reverse the sort.
	* <tt>CTRL</tt> + click: add additional columns to the sort, i.e. multi-column sorting		* <tt>CTRL</tt> + click: add additional columns to the sort, i.e. multi-column sorting.
	* <tt>CTRL</tt> + <tt>SHIFT</tt> + click: remove a sort. If all sorts are removed the data shown will revert back to the ordering of the data collection.		* <tt>CTRL</tt> + <tt>SHIFT</tt> + click: remove a sort. If all sorts are removed the data shown will revert back to the ordering of the data collection.

imported>Jason.nicholls: /* Sorting */

2013-10-29T14:37:32Z

Sorting

← Older revision		Revision as of 14:37, 29 October 2013
Line 57:		Line 57:
	== Sorting ==		== Sorting ==

	[[~~File~~:appboard-2.4-edit-table-widget.png\|thumb\|300px~~\|link={{filepath:appboard-2.4-edit-table-widget.png}}~~\|Visualization Step]]		[[Image:appboard-2.4-edit-table-widget.png\|thumb\|300px\|Visualization Step]]
	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 as external to AppBoard, or using Server Side Sorting on a data collection, then that is what is shown.		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 as external to AppBoard, or using Server Side Sorting on a data collection, then that is what is shown.

imported>Jason.nicholls: /* Sorting */

2013-10-29T14:23:30Z

Sorting

← Older revision		Revision as of 14:23, 29 October 2013
Line 57:		Line 57:
	== Sorting ==		== Sorting ==

	[[File:appboard-2.4-edit-table-widget.png\|thumb\|300px\|~~Visualization step when editing a~~ table widget.]]		[[File:appboard-2.4-edit-table-widget.png\|thumb\|300px\|link={{filepath:appboard-2.4-edit-table-widget.png}}\|Visualization Step]]
	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 as external to AppBoard, or using Server Side Sorting on a data collection, then that is what is shown.		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 as external to AppBoard, or using Server Side Sorting on a data collection, then that is what is shown.

imported>Jason.nicholls: /* Sorting */

2013-10-29T14:04:50Z

Sorting

← Older revision		Revision as of 14:04, 29 October 2013
Line 57:		Line 57:
	== Sorting ==		== Sorting ==

			[[File:appboard-2.4-edit-table-widget.png\|thumb\|300px\|Visualization step when editing a table widget.]]
	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 as external to AppBoard, or using Server Side Sorting on a data collection, then that is what is shown.		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 as external to AppBoard, or using Server Side Sorting on a data collection, then that is what is shown.

imported>Jason.nicholls: /* Sorting */

2013-10-29T13:53:50Z

Sorting

← Older revision		Revision as of 13:53, 29 October 2013
Line 59:		Line 59:
	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 as external to AppBoard, or using Server Side Sorting on a data collection, then that is what is shown.		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 as 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.		In addition the widget itself allows for a default set of sort columns to be configured. 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		* single click: sort by this column, or reverse sort

imported>Jason.nicholls: /* Sorting */

2013-10-29T13:50:37Z

Sorting

← Older revision		Revision as of 13:50, 29 October 2013
Line 57:		Line 57:
	== Sorting ==		== 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.		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 as 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.		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.

imported>Jason.nicholls: /* Sorting */

2013-10-29T13:49:12Z

Sorting

← Older revision		Revision as of 13:49, 29 October 2013
Line 57:		Line 57:
	== Sorting ==		== Sorting ==

	~~You can select which columns will determine the~~ default ~~sort order of~~ the ~~Widget. On the “Visualization” step of~~ the widget ~~wizard, there is a preview grid at the bottom. You can click one or more columns~~ in ~~this preview to set~~ the ~~default sorting of~~ the ~~Widget~~. ~~The supported options are single column sorting (default click)~~, ~~multi-column sorting (CRTL+click)~~, ~~and un-sorting (CTRL+SHIFT+click). The User can then override this sort order by~~ using ~~these same options to click~~ on ~~columns in the AppBoard Viewer~~.		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
			* <tt>CTRL</tt> + click: add additional columns to the sort, i.e. multi-column sorting
			* <tt>CTRL</tt> + <tt>SHIFT</tt> + click: remove a sort. If all sorts are removed the data shown will revert back to the ordering of the data collection.

			{{Note\|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 [[appboard/2.4/builder/widgets/actions/clear_sort\|Clear Sort]] action can be used to explicit revert the widget to the configured sort.}}

	== Filter Options==		== Filter Options==

imported>Jason.nicholls at 13:31, 29 October 2013

2013-10-29T13:31:00Z

← Older revision		Revision as of 13:31, 29 October 2013
Line 1:		Line 1:
	{{DISPLAYTITLE:Table Widget}}		{{DISPLAYTITLE:Table Widget}}
	The Table Widget will show data from a Data Collection in a tabular format. The config for the ~~basic~~ 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.		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'''		'''Example of a plain table'''
Line 11:		Line 11:
	== Renderers ==		== Renderers ==

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


Line 43:		Line 43:
	=== Row Colors ===		=== Row Colors ===

	The ~~Basic~~ Table can dynamically set the row color based on values contained within the data collection.		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.		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.
Line 61:		Line 61:

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


	=== Search ===		=== 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.		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 ===		=== 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.		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.