Editable Data Grid - Revision history

Ollvihe at 21:52, 29 April 2018

2018-04-29T21:52:41Z

Ollvihe at 21:52, 29 April 2018

2018-04-29T21:52:10Z

Ollvihe: /* Configuration examples */

2018-04-29T09:54:57Z

Configuration examples

Ollvihe at 07:35, 27 April 2018

2018-04-27T07:35:14Z

TeeHiet: Actually, it's better to remove the scrolling thingies, we'll go with defaults

2018-04-18T11:58:24Z

Actually, it's better to remove the scrolling thingies, we'll go with defaults

TeeHiet: Enabled scrolling thingies in Example 4

2018-04-18T11:57:43Z

Enabled scrolling thingies in Example 4

TeeHiet: Entice -> QPR UI

2018-04-18T06:48:59Z

Entice -> QPR UI

TeeHiet: 307281

2018-04-18T05:46:19Z

307281

TeeHiet: 307281

2018-04-18T05:41:36Z

307281

TeeHiet: 307281

2018-04-17T13:22:58Z

307281

@@ Line 165: / Line 165: @@
 [other Syncfusion settings]
 ||
-All Syncfusion datagrid settings can be used: https://help.syncfusion.com/api/js/ejgrid#members:columns
+All Syncfusion Grid settings can be used: https://help.syncfusion.com/api/js/ejgrid#members:columns
 |-
 |}
@@ Line 173: / Line 173: @@
 [other syncfusion settings]
 ||
-All Syncfusion datagrid settings can be used: https://help.syncfusion.com/api/js/ejgrid#members:columns
+All Syncfusion Grid settings can be used: https://help.syncfusion.com/api/js/ejgrid#members:columns
 |}

@@ Line 163: / Line 163: @@
 |-
 ||
-[other syncfusion settings]
+[other Syncfusion settings]
 ||
 All Syncfusion datagrid settings can be used: https://help.syncfusion.com/api/js/ejgrid#members:columns

@@ Line 226: / Line 226: @@
+{
 "query": "[<#parentelementID>].childobjects",
-"sortby":"name",
+"sortBy":"name",
 "selectedRowVariable":"gridSelectedRowID",
 "additionalAttributes": {"description":"New element from QPR UI","parentelementid":"<#parentelementID>"},

@@ Line 1: / Line 1: @@
-'''Editable Data Grid''' is a table, that shows data from QPR Suite and the data can also be edited. The Editable Data Grid uses QPR Suite Web Service to query and save data, and thus QPR Suite Web Service properties define which kind of data can be edited. Mainly QPR Metrics, QPR Portal action forms and QPR Suite user management data can be edited, where as QPR ProcessDesigner or QPR EnterpriceArchitect cannot be edited.
+'''Editable Data Grid''' is a table, that shows data from QPR Suite and the data can also be edited. Editing possibility is the only difference to the [[Data Grid Properties|Data Grid]] presentation object. The Editable Data Grid uses QPR Suite Web Service to query and save data, and thus QPR Suite Web Service properties define which kind of data can be edited. Mainly QPR Metrics, QPR Portal action forms and QPR Suite user management data can be edited, where as QPR ProcessDesigner or QPR EnterpriceArchitect cannot be edited.
 Data shown in the data grid is fetched using QPR Suite Web Service query, where each row is linked to one QPR Suite object, and each column is linked to one attribute in the QPR Suite Web Service. Note that the editable data grid does not use [[Datasets_in_QPR_UI|datasets]] to fetch data.
@@ Line 48: / Line 48: @@
 |-
 ||templateObjectQuery
-||Query parameter for the QPR Suite Web Service query to get the template object to use when creating new objects. More information: http://kb.qpr.com/qpr2017-1/index.html?queryobjects.htm.
+||QPR Suite Web Service query to get the template object to use when new objects are created. Used only when new objects are created based on a template object. If the query returns multiple objects, the first one is used as a template. If the templateObjectQuery is not defined, new objects are not created based on a template. More information about queries: http://kb.qpr.com/qpr2017-1/index.html?queryobjects.htm.
 |-
 ||elementType
-||Used only when createObjectOptions is used. Defines the type of the new object. This needs to be a type name that is supported in the namespace. Also type ID can be used.
+||Defines the type of the created object. Used only when new objects are not created based on a template object. This needs to be a type name that is supported in the namespace. Also type ID can be used.
 |-
 ||namespace
-||Used only when createObjectOptions is used. The ID of the namespace into which the object is to be created.
+||Namespace into which new objects are created. When creating QPR Metrics objects, the namespace is the QPR Metrics model id. When creating QPR Portal actions forms, the namespace is ''PO''. When creating users and groups, the namespace is ''UM''. For QPR Metrics objects, the namespace can be omitted, because the namespace is assumed to be the same as the QPR Metrics model, where the parent element is located.
 |-
 ||columns

@@ Line 231: / Line 231: @@
 "parentAttribute":"parentelementid",
 "templateObjectQuery": "[<#templateObject>]",
 "toolbarSettings": {"showToolbar":true,"toolbarItems":["edit","update","cancel","add"]},
 "editSettings": {"allowEditing": true,"allowAdding":true},

@@ Line 222: / Line 222: @@
 </pre>
-Example 4: The following settings show a grid in which copies of a measure (ID of which is defined in the "templateObject" context variable) can be created under a parent measure (ID of which is defined in the "parentelementID" context variable). The grid will show all the created measures ("[<#parentelementID>].childobjects"). It's also possible to edit the values of the two series (with identifiers "ACT" and "NME") for latest period in the created copies.
+Example 4: The following settings show a grid in which copies of a measure (ID of which is defined in the "templateObject" context variable) can be created under a parent measure (ID of which is defined in the "parentelementID" context variable). The grid will show all the created measures ("[<#parentelementID>].childobjects"). It's also possible to edit the values of the two series (with identifiers "ACT" and "NME") for the latest period in the created copies.
 <pre>
+{

@@ Line 222: / Line 222: @@
 </pre>
-Example 4: The following settings show a grid in which copies of a measure (ID of which is defined in the "templateObject" context variable) can be created under a parent measure (ID of which is defined in the "parentelementID" context variable). The grid will show all the created measures ("[<#parentelementID>].childobjects"). It's also possible to edit the values of the two series (with identifiers "ACT" and "NME") for "Q1 / 2018" period in the created copies.
+Example 4: The following settings show a grid in which copies of a measure (ID of which is defined in the "templateObject" context variable) can be created under a parent measure (ID of which is defined in the "parentelementID" context variable). The grid will show all the created measures ("[<#parentelementID>].childobjects"). It's also possible to edit the values of the two series (with identifiers "ACT" and "NME") for latest period in the created copies.
 <pre>
+{
@@ Line 238: / Line 238: @@
+   [
      {"attribute": "name", "headerText":"Name", "inputType": "textbox","allowEditing":true},
-     {"attribute": "measure.value", "attributeParameters": "series=\"ACT\",period=\"Q1 / 2018\"", "headerText": "Numeric Value", "inputType": "numericbox", "allowEditing": true},
+     {"attribute": "measure.value", "attributeParameters": "series=\"ACT\",period=\"latest\"", "headerText": "Numeric Value", "inputType": "numericbox", "allowEditing": true},
-     {"attribute": "measure.value", "attributeParameters": "series=\"NME\",period=\"Q1 / 2018\"", "headerText": "Text Value", "inputType": "textbox", "allowEditing": true}
+     {"attribute": "measure.value", "attributeParameters": "series=\"NME\",period=\"latest\"", "headerText": "Text Value", "inputType": "textbox", "allowEditing": true}
+   ]
+}