Grid properties
A grid lists records in a table format, such as listing all employees assigned to a role, all reviews associated with an application, or all service requests found using a lookup. Grids contain one or more columns that show specific pieces of data about each record in the grid. Depending on the kind of information they show, grids may include additional features, such as linking to other records in Infor Public Sector.
General
| Property | Description |
|---|---|
| ID (advanced) | Identification code for the grid. You cannot change the IDs of the out-of-the-box controls. You can change the IDs that Infor Public Sector generates for agency-defined controls, but we recommend that you use the default values. |
Access
| Property | Description |
|---|---|
| ViewAccessId (advanced) | Access ID for the permission that users must be granted to view the grid. |
| AddAccessId (advanced) | Access ID for the permission that users must be granted to add records to the grid. |
| EditAccessId (advanced) | Access ID for the permission that users must be granted to edit records in the grid. |
| DeleteAccessId (advanced) | Access ID for the permission that users must be granted to delete records from the grid. |
| ViewAccessPath (advanced) | Path of the permission that users must be granted to
view the grid. The access path is an alternative to the access ID. For example, the access ID for the permission to create a work order is 8434, and the path is Work Management/Work Order/Create Work Order. |
| AddAccessPath (advanced) | Path of the permission that users must be granted to add records to the grid. |
| EditAccessPath (advanced) | Path of the permission that users must be granted to edit records in the grid. |
| DeleteAccessPath (advanced) | Path of the permission that users must be granted to delete records from the grid. |
Appearance
| Property | Description |
|---|---|
| Title | Title that is displayed at the top of the grid. |
| FrozenColumnNumber | Number of columns that should be frozen, starting with the first column of the grid. |
| StartMaximized (advanced) | Indicates whether the grid will be maximized when a user first opens the page it is displayed on. |
| ShowInPortal (advanced) | For detail pages, this property indicates whether the grid will be included when the detail is displayed in Infor Rhythm for Civics. |
Behavior
| Property | Description |
|---|---|
| CanAdd | Indicates whether new records can be added to the grid. If you select False, Infor Public Sector will not show an button above the grid. |
| CanEdit | Indicates whether records in the grid can be edited. If you select False, Infor Public Sector will not show the editing buttons above the grid. |
| CanDelete | Indicates whether records can be deleted from the grid. If you select False, Infor Public Sector will not show a button above the grid. |
| AutoCommit (advanced) | Indicates whether Infor Public Sector will automatically save the changes for the record you are editing when you begin to edit another record. This property only applies to inline edits. |
| CanBulkPaste (advanced) | Indicates whether records can be pasted into the grid in bulk. |
| CanExport (advanced) | Indicates whether users can export data from the grid to an external file. The file name is specified in the ExportFileName property. If you select False, Infor Public Sector will not show the button at the top of the grid. |
| CanPage (advanced) | Indicates whether Infor Public Sector will add additional pages to the grid if the number of records exceeds the maximum defined in your Infor Public Sector configuration file. If you select False, all records are displayed on a single page. |
| CanSort (advanced) | Indicates whether users can sort records in the grid by clicking on the column headings. |
| CanWrap (advanced) | Indicates whether Infor Public Sector will wrap text within the grid. If you select True, the grid will show long text entries on multiple lines so that the entire text can fit in a single column. |
| DisabledCanEdit (advanced) | Indicates whether users can make a disabled grid editable by clicking the Edit button at the top of an InfoViewer. A control is disabled if its Enabled property is set to False, or if the page is opened through an InfoViewer. |
| Enabled (advanced) | Indicates whether the grid is enabled for user interaction when the user first opens the page it is displayed on. If the grid is disabled, users cannot add, edit, or delete records in the grid. |
| FollowsAfter (advanced) | ID of the control that the grid follows in the page's tab order. |
| Hotkey (advanced) | Hot key used to set focus on the grid. |
| InlineEdit (advanced) | Indicates whether records in the grid are edited inline, or in a separate popup window or dialog box. Inline editing means the fields within the grid become editable when users add or updated records. |
| InlineEditFor (advanced) | Indicates whether inline editing is used in the grid only when you add new records, only when you update existing records, or both. |
| IsEditMode (advanced) | Indicates whether the grid is opened in edit mode by default. |
| MaxSelectCount (advanced) | Maximum number of records that can be selected in the grid. |
| MultiSelect (advanced) | Indicates whether users can select multiple records in the grid by clicking on them. If you select False, then the user can only select one record at a time. |
| NoDistinct (advanced) | Used to override the distinct portion of the query in a search context. |
| ShowFilter (advanced) | Indicates whether the grid's filter row is shown by default. |
| TitleContainerId (advanced) | ID of the container that should have its title updated. |
| ReadOnly (advanced) | Indicates whether the grid is read-only. |
Exporting
| Property | Description |
|---|---|
| ExportFileName (advanced) | Default file name to use when the user clicks the Export button on the grid. The file extension is the most important part of the file name, because Infor Public Sector uses the extension to determine which application to use for the file export. If you don’t specify a file name, Infor Public Sector will use the default from the Hansen8 configuration in the Configuration Editor. |
| ExportDelimiter (advanced) | Character used to delimit columns when the records in the grid are exported to a text file (most commonly a .csv file). If you don’t specify a character, Infor Public Sector will use the default from the Hansen8 configuration in the Configuration Editor. |
Layout
| Property | Description |
|---|---|
| FollowsBottomEdge | Indicates whether the grid abuts the bottom of the page or group area it is displayed in. |
| FollowsRightEdge | Indicates whether the grid abuts the right edge of the page or group area it is displayed in. |
| Height | Height of the grid in pixels. |
| Width | Width of the grid in pixels. |
| CanGrow (advanced) | Indicates whether the grid can grow larger than its specified height. If you select True, the grid will expand based on the number of records. If False, it will be limited to the height specified in the Height property. You can set this property to False to prevent grids from overlapping. |
| Left (advanced) | Position of the left edge of the grid, in pixels. |
| Top (advanced) | Position of the top of the grid, in pixels. |
Rules
| Property | Description |
|---|---|
| ValidationFormula | See Validation. |
| OnAfterRowAddRuleId (advanced) | Method that will be executed after a record is added to the
grid. See Rules. |
| OnAftertRowDeleteRuleId (advanced) | Method that will be executed after a record is deleted from the grid. |
| OnAfterRowChangeRuleId (advanced) | Method that will be executed after a record is changed in the grid. |
| OnRowAddRuleId (advanced) | Name of the method that will be executed when a user adds a row to the grid. |
| OnRowDeleteRuleId (advanced) | Name of the method that will be executed when a user deletes a row from the grid. |
| OnRowChangeRuleId (advanced) | Name of the method that will be executed when a user changes a row in the grid. |
| OnRightClickRuleId (advanced) | Name of the method that will be executed when a user right-clicks on a record in the grid. |
| OnRefreshRuleId (advanced) | Name of the method that will be executed when a user refreshes the grid. |
| OnDoubleClickRuleId (advanced) | Name of the method that will be executed when a user double-clicks on a record in the grid. |
| OnSelectRuleId (advanced) | Name of the method that will be executed when a user selects a row in the grid. |
Value
| Property | Description |
|---|---|
| Bind | Business object property the grid is bound to. The property you bind the grid to must be a collection. You can either bind an entire grid to a component collection (or enumeration) or bind columns in the grid with properties from a business object. Note that if you bind a grid to a collection you cannot bind its columns. If you bind a grid's column you cannot bind the grid to a collection. |
| Columns | Lists the columns that are displayed in the grid. When you click the button, Infor Public Sector shows the Column Collection dialog box, which you can use to add and edit columns. |
| ForeignKeyDestination (advanced) | Property of the collection the grid is bound to that serves as the foreign key for each record in the grid. The ForeignKeyDestination and ForeignKeySource properties work together to set the foreign keys for the records in a grid. The ForeignKeySource indicates which property of the parent record will be used for the foreign key, and the ForeignKeyDestination indicates which property of the grid collection will store this information. |
| ForeignKeySource (advanced) | Property of the business object the page is bound to that Infor Public Sector will use as the foreign key for each record in the grid. |
| KeyColumn (advanced) | Column whose value serves as the key that uniquely identifies each record in the grid. Note that the column you specify here must be display-only. To make a column display-only, set its ReadOnly property to True. |
| OrderIndexColumn (advanced) | Column used to sort records in the grid. You can select from a list of columns that are defined for the grid. This property will override the SortColumn property. |
| SendSelectedRow (advanced) | Indicates whether Infor Public Sector will return an entire selected row to the server rather than just the key. In most cases only the key is required, because the rest of the information is loaded based on the key. |
| SortAscending (advanced) | Indicates whether the records in the grid are sorted in ascending order when the grid is first loaded. The SortColumn property indicates which column Infor Public Sector will use for this sort. |
| SortColumn (advanced) | Column used to sort the records in the grid when a user first opens the page it is displayed on. You can select from a list of columns that are defined for the grid. If you specify a column for the OrderIndexColumn property, Infor Public Sector will automatically set this property to the same value. |