Advanced Search Form enables you to create a search form based on an SQL query, unlike standard search forms which rely on a database table name. Advanced search form also identifies text fields and provides options to make text search even more intuitive. Users can provide a list of options or choose values from the drop-down. This form will represent fields which are selected and a respective control will get created based on the data type of the field. Data is displayed in a data grid with buttons which are having predefined actions like List, Report, Export, Clear, Close. [Give hyperlink to above mentions buttons]
[Link to Search Form Control Page]
To create Advanced Search Form
Click on the New form button.
Select Advanced Search Form from the drop-down.
Click on Create button.
Advanced Search Query window appears.
You can enter a query in the query window, or you can create a query using Query Builder.
To create a query using Query Builder, Click on Show Query Builder. (link to Query builder)
Create the query and copy – paste the generated query in Query Editor.
Click on OK.
Search Field Selection window appears.
Select the required fields.
Click on OK
If your query is having string data type fields, it will ask you to set the search control type for respective fields. Kushal will also add a special field called _Anywhere along with all the table fields. This field can be used in case you want your end users to search in all the fields of the table.
Types of String Search Controls
Note: For Dropdown and ListBox you need to set Query or a set of Pre-defined Items (collection) as inputs.
Click on Ok.
In Advance Search Form, Kushal takes care of filtering data on given conditions by using search controls and exporting data to excel.