RidgeStar
About
Locations
Manual
Preface
Introduction
Versions
Concepts
Construction
Usage
Operations
Questions
Features
Settings
Album
Alerts
Assignments
AssignmentMeter
Assignor
Audit
Availability
BulkLoad
BulkMail
Calendar
Chapter
Chart
Criteria
Evaluation
Exams
GeoCode
GoogleAPI
iCalendar
IPMapping
JavaNames
KeyTranslation
Lists
Locations
Mail
MinorAuth...
Misconducts
NACHA
News
Notification
Notify
NWS
PageHeader
Paperwork
Password
PhotoUse
Questions
Request
Reset
RestClients
RestServer
RMA.WSYSA
Rules
Save
ScheduleMeter
SoapClients
SoapServer
SRC
Tickets
Timeout
TouchLine
Translate
UserName
Internals
Appendices
Reference
Service
Logon
RidgeStar

Manual: Settings-Criteria

Logonfindtranslate
Get Started |Calendar |Locations

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

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