Advanced Search

The "Advanced Search" action can be used to implement multiple keyword search functionality. The action should be added to the Before Build Select event of a Grid, Gallery or Report form. It allows end users to filter the data by entering several keywords into a single search field, and selecting a condition for the search. The action assumes that the search form includes a listbox control allowing users to select advanced search condition, such as "Any Words", "All Words" or "Phrase". Such  listbox  is automatically created by any of the Builders that provide search functionality, such as Search Builder, Grid Builder,  Application Builder, etc.

The following search conditions can be made available for the action:

• Any Of Words – This condition should be used if users want to search for data that contains at least one of the keywords specified in the search field.
  For example, if a user enters "CodeCharge Studio" into the search control, the form will find records that contain any of the words "CodeCharge" or "Studio".
• All Words – This condition can be used if you want to search for data that contains all keywords specified in the search field.
  For example, if a user enters "CodeCharge Studio" into the search control, the form will find records that contain both words "CodeCharge" and "Studio".
• Exact Phrase – This condition should be used to search for data that contains an exact phrase specified in the search field.
  For example, if a user enters "CodeCharge Studio" into the search control, the form will find records that contain the entire phrase "CodeCharge Studio" as entered.

The following properties should be configured for the action:

Property	Description
Search Form	Name of the search form associated with the grid or report component.
Search Conditions control	Listbox control that specifies the desired search condition . The following list values should be provided by the Listbox: 1, 2 or 3. They can be specified in the listbox's data source as follows: 1;Any Words;2;All Words;3;Exact Phrase
Search Control	Name of the textbox control where users will enter the keywords.
Search Database Fields	Comma delimited list of database fields to be searched using the keywords.