Search Panel

Modified on Fri, 8 Mar, 2024 at 3:52 PM

Introduction

The Search Panel allows users to locate data by typing the filter criterion in the panel editor and highlighting the search results.

A search panel filter criterion is not automatically applied. The end user can click the Apply (Search) button or press the ENTER key to apply the entered criterion.

Search syntax

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

Search Criteria	Sample Image	Description
Mask: criterion Example: maria		Example description: selects records that contain the “maria” string in any search column.
Mask: column:criterion Example: contact:maria		End-users can search against a specific column by preceding a search string with the column’s caption plus a colon character. Instead of the complete caption, it is possible to use the caption’s initial characters to search against the first column whose name starts with the specified substring. 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, the tree list displays only records that match all of these conditions (the AND logical operator combines conditions). Example description: selects records that contain “maria” in the column that starts with “contact”.



Mask: criterion1 criterion2 Example: maria anders		If the search string contains multiple words separated by space characters, the words are considered as individual conditions. If there is no column specification, the tree list displays records that match at least one of these conditions (the conditions are combined by the OR logical operator). If at least one condition defines a search against a specific column, the tree list displays only records that match all of these conditions (conditions are combined by the AND logical operator). Example description: selects records that contain either “maria” OR “anders” 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: maria +sweden		Precede a condition with “+” to display only records that match this condition. The “+” specifier allows implementing the AND operator. There should be no space character between the “+” sign and the condition. Example description: selects records that contain both “maria” AND “sweden” in search columns.