Text Filter

Text Filter accepts free text inputs from users.

Options

• Default Value: Optional. The filter defaults to this value if no filter value is set by the user.
• Help text: Optional. Description of the filter.

How to use

It is recommended that table's text field and the text filter are both wrapped in LOWER() function

[[ LOWER(U.realname) LIKE CONCAT('%', LOWER({{name}}), '%') ]]
AND [[ LOWER(U.email) LIKE CONCAT('%', LOWER({{email}}), '%') ]

To find out more about how to include the text filter in your SQL query, please see Query Syntax References.