Data Grid Properties - Revision history

Ollvihe at 15:00, 15 January 2020

2020-01-15T15:00:23Z

2019-12-10T16:43:57Z

2019-12-10T16:43:13Z

Data Grid Click and Popup Menu Events

2019-05-23T14:30:14Z

2019-02-20T15:27:41Z

2018-12-28T08:06:48Z

Common Settings

2018-12-28T08:06:29Z

Common Settings

2018-12-28T08:04:06Z

Common Settings

2018-12-12T08:51:07Z

Datasource in JSON Settings

2018-12-12T08:50:20Z

Data Grid JSON Settings

@@ Line 143: / Line 143: @@
+}
 </pre>
-By default, the exportToExcelAction, exportToWordAction, and exportToPdfAction values point to locations on the same host. Therefore, if you have [[Routing_Through_IIS_in_QPR_UI|routed QPR UI traffic through IIS]] and you have the Data Grid Export Service installed on the same IIS, you don't necessarily need to define the values here, as the URLs are already pointing to the correct place (e.g. http://<YourHostname>/SyncfusionGridExport/excelExport).
+By default, the exportToExcelAction, exportToWordAction, and exportToPdfAction values point to locations on the same host.
 |}

@@ Line 1: / Line 1: @@
 Data Grid is a versatile table presentation object allowing e.g. sorting, filtering, grouping and column reordering. The visual layout of Data Grid can be flexibly changed using CSS.
 On the '''JSON settings''' field in the '''Presentation''' tab, you can change variety of Data Grid features, such as searching, filtering, paging, sorting, grouping, whether the Data grid selection is in row or cell mode, and so on. QPR UI uses Syncfusion component to draw the Data Grid. See the Syncfusion demos to see the available features and check from the settings reference how the desired settings are enabled:
 * Syncfusion Grid demo: http://js.syncfusion.com/demos/web/#!/bootstrap/grid/defaultfunctionalities
@@ Line 10: / Line 9: @@
 The "Show effective JSON" selection shows the underlying current JSON definition including the definition you have done yourself. You can use the effective JSON as a starting point for your customized JSON settings.
-=== Common Settings===
+=== Common JSON Settings===
 Examples of changing JSON settings:

@@ Line 244: / Line 244: @@
 * CSS tutorial: https://www.w3schools.com/css/
 * CSS settings reference: https://www.w3schools.com/cssref/
 [[Category: QPR UI]]

@@ Line 372: / Line 372: @@
 * '''places''' = Finland,Sweden-Espoo,Stockholm
 * '''capital''' = false,true
 [[Category: QPR UI]]

@@ Line 132: / Line 132: @@
 ||Excel, Word and PDF exporting
 ||
-Enabling the export functionalities is controlled in the "toolbarSettings" block. In addition, the exportToExcelAction, exportToWordAction, and exportToPdfAction objects need to contain the URLs for the [[Data Grid Export Service|corresponding export service]]. In this example, context variables are used for the export service URL definitions:
+Enabling the export functionalities is controlled in the "toolbarSettings" block. In addition, the exportToExcelAction, exportToWordAction, and exportToPdfAction objects need to contain the URLs for the [[QPR UI Data Grid Export Service|corresponding export service]]. In this example, context variables are used for the export service URL definitions:
 <pre>
+{

@@ Line 86: / Line 86: @@
 </pre>
 |-
-||Multiple Cells Selection
+||Multiple cells selection
 ||
 <pre>

@@ Line 32: / Line 32: @@
    "filterSettings" : {
      "filterType": "excel"
+   }
+}
@@ Line 64: / Line 75: @@
 </pre>
 |-
-||Multiple Rows Selection Mode
+||Multiple rows selection
 ||
 <pre>
@@ Line 75: / Line 86: @@
 </pre>
 |-
-||Multiple Cells Selection Mode
+||Multiple Cells Selection
 ||
 <pre>
@@ Line 86: / Line 97: @@
 </pre>
 |-
-||Minimum Column Width
+||Minimum column width
 ||
 <pre>
@@ Line 95: / Line 106: @@
 Link to Syncfusion settings reference: https://help.syncfusion.com/api/js/ejgrid#members:minwidth
 |-
-||Specific Column Widths
+||Specific column widths
 ||
 Setting the width to the second, third, and fifth columns named "Case", "Event Type", and "Cost" respectively:
@@ Line 110: / Line 121: @@
 </pre>
 |-
-||Resizable Columns
+||Resizable columns
 ||
 <pre>
@@ Line 119: / Line 130: @@
 Note that the resized widths cannot be saved, so this setting is for view-time only.
 |-
-||Search
+||Excel, Word and PDF exporting
 ||
 Enabling the export functionalities is controlled in the "toolbarSettings" block. In addition, the exportToExcelAction, exportToWordAction, and exportToPdfAction objects need to contain the URLs for the [[Data Grid Export Service|corresponding export service]]. In this example, context variables are used for the export service URL definitions:

@@ Line 17: / Line 17: @@
 !Configuration
 |-
-||Disable filtering
+||Filtering
 ||
 By default, column filtering is used. It can be disabled as follows:
@@ Line 118: / Line 118: @@
 </pre>
 Note that the resized widths cannot be saved, so this setting is for view-time only.
 |-
 ||Search

@@ Line 156: / Line 156: @@
 === Datasource in JSON Settings ===
-It's possible to define the data grid to use a certain [[Datasets_in_QPR_UI|dataset]] by using the JSON settings' '''dataSource''' attribute that contains a valid [[Dataset_Tag_in_QPR_UI|dataset tag]] as the value:
+It's possible to define the Data Grid to use a certain [[Datasets_in_QPR_UI|dataset]] by using the '''dataSource''' attribute in the JSON settings that contains a valid [[Dataset_Tag_in_QPR_UI|dataset tag]] as the value:
 <pre>
+{

@@ Line 7: / Line 7: @@
 * Syncfusion Grid settings reference: https://help.syncfusion.com/api/js/ejgrid
 Check [https://www.w3schools.com/js/js_json_intro.asp https://www.w3schools.com/js/js_json_intro.asp] for more information about JSON.
 === Common Settings===