Dynamic SQL query support allows you to create change SQL queries on the fly rather than (e.g., defining additional conditions in the SQL) in the runtime without changing the data service configuration. For this to work, you must specify required SQL query statements (e.g., with WHERE clause) as a QUERY_STRING data type. In the runtime, these statements are These statements will be directed to the final SQL query in the runtime.
| Info |
|---|
Note: Dynamic query support can lead to SQL injection attacks. Therefore, we recommend to put this feature with validated values for the validate the values set to |
The QUERY_STRING data type is available as an SQL type when creating Input Mappings for queries. For example,
...