Search fields IQL
IQL is IS Tools syntax for advanced filters, charts and logic.
How does it work?
A search field is a form field not connected to the data model, and hence not showing any information. The content which the user supplies can be used as a search parameter in one or several panels in the form.Example
Below is a form with a text field at the top. The component is one of the blue buttons in the form designer (text in this example).-
The component is configured with a parameter name as data source. In this example
@searchstr
. -
When configured, it can be used in filter expressions for other panels. Below, the IQL filter expression for the table is shown.
@searchstr is null /* return result without filter */ or ( RecordName contains @searchstr /* encapsulates expression with * */ or Description startswith @searchstr /* starts with operator */ )
-
The filter parameter is applied on user input.