Modify an output in SQL
This page provides an overview on how to modify an output using SQL in Upsolver.
When creating or editing an output, toggle from UI to SQL in order to directly modify the output through SQL.
Edit the output in SQL
Toggling to the SQL view will show you your current output as a SQL query. You can edit this directly to change the output as desired.
See: Transform with SQL for more information on syntax.
When you click inside the SQL code, your current cursor position is updated.
Preview
The Preview pane allows you to create various “snapshots” of the output SQL and enables you to try different SQL queries until you find the one that you want.
Note: Filters can be directly typed into the SQL code and be previewed.
See: Filter using WHERE
Alternatively, they can be added through the UI. See: Add filters
Last updated