In PHsPeed, there is a component that allows you to define your query freely. The disadvantage is that the end-user needs to know how to set up queries to achieve their desired result, which can be complicated. But great for BI specialists. In this case, you can set up a search block above the grid that shows the user the predefined search criteria. For less experienced users, this can be a better option. On beforehand, the predefined form search generates an SQL statement on the current grid. It does not apply for lookup fields.


To start, set the 'formsearch' option for the field that needs to be in the form-search to true. Then open the 'formsearchoptions' property editor.



In this form, you can set up the specs for the search field:


Datatype

Text, date, datetime

Generates the required edit field type in the search box

Search type

Single value, range

Generates one or two fields (range)

Search argument

<, <=, =, >-,>, <>, starts with, ends with, contains

Specifies the search type that is available in a drop-down for the end-user.

Between

Checkbox

If enabled, you can setup a valid range, i.e. for dates.

Start value



End value



Title


Title of the field that is used in the search box.



After generating the application, it will look something like this: