- How to Import Data from an Excel or Ascii File into a Grid Component
/pages/HowTo/Grid/Import Excel or Ascii to Grid.xml
Data in an Excel file or comma delimited Ascii file can be imported into a Grid Component based on a table in a database.
- Search a Grid Component that is Embedded into a UX component
Create a highly customized 'Search Part' for a Grid. Allows you to submit a UX component that
contains 'search' fields to compute a filter expression and then filter a Grid component that has been embedded into the UX component.
- How to Export Selected Records to Excel in a Grid Component with a Checkbox Selector
/pages/HowTo/Grid/Export Checked Records to Excel.xml
Individual rows in a Grid Component can be exported to an Excel file using the Checkbox Selector Column to filter the Grid Component before performing the export.
- How to Set Default Component Property Values for a Grid
/pages/HowTo/Grid/Setting Default Property Values.xml
The default values for new Grid components can be configured. This is particularly useful if you are developing many Grid components that need to suppport multiple languages or are always making the same set of changes to every new Grid Component.
- How to Filter Records in a Grid Component Using Information from the Extended User Info Table
/pages/HowTo/Grid/Filter Records Using Extended User Info.xml
Learn how to filter records in a Grid component based on the currently logged in user using the "USERID" field from the Extended User Information table.
- Open a UX component to Edit Current Record in Grid, or add a new Record
Open an UX component in a pop-up window, or in a DIV on the current page, to edit the current row in a Grid component or to enter a new record.
(Only new Ajax Components can be opened. Old Dialogs in V10 and earlier are not supported.)
- Has row expander
/pages/Guides/Mobile and Web Components/Grid/Grid Properties/Row Expander/Has row expander.xml
The row expander is another method to show information related to a record on a row. A column is added with a 'plus' icon that can be selected to 'expand the row'. A minus icon will be shown after the row is expanded that can be selected to close the expanded row. There are 2 row expander types.
- Advanced use of "ShowRowExpanderIcon" event
/pages/Index/Old Feature Peeks/Advanced use of ShowRowExpanderIcon event.xml
When you use the Row Expander feature in a grid, by default, the expand icon is shown next to each row in the grid, regardless of whether that row actually has any records. In some cases, you might want to suppress the row expander icon from showing if there if there are no child records. You can do this using the ShowRowExpanderIcon event.
- Clear a Search a Grid Component that is Embedded into a UX component
For use in conjunction with the 'Search a Grid Component that is Embedded into a UX' action.
Clears the search form in the UX and removes the filter from the embedded Grid.
- Opening a Page with a Grid Component and Showing Selected Records
/pages/Server/Guide/Design/View/Grid/Opening a Page with a Grid Component and Showing Selected Records.xml
A common requirement when building a grid is to have a hyperlink field in the grid that, when clicked, will open a second page. The second page contains a grid that is filtered based on parameters from the first page. These examples show how to do this.
The URL that opens the second page has query parameters that contain one or more of the _filter, _order, and _link keywords. These keywords allow you to specify a filter, order and/or linking parameters for the grid in the target page.