Grid
Description:
Allowed Parent Components:
Card Body
Grid Child
Horizontal Section
Vertical Section
Allowed Child Components:
Attachment Column
Calculated Number Column
Calculated String Column
Checkbox Column
Custom Renderer Column
Date Column
Google Drive Attachment Column
Icon Column
Lov Column
Number Column
Progress Column
Pulse
Row Col Column
Row Number Column
Row Selection Column
Select Column
Slide Toggle Column
String Column
Switch Column
Tree Column
Trigger Before Render
Trigger On No Data Action Button Click
Trigger On Row Click
TriggerOnRowDoubleClick
User Pic Column
Wave Column
Properties
➤ Allow Column Locking
Enable this to show the user an option to freeze/unfreeze columns. This will add an icon button in the header of a column to freeze/unfreeze column on click. This property is only applicable to the column which is not frozen.
Allowed Values: Yes/No
➤ Allow Column Reorder
Enable this to allow user to re-order the columns of the grid on dragging. It will help user to customize the grid view.
Allowed Values: Yes/No
➤ Allow Column Resizing
Check this to allow users to resize grid columns.
Allowed Values: Yes/No
➤ Allow Column Sorting
Check this to allow users to sort column values. This will enable click on header cell which will sort the values in ascending or descending order.
Allowed Values: Yes/No
➤ Allow Multi Cell Selection
Enable this to allow user to select multiple cells.
Allowed Values: Yes/No
➤ Auto Fit Columns
Enable this to auto set the width of the columns to fit in the available width of the grid.
Allowed Values: Yes/No
➤ Borders
Check this to show borders to the Grid.
Allowed Values: Yes/No
➤ Hide Column Lines
Check this to show lines between the grid columns.
Allowed Values: Yes/No
➤ Hide Row Lines
Check this to show lines between the grid rows.
Allowed Values: Yes/No
➤ Hide Dirty Indicators
A grid cell is indicated with a red mark on the top corner of the cell on value change to show it as dirty. Check this property to hide this dirty indicator on value change.
Allowed Values: Yes/No
➤ Hide Headers
Check this to hide the header of the grid. This will hide all the features available on the grid header like sorting, resizing, filters, etc..
Allowed Values: Yes/No
➤ Highlight Current Cell
Enable this to highlight the current cell on click or tab in.
Allowed Values: Yes/No
➤ Highlight Current Row
Enable this to highlight the current row on click of the row cell.
Allowed Values: Yes/No
➤ Show Header Filters
Check this property to show/hide the filters on the column header.
Allowed Values: Yes/No
➤ Local Filter
Check this property to apply filter on fetched columns locally.
Allowed Values: Yes/No
➤ Local Sort
Check this property to sort the fetched columns locally.
Allowed Values: Yes/No
➤ Strip Rows
Check this to add zebra-striping to the rows within the table
Allowed Values: Yes/No
➤ Transparent
Check this property to make this grid transparent. By default the grid background color is white.
Allowed Values: Yes/No
➤ User Configurable
Check this property to hide/show the option to customize the grid.
Allowed Values: Yes/No
➤ Auto Wrap Header
Check this to enable auto wrap on header.
Allowed Values: Yes/No
➤ Hide Formula Column
Check this property to show/hide the formula column on the column header.
Allowed Values: Yes/No
➤ Hide No Data Placeholder
Check this to hide the data displayed when no data found.
Allowed Values: Yes/No
➤ No Data Icon
Select an icon to display when no data found.
Allowed Values: Icon List
➤ No Data Text1
Provide a text to display as title when no data found.
Allowed Values: Free text field
➤ No Data Text2
Provide a text to display as sub title when no data found.
Allowed Values: Free text field
➤ Height
Allowed Values: Any number value
➤ Row Height
Enter a numeric value to change the height of each row in the grid. By default, height is 26
Allowed Values: Any number value
➤ Header Height
Enter a numeric value to change the height of the header in the grid.
Allowed Values: Any number value
➤ Row Selection Color
Choose a color to set background color for selected rows
Allowed Values: Choose a color to set background color for selected rows
➤ Class Name Expression
Allowed Values: An expression which should return string after evaluation
➤ Use Existing Data Source
Choose this prop if you want to reuse a Data Source that was defined on some other component on this page or any of the parent abstract pages.
Allowed Values: Yes/No
➤ Data Source
Select a datasource from the list.
Allowed Values: Select a datasource from the list.
➤ Data Source Alias
Allowed Values: Free text field
➤ Default Where Clause
Allowed Values: Free text field
➤ Max Rows
Allowed Values: Any number value
➤ Order By Clause
e.g. #firstAttr#, #secondAttr# DESC
Allowed Values: Free text field
➤ Auto Query
Check this property to query the selected datasource on component render.
Allowed Values: Yes/No
➤ Execute Count SQL
Check this to execute count SQL to get the total number of rows in the database on a query. You can get this value by using the expression: #{DataStore.totalLength}
Allowed Values: Yes/No
➤ Execute Distinct SQL
Check this to execute distinct SQL to get the total number of distinct rows in the database on a query.
Allowed Values: Yes/No
➤ Insert Allowed
Allowed Values: Yes/No
➤ Update Allowed
Allowed Values: Yes/No
➤ Delete Allowed
Check to enable deleting the existing row.
Allowed Values: Yes/No
➤ Mask Page On Post
Check to enable page masking on save.
Allowed Values: Yes/No
➤ Do Not Monitor Query Request
Check to disable monitoring query request.
Allowed Values: Yes/No
➤ Silent Server Validate
Check to enable silent server validate.
Allowed Values: Yes/No
➤ Silent Fetch
Check to enable silent fetching.
Allowed Values: Yes/No
➤ Make New Records Dirty
Check this property to make new record dirty. If this property is checked the status of the new record will be 'Insert' else it will be 'New'
Allowed Values: Yes/No
➤ Server Validate On Create
Check this to perform any defaulting on the server side whenever a new record is created. For PL/SQL DataSource VALIDATEROW procedure will be called with '_INIT' as the value for the parameter P_CHANGED_ATTRIBUTE
Allowed Values: Yes/No
➤ On Row Active
Allowed Values: Controller Function
➤ On Row Double Click
Allowed Values: Controller Function
➤ Margin
Select a value to add margin on all four sides of the component. It is a shorthand for margin-top, margin-right, margin-bottom, and margin-left.
Allowed Values: Any number value
➤ Margin Bottom
Select a value to add margin on the bottom of the component.
Allowed Values: Any number value
➤ Margin Left
Select a value to add margin on the left of the component.
Allowed Values: Any number value
➤ Margin Right
Select a value to add margin on the right of the component.
Allowed Values: Any number value
➤ Margin Top
Select a value to add margin on the top of the component.
Allowed Values: Any number value
➤ Padding
Select a value to add padding on all four sides of the component. It is a shorthand for padding-top, padding-right, padding-bottom, and padding-left.
Allowed Values: Any number value
➤ Padding Bottom
Select a value to add padding in the bottom of the component.
Allowed Values: Any number value
➤ Padding Left
Select a value to add padding in the left of the component.
Allowed Values: Any number value
➤ Padding Right
Select a value to add padding in right of the component.
Allowed Values: Any number value
➤ Padding Top
Select a value to add padding in top of the component.
Allowed Values: Any number value
Last updated