Datasets in QPR UI - Revision history

Ollvihe: /* Cancelling a QPR ProcessAnalyzer Dataset Query */

2019-12-03T21:55:32Z

Cancelling a QPR ProcessAnalyzer Dataset Query

Ollvihe: /* Datasources */

2019-11-21T12:54:20Z

Datasources

TeeHiet: 307356

2019-04-10T08:57:56Z

307356

Ollvihe: /* Datasources */

2018-12-02T22:07:40Z

Datasources

Ollvihe at 07:46, 30 November 2018

2018-11-30T07:46:00Z

Ollvihe: /* Editing Datasets */

2018-09-21T11:53:50Z

Editing Datasets

Ollvihe: /* Editing Datasets */

2018-09-21T11:53:19Z

Editing Datasets

Ollvihe at 12:46, 26 February 2018

2018-02-26T12:46:37Z

Ollvihe: /* Editing datasets */

2018-01-25T22:29:59Z

Editing datasets

Ollvihe: /* Changing datasets */

2018-01-25T22:29:54Z

Changing datasets

@@ Line 19: / Line 19: @@
 * '''Datasource''': Possible [[#Datasources|datasources]] where data can be queried.
 * '''Parameters''': You can define a query and possibly parameters that are sent to the web service depending on the used datasource. Please see more information which kind of syntax is used for different datasources from each datasource's page.
 [[Category: QPR UI]]

@@ Line 11: / Line 11: @@
 Following datasources are available:
 * [[QPR Suite Web Service Datasource|QPR Suite Web Service]]
 * [[QPR Reporting Expression]]

@@ Line 20: / Line 20: @@
 * '''Datasource''': Possible [[#Datasources|datasources]] where data can be queried.
 * '''Parameters''': You can define a query and possibly parameters that are sent to the web service depending on the used datasource. Please see more information which kind of syntax is used for different datasources from each datasource's page.
 [[Category: QPR UI]]

@@ Line 11: / Line 11: @@
 Following datasources are available:
 * [[QPR Suite Web Service Datasource|QPR Suite Web Service]]
 * [[QPR Reporting Expression]]

← Older revision		Revision as of 07:46, 30 November 2018
Line 1:		Line 1:
−	'''Datasets''' are used to fetch data from external datasources to present ~~that~~ data in QPR UI ~~views~~. Dataset is table which contains zero to many rows, and one to many named and ordered columns. Columns in a dataset are in a certain order that is determined by the data coming from the datasource. Dataset columns can be referred either using ''column name'' or ''column index'' (starting from one from the left). Data in dataset cells may have one of the following data types: string, integer, decimal, boolean and date. Usually all cells for a certain column contain same type of data. ~~Note that~~ the datasource ~~determines that type of data. Currently all data coming from [[QPR Suite Web Service Datasource\|QPR Suite Web Service]] datasource are strings~~.	+	'''Datasets''' are used to fetch data from external datasources to present the data in QPR UI. Dataset is a table which contains zero to many rows, and one to many named and ordered columns. Columns in a dataset are in a certain order that is determined by the data coming from the datasource. Dataset columns can be referred either using ''column name'' or ''column index'' (starting from one from the left). Data in a dataset cells may have one of the following data types: string, integer, decimal, boolean and date. Usually all cells for a certain column contain same type of data. Datatype information comes from the datasource.

	Datasets can be defined at any UI element levels (views, panels, repeaters and presentation objects). The defined dataset is available for presentation objects in the same level or any level below it in the UI element's hierarchy.		Datasets can be defined at any UI element levels (views, panels, repeaters and presentation objects). The defined dataset is available for presentation objects in the same level or any level below it in the UI element's hierarchy.

@@ Line 18: / Line 18: @@
 Datasets can be changed in '''Dataset''' tab containing following settings:
 * '''Dataset Identifier''': The identifier, which is shown on the list when selecting the datasource for a presentation object. The identifier should be unique within the view, panel, or presentation object where the dataset is defined.
-* '''Datasource''': Possible datasources where data can be queried.
+* '''Datasource''': Possible [[#Datasources|datasources]] where data can be queried.
 * '''Parameters''': You can define a query and possibly parameters that are sent to the web service depending on the used datasource. Please see more information which kind of syntax is used for different datasources from each datasource's page.
 [[Category: QPR UI]]

← Older revision		Revision as of 12:46, 26 February 2018
Line 1:		Line 1:
−	'''Datasets''' are used to fetch data from external ~~datasource and systems, and~~ present that data in QPR UI views. Dataset ~~has a tabular form, it~~ contains zero to many rows, and one to many named and ordered columns. ~~Dataset columns are ordered, which means that the columns~~ are in a certain order. Dataset columns can be referred either using column name or column index (starting from one from the left). ~~Dataset~~ cells may ~~contain~~ the following data types: string, integer, decimal, boolean and date~~. Date values are integer values representing the number of milliseconds since 1 January 1970 00:00:00 UTC with leap seconds ignored (i.e. the "Unix Epoch")~~. Usually all cells for a certain column contain same type of data.	+	'''Datasets''' are used to fetch data from external datasources to present that data in QPR UI views. Dataset is table which contains zero to many rows, and one to many named and ordered columns. Columns in a dataset are in a certain order that is determined by the data coming from the datasource. Dataset columns can be referred either using ''column name'' or ''column index'' (starting from one from the left). Data in dataset cells may have one of the following data types: string, integer, decimal, boolean and date. Usually all cells for a certain column contain same type of data. Note that the datasource determines that type of data. Currently all data coming from [[QPR Suite Web Service Datasource\|QPR Suite Web Service]] datasource are strings.

	Datasets can be defined at any UI element levels (views, panels, repeaters and presentation objects). The defined dataset is available for presentation objects in the same level or any level below it in the UI element's hierarchy.		Datasets can be defined at any UI element levels (views, panels, repeaters and presentation objects). The defined dataset is available for presentation objects in the same level or any level below it in the UI element's hierarchy.

@@ Line 15: / Line 15: @@
 * [[QPR Reporting Expression]]
-== Editing datasets ==
+== Editing Datasets ==
 Datasets can be changed in '''Dataset''' tab which contains following settings:
 * '''Dataset Identifier''': The identifier, which is shown on the list when selecting the datasource for a presentation object. The identifier should be unique within the view, panel, or presentation object where the dataset is defined.