GRID node

The GRID node of the Hansen8 configuration stores default settings for the grids in Infor Public Sector. The GRID node can have these attributes:

Attribute Description
Export Delimiter Character used to delimit columns when the records in a grid are exported to a text file (most commonly a .csv file). The best choice is a character that is used infrequently in the text in the grid. The default is a comma, because .csv files are natively supported by Excel and are formatted properly when imported. Note that if you change this character, you may also need to change the file extension in the Export File Name attribute.
Export File Name Default file name to use when the user clicks the Export button on a 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. The default value is GridData.csv, indicating that Infor Public Sector will create a .csv file in Excel.
Grid Page Count Number of pages of records Infor Public Sector will retrieve from the database at one time. This count times the Grid Page Size attribute equals the number of records to retrieve. For example, if the Grid Page Size attribute is set to 10 and the Grid Page Count attribute is set to 5, then Infor Public Sector will retrieve 50 records.

Note that this attribute limits the number of records that will be retrieved at one time, not the total number of records retrieved. For example, if the Grid Page Size attribute is 10 and the Grid Page Count attribute is 5, Infor Public Sector will retrieve 50 records when a grid is first loaded. If the user clicks Next on the fifth page, Infor Public Sector will attempt to retrieve the next 50 records.

This property is tightly coupled with the Record Load Limit attribute in the MAXRECORDS node. The Record Load Limit attribute should be equal to or greater than the Grid Page Size times the Grid Page Count.

Grid Page Size Number of records to show on each page of a grid. This number can be overridden for specific grids. Note also that some grids don’t support paging, in which case all records are show on a single page.
Max Export Records Maximum number of records to export when the user clicks the Export button on a grid.
Max Sub Grid Size Maximum number of records to show in sub grids.
Max UnPaged Records Maximum number of records to show on one page until paging is forced. This only applies if paging is disabled on a grid. If the number is set to 100, and we retrieve 105 records from the grid, two pages will be shown (one with 100 and the other with 5). This number should either match the Record Load Limit and the Grid Page Size times the Grid Page Count, or it should be less than the Record Load Limit.
maxSubGrid Maximum number of records to show in subgrids.