Difference between revisions of "Editable Data Grid"

From Mea Wiki
Jump to navigation Jump to search
Line 1: Line 1:
'''Editable Data Grid''' is a table, that shows data from QPR Suite, and the data can be edited. 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, but not QPR ProcessDesigner or QPR EnterpriceArchitect.
+
'''Editable Data Grid''' is a table, that shows data from QPR Suite Web Service, and the data can be edited. 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, but not QPR ProcessDesigner or QPR EnterpriceArchitect.
 +
 
 +
Data shown in the data grid is fetched using QPR Suite Web Service query, where each row is linked to one object and each column is linked to an attribute in the Web Service.
 +
 
 +
Note that, the editable data grid doesn't use datasets.
  
 
{| class="wikitable"
 
{| class="wikitable"
Line 58: Line 62:
 
||validationRules
 
||validationRules
 
||
 
||
 +
It's possible to define validation rules for each column. Following validation rules are available:
 
* '''required''' (boolean): Value is required, i.e. it cannot be empty.
 
* '''required''' (boolean): Value is required, i.e. it cannot be empty.
 
* '''minlength''' (integer): Minimum number of charactes in a textual value.
 
* '''minlength''' (integer): Minimum number of charactes in a textual value.

Revision as of 14:20, 15 February 2018

Editable Data Grid is a table, that shows data from QPR Suite Web Service, and the data can be edited. 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, but not QPR ProcessDesigner or QPR EnterpriceArchitect.

Data shown in the data grid is fetched using QPR Suite Web Service query, where each row is linked to one object and each column is linked to an attribute in the Web Service.

Note that, the editable data grid doesn't use datasets.

Property Description
selectedRowVariable Local context variable where currently selected row's object id of stored. Note that the selected row doesn't change, when the context variable is changed from somewhere else.
query Query parameter for the QPR Suite Web Service query to get the rows to the data grid.
sortby Sorting parameter for the QPR Suite Web Service query to get the rows to the data grid.
queryoptions Options parameter for the QPR Suite Web Service query to get the rows to the data grid.
columns Array of objects where each represent a column in the editable data grid.
Property Description
attribute QPR Suite Web Service attribute name.
attributeParameters Parameters for the attribute.
headerText Column header text that is visible to users.
type
  • textbox: shows a textbox for storing string values.
  • numericbox: shows a textbox for numeric values. It's not possible to input textual data.
  • dropdown: shows a dropdown list where user can select from a list of predefined items. The items are defined in the dropdownoptions property.
  • metricsdate: shows a date selector that can store dates to Metrics date type of series.
  • date: shows a date selector that can store values using XML date format (e.g. 2018-10-05T16:26:42). Other date type of data than the Metrics date series, use the XML date format.
  • checkbox: shows a checkbox, which is used for storing two possible values. The possible values are defined in trueValue and falseValue properties.
dropdownoptions Options for the dropdown menu (object array with properties label [user visible text] and value [text to store to MEA]). Only used when dropdown is checkbox.
trueValue Attribute value corresponding to checkbox checked state of a checkbox. Used only used when type is checkbox.
falseValue Attribute value corresponding to checkbox unchecked state. Used only used when type is checkbox.
allowEditing
format
validationRules

It's possible to define validation rules for each column. Following validation rules are available:

  • required (boolean): Value is required, i.e. it cannot be empty.
  • minlength (integer): Minimum number of charactes in a textual value.
  • maxlength (integer): Maximum number of charactes in a textual value.
  • range (two integers): Requires the value to be in given value range.
  • min (integer): Minimum for numeric value.
  • max (integer): Maximum for numeric value.
  • email (boolean): The value must be a valid email address.
  • url (boolean): The value must be a valid email URL.
  • digits (boolean): The value must contain digits only.

Examples:

validationRules: { required: true, minlength: 3 }
validationRules: { range: [0, 100] }
{
  "editSettings": {
    "allowAdding": true,
    "allowDeleting": true,
    "allowEditing": true,
    "allowEditing": "normal"
  },
  "toolbarSettings": {
    "showToolbar": true,
    "toolbarItems": ["add", "edit", "delete", "update", "cancel"]
  }                             
}
{
  "columns": [
    { allowEditing: false },
  ]                             
}

Batch editing is not supported by the editable data grid (editSettings: { allowEditing: "batch" })