...
| Code Block | ||
|---|---|---|
| ||
CREATE VIEW planning.current_apps AS SELECT * FROM planning.all_apps WHERE decision_date IS NULL; |
| Note |
|---|
In order to open a view in QGIS you will need a primary key column, ideally as the first column in the view which QGIS will select by default. |
- Run the task. Click OK
- Now we need to grant privileges to this view.
- Create a Workflow Stored Procedure Task and give it a Name e.g. Grant Privileges to Planning View
- Select the Spatial Data Warehouse Connection, Click on the Astun radio button and select the Function at_sdw_update_schema_ownership_and_privileges.
- Select the schemaname parameter and enter the name of the schema where you created the view into the Edit parameter 'schemaname' box e.g.
...