data-grid-extension
Reactive icon

Data Grid Extension

Stable version 2.4.0 (Compatible with OutSystems 11)
Uploaded
 on 17 Apr (3 days ago)
 by 
5.0
 (3 ratings)
data-grid-extension

Data Grid Extension

Documentation
2.4.0

Check the Dependency in your module:



Comments


1. CellEventOnGrid

  • You need to use the Action GetRowData of OutSystems Data Grid by its Event Parameters when you want to get the RowData
  • So if you want to add only Click Event, the Block OnCellClick of OutSystems Data Grid is the best
  • But it returns also Grid Column Index and Grid Cell Data of a cell where Event happened
  • And it allows you to add Double-Click or Keyboard Event besides Click


2. AllowEditableByCellData

  • It won't work when the Property AllowEdit of the Widget GridColumn is False, like the editor doesn't open when the AllowEdit of the Widget Grid is False although GridColumn's AllowEdit is True
  • The new row that hasn't create to DB yet is always editable


3. GetFocusedRowsData

  • It can also return data of rows that you selected for the Action GetSelectedRowsData or the Action GetCheckedRowsData
  • If you want to get data only selected by the Checkbox of RowHeader, the Action GetCheckedRowsData of OutSystems Data Grid is the best


4. RemoveCheckedRows

  • It requires the RowCheckbox of the Property RowHeader of the Widget Grid


5. SelectGridCell

  • The last row's cell is selected when the Parameter GridRowIndex is greater than the length of Grid Row
  • The last column's cell is selected when the Parameter GridColIndex is greater than the length of Grid Column
  • The first row's cell or column's cell is selected when the Parameter is less than 0
  • The first column's cell is selected when the Parameter GridColIndex and ColumnBinding don't have values
  • The Parameter ColumnBinding takes priority over the Parameter GridColIndex


6. ArrangeDataOnClientSide

  • It allows you to get DataJSON of the server action ArrangeData in ODC
  • You can copy it to ODC for using the property AllowColumnEdit of Grid
  • Its guideline is in the screen ArrangeDataOnClientSide of the Demo App


7. AddNewRowsBottom

  • By default (if the NumberOfRows is not defined), only one row will be added.
  • If the NumberOfRows is 0, the number of rows added to the grid is equal to the number of selected rows. If there is no selection, one row will be added.
  • It's only possible to add new bottom rows on the single page grid (The property ServerSidePagination of the grid is set True or the property RowsPerPage is -1).


8. AllowColumnsNullifiable

  • It allows columns corresponding to the given bindings to be nullifiable.
  • You can delete cell values of columns even if they are not the TextColumn.
  • It's not possible to apply to the ActionColumn, ImageColumn, and CalculatedColumn.


9. OnScrollEnd


10. GetColumnDataType


11. SetVerticalScrollPosition


2.3.0

Check the Dependency in your module:



Comments


1. CellEventOnGrid

  • You need to use the Action GetRowData of OutSystems Data Grid by its Event Parameters when you want to get the RowData
  • So if you want to add only Click Event, the Block OnCellClick of OutSystems Data Grid is the best
  • But it returns also Grid Column Index and Grid Cell Data of a cell where Event happened
  • And it allows you to add Double-Click or Keyboard Event besides Click


2. AllowEditableByCellData

  • It won't work when the Property AllowEdit of the Widget GridColumn is False, like the editor doesn't open when the AllowEdit of the Widget Grid is False although GridColumn's AllowEdit is True
  • The new row that hasn't create to DB yet is always editable


3. GetFocusedRowsData

  • It can also return data of rows that you selected for the Action GetSelectedRowsData or the Action GetCheckedRowsData
  • If you want to get data only selected by the Checkbox of RowHeader, the Action GetCheckedRowsData of OutSystems Data Grid is the best


4. RemoveCheckedRows

  • It requires the RowCheckbox of the Property RowHeader of the Widget Grid


5. SelectGridCell

  • The last row's cell is selected when the Parameter GridRowIndex is greater than the length of Grid Row
  • The last column's cell is selected when the Parameter GridColIndex is greater than the length of Grid Column
  • The first row's cell or column's cell is selected when the Parameter is less than 0
  • The first column's cell is selected when the Parameter GridColIndex and ColumnBinding don't have values
  • The Parameter ColumnBinding takes priority over the Parameter GridColIndex


6. ArrangeDataOnClientSide

  • It allows you to get DataJSON of the server action ArrangeData in ODC
  • You can copy it to ODC for using the property AllowColumnEdit of Grid
  • Its guideline is in the screen ArrangeDataOnClientSide of the Demo App


7. AddNewRowsBottom

  • By default (if the NumberOfRows is not defined), only one row will be added.
  • If the NumberOfRows is 0, the number of rows added to the grid is equal to the number of selected rows. If there is no selection, one row will be added.
  • It's only possible to add new bottom rows on the server-side grid (The property ServerSidePagination of the grid is set True).
  • It's only possible to add new bottom rows on the single page grid (The property ServerSidePagination of the grid is set True or the property RowsPerPage is -1).


8. AllowColumnsNullifiable

  • It allows columns corresponding to the given bindings to be nullifiable.
  • You can delete cell values of columns even if they are not the TextColumn.
  • It's not possible to apply to the ActionColumn, ImageColumn, and CalculatedColumn.

2.2.0

Check the Dependency in your module:



Comments


1. CellEventOnGrid

  • You need to use the Action GetRowData of OutSystems Data Grid by its Event Parameters when you want to get the RowData
  • So if you want to add only Click Event, the Block OnCellClick of OutSystems Data Grid is the best
  • But it returns also Grid Column Index and Grid Cell Data of a cell where Event happened
  • And it allows you to add Double-Click or Keyboard Event besides Click


2. AllowEditableByCellData

  • It won't work when the Property AllowEdit of the Widget GridColumn is False, like the editor doesn't open when the AllowEdit of the Widget Grid is False although GridColumn's AllowEdit is True
  • The new row that hasn't create to DB yet is always editable


3. GetFocusedRowsData

  • It can also return data of rows that you selected for the Action GetSelectedRowsData or the Action GetCheckedRowsData
  • If you want to get data only selected by the Checkbox of RowHeader, the Action GetCheckedRowsData of OutSystems Data Grid is the best


4. RemoveCheckedRows

  • It requires the RowCheckbox of the Property RowHeader of the Widget Grid


5. SelectGridCell

  • The last row's cell is selected when the Parameter GridRowIndex is greater than the length of Grid Row
  • The last column's cell is selected when the Parameter GridColIndex is greater than the length of Grid Column
  • The first row's cell or column's cell is selected when the Parameter is less than 0
  • The first column's cell is selected when the Parameter GridColIndex and ColumnBinding don't have values
  • The Parameter ColumnBinding takes priority over the Parameter GridColIndex


6. ArrangeDataOnClientSide

  • It allows you to get DataJSON of the server action ArrangeData in ODC
  • You can copy it to ODC for using the property AllowColumnEdit of Grid
  • Its guideline is in the screen ArrangeDataOnClientSide of the Demo App


7. AddNewRowsBottom

  • By default (if the NumberOfRows is not defined), only one row will be added.
  • If the NumberOfRows is 0, the number of rows added to the grid is equal to the number of selected rows. If there is no selection, one row will be added.
  • It's only possible to add new bottom rows on the server-side grid (The property ServerSidePagination of the grid is set True).

2.1.0

Check the Dependency in your module:




Comments


1. CellEventOnGrid

  • You need to use the Action GetRowData of OutSystems Data Grid by its Event Parameters when you want to get the RowData
  • So if you want to add only Click Event, the Block OnCellClick of OutSystems Data Grid is the best
  • But it returns also Grid Column Index and Grid Cell Data of a cell where Event happened
  • And it allows you to add Double-Click or Keyboard Event besides Click


2. AllowEditableByCellData

  • It won't work when the Property AllowEdit of the Widget GridColumn is False, like the editor doesn't open when the AllowEdit of the Widget Grid is False although GridColumn's AllowEdit is True
  • The new row that hasn't create to DB yet is always editable


3. GetFocusedRowsData

  • It can also return data of rows that you selected for the Action GetSelectedRowsData or the Action GetCheckedRowsData
  • If you want to get data only selected by the Checkbox of RowHeader, the Action GetCheckedRowsData of OutSystems Data Grid is the best


4. RemoveCheckedRows

  • It requires the RowCheckbox of the Property RowHeader of the Widget Grid


5. SelectGridCell

  • The last row's cell is selected when the Parameter GridRowIndex is greater than the length of Grid Row
  • The last column's cell is selected when the Parameter GridColIndex is greater than the length of Grid Column
  • The first row's cell or column's cell is selected when the Parameter is less than 0
  • The first column's cell is selected when the Parameter GridColIndex and ColumnBinding don't have values
  • The Parameter ColumnBinding takes priority over the Parameter GridColIndex


6. ArrangeDataOnClientSide

  • It allows you to get DataJSON of the server action ArrangeData in ODC
  • You can copy it to ODC for using the property AllowColumnEdit of Grid
  • Its guideline is in the screen ArrangeDataOnClientSide of the Demo App

2.0.0

Check the Dependency in your module:




Comments


1. CellEventOnGrid

  • You need to use the Action GetRowData of OutSystems Data Grid by its Event Parameters when you want to get the RowData
  • So if you want to add only Click Event, the Block OnCellClick of OutSystems Data Grid is the best
  • But it returns also Grid Column Index and Grid Cell Data of a cell where Event happened
  • And it allows you to add Double-Click or Keyboard Event besides Click


2. AllowEditableByCellData

  • It won't work when the Property AllowEdit of the Widget GridColumn is False, like the editor doesn't open when the AllowEdit of the Widget Grid is False although GridColumn's AllowEdit is True
  • The new row that hasn't create to DB yet is always editable


3. GetFocusedRowsData

  • It can also return data of rows that you selected for the Action GetSelectedRowsData or the Action GetCheckedRowsData
  • But for the Action GetCheckedRowsData, when rows was selected by Checkboxes, it can't return
  • If you want to get data only selected by the Checkbox of RowHeader, the Action GetCheckedRowsData of OutSystems Data Grid is the best


4. RemoveCheckedRows

  • It requires the RowCheckbox of the Property RowHeader of the Widget Grid


5. SelectGridCell

  • The last row's cell is selected when the Parameter GridRowIndex is greater than the length of Grid Row
  • The last column's cell is selected when the Parameter GridColIndex is greater than the length of Grid Column
  • The first row's cell or column's cell is selected when the Parameter is less than 0
  • The first column's cell is selected when the Parameter GridColIndex and ColumnBinding don't have values
  • The Parameter ColumnBinding takes priority over the Parameter GridColIndex

1.0.1

Check the Dependency in your module:




Comments


1. CellEventOnGrid

  • You need to use the Action GetRowData of OutSystems Data Grid by its Event Parameters when you want to get the RowData
  • So if you want to add only Click Event, the Block OnCellClick of OutSystems Data Grid is the best
  • But it returns also Grid Column Index and Grid Cell Data of a cell where Event happened
  • And it allows you to add Double-Click or Keyboard Event besides Click


2. AllowEditableByCellData

  • It won't work when the Property AllowEdit of the Widget GridColumn is False, like the editor doesn't open when the AllowEdit of the Widget Grid is False although GridColumn's AllowEdit is True
  • The new row that hasn't create to DB yet is always editable


3. GetFocusedRowsData

  • It can also return data of rows that you selected for the Action GetSelectedRowsData
  • But for the Action GetCheckedRowsData, when rows was selected by Checkboxes, it can't return


4. RemoveCheckedRows

  • It requires the RowCheckbox of the Property RowHeader of the Widget Grid


5. SelectGridCell

  • The last row's cell is selected when the Parameter GridRowIndex is greater than the length of Grid Row
  • But for the Parameter GridColIndex, the selection border will be missing
  • The last column's cell is selected when the Parameter GridColIndex is greater than the length of Grid Column
  • The first row's cell or column's cell is selected when the Parameter is less than 0

1.0.0

Check the Dependency in your module:




Comments


1. CellEventOnGrid

  • You need to use the Action GetRowData of OutSystems Data Grid by its Event Parameters when you want to get the RowData
  • So if you want to add only Click Event, the Block OnCellClick of OutSystems Data Grid is the best
  • But it returns also Grid Column Index and Grid Cell Data of a cell where Event happened
  • And it allows you to add Double-Click or Keyboard Event besides Click


2. AllowEditableByCellData

  • It won't work when the Property AllowEdit of the Widget GridColumn is False, like the editor doesn't open when the AllowEdit of the Widget Grid is False although GridColumn's AllowEdit is True


3. GetFocusedRowsData

  • It can also return data of rows that you selected for the Action GetSelectedRowsData
  • But for the Action GetCheckedRowsData, when rows was selected by Checkboxes, it can't return


4. RemoveCheckedRows

  • It requires the RowCheckbox of the Property RowHeader of the Widget Grid


5. SelectGridCell

  • The last row's cell is selected when the Parameter GridRowIndex is greater than the length of Grid Row
  • But for the Parameter GridColIndex, the selection border will be missing