Predefined search
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: