Please enable JavaScript to view this site.

R:BASE 11 Help

Navigation: How To (Forms, Reports, and more) > Forms > Form Designer > Form Controls > Database Controls > DB Tree Grid

Filter Options

Scroll Prev Top Next More

 

Apply Row Filter

Specifies when the row filter is applied; On Cell Exit, Immediately, or Delayed

Row Filter Delay

Specifies the delay (in milliseconds) before a search is initiated after an end-user has stopped typing text in the row filter

Row Filter Caption

Specifies the display caption for the row filter

Find Panel Delay

Specifies the delay (in milliseconds) before a search is initiated after an end-user has stopped typing text in the Find box

Find Panel Position

Specifies the Find Panel's display position; Top or Bottom

Extended Syntax

Specifies if end-users can include multiple conditions in search strings using the extended syntax

Highlight Match

Specifies if search strings are highlighted in located records

Use Delayed Find

Switches between delayed automatic and manual search modes. When checked delayed automatic mode is enabled. In this mode, a search is initiated automatically after the number of "Find Panel Delay" milliseconds have elapsed since an end-user has stopped typing text in the Find box. When unchecked, end-users need to click either the Find button or press the Enter key within the Find box to apply its search string to grid records.

 

Extended Search Syntax

The Extended Syntax setting allows end-users to apply multiple conditions for search strings. Words separated by the space character are treated as individual conditions combined by the OR logical operator. The grid shows records that match at least one of these conditions. To search for a string containing a space character, this string must be enclosed in quotation marks.

 

The following specifiers and wildcards allow users to narrow search results:

 

The "+" specifier. Preceding a condition with this specifier causes the grid to display only records that match this condition. The "+" specifier implements the logical AND operator. There should be no space character between the "+" sign and the condition.

 

The "–" specifier. Preceding a condition with "–" excludes records that match this condition from search results. There should be no space between the "–" sign and the condition.

 

The percent ("%") wildcard. This wildcard substitutes any number of characters in a condition.

 

The underscore ("_") wildcard. This wildcard represents any single character in a condition.

 

For instance, applying the 'mercedes dodge +systems +ame –roadster –sport' search string makes the grid display only records that include ‘mercedes’ or ‘dodge’ with ‘systems’ and ‘ame’ in any cell, and do not include either 'roadster' or 'sport'.

 

The order of conditions is irrelevant for search results – it only affects how search strings are highlighted within each record cell. So the 'mercedes +systems –roadster –sport +ame dodge' search string is equivalent to the one mentioned above.

 

DBTreeGrid_FilterOptions