Tables Query
This Tool App allows you to access your Tables' data with SQL-like queries with ease.
It allows you to SELECT your data and use SQL functions like AVG(), MAX(), CONCAT_WS(), etc., and also use JOINS between your tables, use GROUP BY, HAVING, etc.
SQL Editor​
The SQL editor will help you with the task of building your query as it will try to autocomplete SQL keywords and functions, and your Tables' name and columns.
For the query to work, the table name has to be enclosed between square brackets like [my_table_name].
You also have on the right, a list of the SQL Commands that you can add to the editor in one click.
The number of results that this App outputs while in the Designer are limited to 200. When you run this App in your own environment, this limit is not applied.
Response parameters​
The output of this App provides five variables:
| Variable | Description |
|---|---|
| result | the current loop index |
| total | returns the number of results |
| query | returns the query that was done, with all the @ variables replaced, if any |
| message | in case of an error, returns an explanation of the error |
| error | in case of an error, returns "true" |