ListDisplayActualRecordCount

Initial Build	2006.01 or earlier
Module	Admin
Current Setting Type	Check Box

Modules > Admin > System Options > Find System Option

Use this system option to choose if NetForum does or does not display the count of all records returned in a list result after a search. The actual number of records that are returned is determined by the DataGridRowLimit system option. The default for this option is false (cleared check box).

Example:
With ListDisplayActualRecordCount set to true:

-- First, get count:
SELECT @count = count(*) FROM dbo.co_individual (nolock)
WHERE ind_last_name LIKE 'S%'
 
-- Next, run actual query, limited by DataRowGridLimit:
SELECT top {DataGridRowLimit} a, b, c FROM dbo.co_individual (nolock)
WHERE ind_last_name LIKE 'S%'

With ListDisplayActualRecordCount set to false, the system only needs to run the second SQL command:

SELECT top {DataGridRowLimit} a, b, c FROM dbo.co_individual (nolock)
WHERE ind_last_name LIKE 'S%'

 

Current Setting

The current setting for ListDisplayActualRecordCount is used as follows:

Values: This system option can be set to true (selected check box) or false (cleared check box).

• true—The user sees how many total records were returned.

Caution! Setting this system option to true has a performance cost if you are operating with a large database. Setting this system option to true causes queries to run slower, because it causes NetForum to run an additional query to check for the record count.

• false— The user does not know how many total records were returned; the list results will just show the limited number of records determined by the DataGridRowLimit system option.

Default Value: false

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.