SQL Statement - Reading Input Field

[Former Member]

I have a simple SQL statement which takes an input value and searches for it in the database. I am wondering what is the syntax in Visual Composer to pass the input value using a form to the SQL statement. In other words how can I read the value of the search field of the input form in the SQL Query.

Example: select * from Table WHERE Description LIKE <b><Search Term></b>

I would like to know the syntax to read the Search term from the input form.

Any help will be greatly appreciated.

[Former Member · Accepted solution]

In the current version of VC input fields are available only for dataservices based on relational templates in BI Query Wizard(Not created in the SQL editor).

You can select "All data" template for a single table or "Freeform" if you would like to do something more complex and provide a filter via input field.

Best regards,

Natalia