Data Grid Dynamic Columns

Data Grid Dynamic Columns (ODC)

Stable version 1.0.2 (Compatible with ODC)
Uploaded on 28 October 2024 by Truewind
Data Grid Dynamic Columns

Data Grid Dynamic Columns (ODC)

Documentation
1.0.2

Demo App is currently available only on O11.


This library is capable to parse this JSON:

Into this one, ready to be displayed as dynamic columns, according to how many different brands you have on your database:

Which will result in the following datagrid, where data from the database can be used as columns.



To use this component, you will need to.

  1. Fetch Data focused on how it will map to the main Structure
    1. HeaderColumnData
    2. DynamicColumnName
    3. CellValue
  2. THE DATA FETCHED MUST BE SORTED BY THE HEADERCOLUMNDATA ATTRIBUTE
  3. Fetch unique dynamic column names into the DynamicColumnDataType structure with their names and expected data types
  4. Use the ArrangeData_ForDynamicColumns, server or client side, to convert your query data into the expected JSON format.
  5. Use the ParseJson_ToDynamicColumnsDynamicDataType client action to convert the output of the previous action into the dynamic columns JSON .
  6. Use the output of the previous action as source to the datagrid
  7. Use the datagrid starter block as a starter for your datagrid with dynamic columns.


To help you better visualize how each input will be shown in the final datagrid, you can see this table.

| Header Column Name | Dynamic C1 | Dynamic C2 | Dynamic C3 |

| Header Colm Data 1 | Value | Value | Value |

| Header Colm Data 2 | Value | Value | Value |

| Header Colm Data 3 | Value | Value | Value |


Each Dynamic C is one of the unique values provided to the DynamicColumnName attribute from the structure below input.

Each Header Colm Data C is one of the unique values provided to the HeaderColumnData attribute from the structure below input.

Each Value is the CellValue from the pair HeaderColumnData x DynamicColumnName from the ArrangeData_ForDynamicColumns structure.