Custom
Components that allow to create custom user-defined procedures and SQL queries in your workflows.
Description
This component executes an arbitrary CALL SQL statement.
Use $a and $b as placeholders for the input table names (you can use one, both, or none of them), and '$output' as placeholder for the output table name.
The procedure that you are calling is responsible of creating the output table in the path stored in the '$output' variable.
The following is a valid example of code to use in this component:
CALL MY_PROCEDURE($a, 10, $output);
Inputs
Source table [Table]Source table [Table]SQL CALL statement [String]
Outputs
Result table [Table]
Description
This component executes an arbitrary SELECT SQL statement.
A new table will be created from the result of the entered statement
Use $a and $b as placeholders for the input table names (you can use one, both, or none of them), and '$output' as placeholder for the output table name.
The following is a valid example of code to use in this component, which will generate a new table with an added area column (based on a column named 'geom'), with only the rows corresponding to the five largest geometries:
SELECT *, ST_AREA(geom) AS area FROM $a ORDER BY area LIMIT 5
Inputs
Source table [Table]Source table [Table]SQL SELECT statement [String]
Outputs
Result table [Table]
Last modified 5mo ago