DataGridRowLimit
|
Initial Build |
2006.01 or earlier |
|
Module |
Admin |
|
Current Setting Type |
Text Box |
Use this system option to specify the maximum number of rows, and therefore the number of pages, that display in child forms and xWeb:GetQuery. For more information, search GetQuery on the Wiki. When you run a query or search for individual, organization, etc. with a lot of results found, you cannot see all the results on the page. Instead you see only the top 300, 500 etc. This number is set by this DataGridRowLimit system option.
System options load an initial value from the web.config file, but this value is replaced by the DataGridRowLimit value stored in the database. The value used by the system always comes from the system option, unless there were no system option with the name DataGridRowLimit. Only in that case would the value come from the web.config file.
DataGridRowLimit is used by the following areas of netFORUM:
- the number of records that are returned by the xweb web service method GetQuery
- the total number of records displayed in a child form
DataGridRowLimit does not control the page size or total number of results returned by an iWeb list.
Important! Changing this setting could affect xWeb integrations that use the GetQuery web method. See XWeb:GetQuery#Record_Count_Limit on the Wiki for more.
The default for this option is 200.
Work Around and Troubleshooting
The work around to see all results is to export the query results into an Excel file.
If the system option doesn't seem to be working, make sure the EnableRankingForPagination system option is turned off.
Current Setting
The current setting for DataGridRowLimit is used as follows:
Values: This system option can be set to any maximum number of rows, and therefore the number of pages, to display in child forms and xWeb:GetQuery.
Note: The higher you set the values of this option, the slower your system will run. For the sake of performance, Abila recommends you set this option to around 300 or less.
Default Value: 200
Fields
This system option includes the following fields:
description: This field gives the description of the system option, including its use and default value.
Important! Do not modify the following fields after the system option is first created. Changing these fields after they have been used can invalidate existing data.
category: This field sets the category (usually the module) where the system option is used.
type : The type field determines the display type of the current setting field (check box, drop-down list, or text box).
values: The values field indicates the allowed values for the current setting field.
Availability
Each system option includes the following availability settings:
entity level option?: Select this check box to make this system option available on an entity level.
visible to external systems?: Select this check box to make this system option available in xWeb.