Search Panel

To filter data and highlight search results, type a filter criterion in the search panel.

Applying the Search Panel Filter Criterion

To apply a filter criterion typed in the search panel, press the ENTER key or click the Search button. Otherwise, a filter is automatically applied in 1.2 seconds.

Clearing the Search Panel Filter Criterion

To clear the search panel filter criterion, do one of the following.

• Press DELETE or BACKSPACE.
• Click the Clear button.

• Click the clear button, which is displayed within the editor when the editor is focused and is not empty.

  

Search syntax

In its simplest form, a search criterion consists of a single word. However, the search panel allows you to create composite criteria.

• Mask: criterion

  Example: carlos

  

  Example description: selects records that contain the "carlos" string in any search column.

• Mask: column:criterion

  Example: city:san

  

  You can search against a specific column by preceding a search string with the column's caption and a colon character. Instead of the complete caption, it is possible to use the initial characters of the caption. A search will be performed against the first column whose name starts with the specified substring. If you want to search against a column whose caption contains space characters, specify the column's display caption in quotation marks.

  If the search string contains multiple conditions separated by space characters, and at least one condition defines a search against a specific column, only records that match all of these conditions are shown (i.e., the conditions are combined by the AND logical operator).

  Example description: selects records that contain "san" in the column that starts with "city".

• Mask: criterion1 criterion2

  Example: carlos venezuela

  Option 1

  

  Option 2

  

  Based on conditions provided by your application vendor, the search panel can search words separated by space characters in one of the following ways.

  Option AND

  Only records that match all of the conditions are shown (i.e., the conditions are combined by the AND logical operator).

  Example description: selects records that contain both "carlos" AND "venezuela" strings in any search column.

  Option OR

  If there is no column specification, records that match at least one of these conditions are shown (i.e., the conditions are combined by the OR logical operator). If at least one condition defines a search against a specific column, only records that match all of these conditions are shown (i.e., the conditions are combined by the AND logical operator).

  Example description: selects records that contain either "carlos" OR "venezuela" strings in any search column.

• Mask: "criterion with spaces"

  Example: "maria anders"

  

  If you want to search for a string containing a space character, specify this string in quotation marks.

  Example description: selects records that contain "maria anders" in any search column.

• Mask: criterion1 -criterion2

  Example: maria -anders

  

  Precede a condition with "-" to exclude records that match this condition from the resulting set. There should be no space between the "-" sign and the condition.

  Example description: selects records that contain "maria", excluding records that contain "anders".

• Mask: criterion1 +criterion2

  Example: Spain +Madrid

  

  Precede a condition with "+" to display only records that match this condition. The "+" specifier allows you to implement the logical AND operator. There should be no space character between the "+" sign and the condition.

  Example description: selects records that contain both "Spain" AND "Madrid" in search columns.