Manual: Settings-Criteria

Setting=Criteria permits the Administrator to configure certain operational aspects of the handling of criteria elements throughout the site, as follows:

DefaultRows

Specifies the default number of Rows set into the Show rows counter throughout the Site. Prior to Version 5.0.9, this was Setting=DefaultRows.

Default is 10

Fragments

Specifies the mechanism used to parse and process any Criteria element Fragment string. Use "LIKE" to support the standard MariaDB syntax (including the percent % and underscore _ characters) or "REGEXP" to accept/honor MariaDBs support for Regular Expressions. If you specify Fragments=>REGEXP, the system will detect the presence of a _ or % and swap to LIKE syntax(for upward compatibility reasons).

Default is REGEXP

Keyword

Specifies a character that will precede any reserved Keyword within a Fragment field to indicate the use of specialized MariaDB constructs. Available specialized/reserved arguments are described at Manual: Features-Fragments. Default is to accept isnull, isblank, or isempty as reserved keywords in the Fragment input field without any leading character.

When the Keyword is set to a character (e.g. an equal sign, as in Keyword=>=), the keywords are case insensitive and may include embedded blanks. Thus, =isnull, =IS NULL and =Is Null are all equivalent requests to test a data field for the null value.

MultipleRows

Specifies the number of rows in a multiple select pulldown that should be displayed (when a Multiple Select pulldown is available in a Criteria form).

Detault is 5

PulldownLimit

Specifies the maximum number of entries that will be retrieved from a Database table for display as an entry in a traditional HTML pulldown.

Detault is 5000

PulldownBlankSuppress

Indicates whether (or not) embedded blanks in Pulldown Values should be suppressed when determining an accurate Match and setting current value

Detault is 1

Pulldowns

Specifies how to process a pulldown value that is blank. Pulldowns=>NullIsBlank causes the SQL construction to test the value of a data field for EITHER null or empty.

Default (Pulldowns unspecified) is to check for empty only.

ShowRows

Specifies the choices offered to the Visitor in the various criteria forms as the number of output rows that will be displayed when the Action Show is performed. The individual values in the Setting are separated by a plus sign and should be numeric (except for the special case "All").

Default is All+10+25+50+100+250