Appboard/old/server side queries - Revision history

imported>Jason.nicholls: /* Defining an Action on a Widget That Applies a Server-side Filter */

2014-07-17T18:11:56Z

Defining an Action on a Widget That Applies a Server-side Filter

← Older revision		Revision as of 18:11, 17 July 2014
Line 49:		Line 49:
	===Defining an Action on a Widget That Applies a Server-side Filter===		===Defining an Action on a Widget That Applies a Server-side Filter===

	You can define an Action on a Widget to apply a server-side filter when the Widget is clicked. The concept is the same as the client-side filtering example illustrated in the article on [[~~Filtering_Collections_Concepts~~#Using_Actions_To_Filter_and_Collect_Data\|Client-side Filtering]], except in this case the filter will be applied on the AppBoard data server and not in the client.		You can define an Action on a Widget to apply a server-side filter when the Widget is clicked. The concept is the same as the client-side filtering example illustrated in the article on [[appboard/old/filtering_collections_concepts#Using_Actions_To_Filter_and_Collect_Data\|Client-side Filtering]], except in this case the filter will be applied on the AppBoard data server and not in the client.

	The following illustration shows an example of configuring an Action on a Widget to launch a Child Board and invoke a server-side filter:		The following illustration shows an example of configuring an Action on a Widget to launch a Child Board and invoke a server-side filter:

	[[Image:ServerSideFilterAction.png\|thumb\|center\|500px\|Configuring an Action on a Widget to Launch a Child Board and Invoke a Server-side Filter]]		[[Image:ServerSideFilterAction.png\|thumb\|center\|500px\|Configuring an Action on a Widget to Launch a Child Board and Invoke a Server-side Filter]]

imported>Jason.nicholls: /* Configuring Server-side Filters */

2014-07-17T04:07:57Z

Configuring Server-side Filters

← Older revision		Revision as of 04:07, 17 July 2014
Line 29:		Line 29:
	There are two ways to configure server-side filters in AppBoard:		There are two ways to configure server-side filters in AppBoard:
	# By defining a Data Collection that applies a server-side filter to a Data Source		# By defining a Data Collection that applies a server-side filter to a Data Source
	# By defining an Action on a Widget that applies a server-side filter when the user clicks to [[~~Action_Switch_To_A_Board~~\|drill-down]] into the Widget		# By defining an Action on a Widget that applies a server-side filter when the user clicks to [[appboard/old/actions/switch_to_a_board\|drill-down]] into the Widget

imported>Jason.nicholls: /* Defining a Data Collection with a Server-side Filter */

2014-07-17T03:55:19Z

Defining a Data Collection with a Server-side Filter

← Older revision		Revision as of 03:55, 17 July 2014
Line 45:		Line 45:
	[[Image:ServerSideDataCollectionFilter.png\|thumb\|center\|500px\|Configuring a Data Collection to Apply a Server-side Filter]]		[[Image:ServerSideDataCollectionFilter.png\|thumb\|center\|500px\|Configuring a Data Collection to Apply a Server-side Filter]]

	For more information on configuring Data Collections, see [[~~Data_Collections~~\|Data Collections]].		For more information on configuring Data Collections, see [[appboard/old/data_collections\|Data Collections]].


	===Defining an Action on a Widget That Applies a Server-side Filter===		===Defining an Action on a Widget That Applies a Server-side Filter===

imported>Jason.nicholls at 03:48, 17 July 2014

2014-07-17T03:48:12Z

← Older revision		Revision as of 03:48, 17 July 2014
Line 1:		Line 1:
			{{DISPLAYTITLE:Server-Side Queries}}
			[[Category:AppBoard old]]
	AppBoard consists of two major segments:		AppBoard consists of two major segments:

imported>Jason.nicholls: moved AppBoard Server-Side Queries to appboard/old/server side queries

2014-07-17T03:47:42Z

moved AppBoard Server-Side Queries to appboard/old/server side queries

← Older revision	Revision as of 03:47, 17 July 2014
(No difference)

imported>Jason.nicholls at 15:16, 27 August 2013

2013-08-27T15:16:47Z

← Older revision		Revision as of 15:16, 27 August 2013
Line 41:		Line 41:
	The following illustration shows an example of configuring a Data Collection to apply a server-side filter:		The following illustration shows an example of configuring a Data Collection to apply a server-side filter:

	[[Image:~~serverSideDataCollectionFilter~~.png\|thumb\|center\|500px\|Configuring a Data Collection to Apply a Server-side Filter]]		[[Image:ServerSideDataCollectionFilter.png\|thumb\|center\|500px\|Configuring a Data Collection to Apply a Server-side Filter]]

	For more information on configuring Data Collections, see [[Data_Collections\|Data Collections]].		For more information on configuring Data Collections, see [[Data_Collections\|Data Collections]].

imported>Cmace: edited filtering collections link

2012-05-01T15:18:20Z

edited filtering collections link

← Older revision		Revision as of 15:18, 1 May 2012
Line 48:		Line 48:
	===Defining an Action on a Widget That Applies a Server-side Filter===		===Defining an Action on a Widget That Applies a Server-side Filter===

	You can define an Action on a Widget to apply a server-side filter when the Widget is clicked. The concept is the same as the client-side filtering example illustrated in the article on [[~~Filtering_Collections_in_AppBoard~~#Using_Actions_To_Filter_and_Collect_Data\|Client-side Filtering]], except in this case the filter will be applied on the AppBoard data server and not in the client.		You can define an Action on a Widget to apply a server-side filter when the Widget is clicked. The concept is the same as the client-side filtering example illustrated in the article on [[Filtering_Collections_Concepts#Using_Actions_To_Filter_and_Collect_Data\|Client-side Filtering]], except in this case the filter will be applied on the AppBoard data server and not in the client.

	The following illustration shows an example of configuring an Action on a Widget to launch a Child Board and invoke a server-side filter:		The following illustration shows an example of configuring an Action on a Widget to launch a Child Board and invoke a server-side filter:

	[[Image:ServerSideFilterAction.png\|thumb\|center\|500px\|Configuring an Action on a Widget to Launch a Child Board and Invoke a Server-side Filter]]		[[Image:ServerSideFilterAction.png\|thumb\|center\|500px\|Configuring an Action on a Widget to Launch a Child Board and Invoke a Server-side Filter]]

imported>Cmace: fixed links to reflect recent changes

2012-03-13T19:46:58Z

fixed links to reflect recent changes

← Older revision		Revision as of 19:46, 13 March 2012
Line 43:		Line 43:
	[[Image:serverSideDataCollectionFilter.png\|thumb\|center\|500px\|Configuring a Data Collection to Apply a Server-side Filter]]		[[Image:serverSideDataCollectionFilter.png\|thumb\|center\|500px\|Configuring a Data Collection to Apply a Server-side Filter]]

	For more information on configuring Data Collections, see [[~~Appboard_Builder/DataCollections~~\|~~Appboard Builder~~ Data Collections]].		For more information on configuring Data Collections, see [[Data_Collections\|Data Collections]].

imported>Cmace: fixed drilldown link to action switch to a board link

2012-03-08T19:05:46Z

fixed drilldown link to action switch to a board link

← Older revision		Revision as of 19:05, 8 March 2012
Line 27:		Line 27:
	There are two ways to configure server-side filters in AppBoard:		There are two ways to configure server-side filters in AppBoard:
	# By defining a Data Collection that applies a server-side filter to a Data Source		# By defining a Data Collection that applies a server-side filter to a Data Source
	# By defining an Action on a Widget that applies a server-side filter when the user clicks to [[~~AppBoard_Drill-Downs~~\|drill-down]] into the Widget		# By defining an Action on a Widget that applies a server-side filter when the user clicks to [[Action_Switch_To_A_Board\|drill-down]] into the Widget

imported>Cmace: copied over from internalwiki

2011-05-18T14:43:44Z

copied over from internalwiki

New page

AppBoard consists of two major segments:

# A set of data gathering adapters that reside and operate on the Appboard server
# A visualization engine that resides on the client (end-user's computer).

__TOC__

==Server and Client Components==

[[Image:HeaderFlow02.png|thumb|center|500px|Server-Side Query Conceptualization]]

AppBoard provides the ability to implement queries and filter data on either the server or the client. The way you decide to filter data may vary from case to case, depending on how the data will be used. The following concepts should be considered when deciding where to filter data in Appboard:

* If too much data is passed into the client, this can use up memory in the client and impact performance
* If not enough data is passed into the client, the client may have to make too many requests back to the server to request additional data, also impacting performance
* The server is generally more powerful at querying and processing data than the client
* Client-side queries can run Regular Expressions, while server-side queries are limited primarily to SQL queries

Given consideration of all the above, at times you may decide that a request for a certain type of data will need to trigger a server-side query.

==Configuring Server-side Filters==

There are two ways to configure server-side filters in AppBoard:
# By defining a Data Collection that applies a server-side filter to a Data Source
# By defining an Action on a Widget that applies a server-side filter when the user clicks to [[AppBoard_Drill-Downs|drill-down]] into the Widget

===Defining a Data Collection with a Server-side Filter===

When you create a Data Collection with a server-side filter, any Widget that uses that Data Collection as a data source will automatically have the server-side filter applied. This query only needs to get run once when the Data Collection is created (or at the designated polling interval). Additional client-side filters can subsequently be applied to this Data Collection to further refine the data, if needed.

Perform the following steps to create a Data Collection with a server-side Filter:
# Create a new Data Collection
# On the "Configure" screen in the Data Collections wizard, click "Add Rule" to create one or more server-side filters
# Use the Data Collection in a Widget

The following illustration shows an example of configuring a Data Collection to apply a server-side filter:

[[Image:serverSideDataCollectionFilter.png|thumb|center|500px|Configuring a Data Collection to Apply a Server-side Filter]]

For more information on configuring Data Collections, see [[Appboard_Builder/DataCollections|Appboard Builder Data Collections]].

===Defining an Action on a Widget That Applies a Server-side Filter===

You can define an Action on a Widget to apply a server-side filter when the Widget is clicked. The concept is the same as the client-side filtering example illustrated in the article on [[Filtering_Collections_in_AppBoard#Using_Actions_To_Filter_and_Collect_Data|Client-side Filtering]], except in this case the filter will be applied on the AppBoard data server and not in the client.

The following illustration shows an example of configuring an Action on a Widget to launch a Child Board and invoke a server-side filter:

[[Image:ServerSideFilterAction.png|thumb|center|500px|Configuring an Action on a Widget to Launch a Child Board and Invoke a Server-side Filter]]