Grid

Description:

Allowed Parent Components:

1. Card Body

2. Grid Child

3. Horizontal Section

4. Vertical Section

Allowed Child Components:

1. Attachment Column

2. Calculated Number Column

3. Calculated String Column

4. Checkbox Column

5. Custom Renderer Column

6. Date Column

7. Google Drive Attachment Column

8. Icon Column

9. Lov Column

10. Number Column

11. Progress Column

12. Pulse

13. Row Col Column

14. Row Number Column

15. Row Selection Column

16. Select Column

17. Slide Toggle Column

18. String Column

19. Switch Column

20. Tree Column

21. Trigger Before Render

22. Trigger On No Data Action Button Click

23. Trigger On Row Click

24. TriggerOnRowDoubleClick

25. User Pic Column

26. 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