Baadal Help - Document

App Development Software Baadal | Single Entry Form

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, and Export


 Advanced Search Form Design

To create Advanced Search Form

Click on the New form button.


 Form Design in Web Applications

Select Advanced Search Form from the drop-down.


 Form Design in Web Applications

Click on Create button.


 Create Advance Search Form in Web Applications

Advanced Search Query window appears.


 Create Advance Search Form in Web Applications

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)


 Query Builder Interface

Create the query and copy - paste the generated query in Query Editor.


 Query Builder Tool

Click on OK.

Search Field Selection window appears.


 Query Builder Tool

Select the required fields.


 Query Builder Tool

Click On Right Arrow.


 Query Builder Tool

Click on OK


 Design Advanced Search Form

If your query is having string data type fields, it will ask you to set the search control type for respective fields. Baadal 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

  1. Default >> A Default search control will be added where you can use conditions Equal or Like to search data.
  2. DropDown >> A Dropdown will be added as a Search control. By using drop-down values you can search the data with an “ Equal to” condition.
  3. ListBox >> A ListBox will be added as a Search Control. By selecting multiple values in the list box items you can search the data by specifying multiple filters.

Note: For Dropdown, List Box you need to set Query or a set of Pre-defined Items (collection) as inputs.


 Design Advanced Search Form

Click on Ok.

In Advance Search Form, Baadal takes care of filtering data on given conditions by using search controls and exporting data to excel.

There are 3 predefined Control Types mentioned in the dropdown.

a) Dropdown


 Design Advanced Search Form

Click on OK Button.


 Design Advanced Search Form

Advanced Search Form:


 Design Advanced Search Form

b) Checked List Items


 Design Advanced Search Form

Click on OK Button.


 Design Advanced Search Form

Advanced Search Form:


 Design Advanced Search Form

The properties of their control type can be changed by clicking on the Properties tab.

Reference: To know more regarding the properties of list item,and Dropdown,refer Document No. 7.7, 7.13 and 7.14.


 Advanced Search Form Properties