Modify an output in SQL
This page provides an overview on how to modify an output using SQL in Upsolver.
Last updated
Was this helpful?
This page provides an overview on how to modify an output using SQL in Upsolver.
Last updated
Was this helpful?
When creating or editing an output, toggle from UI to SQL in order to directly modify the output through SQL.
To change the SQL page view, click the required button to view more or fewer panes.
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.
When you click inside the SQL code, your current cursor position is updated.
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.
You can also increase or decrease the font size to make it easier to edit and hover over the question mark iconto view the available keyboard shortcuts.
Click and drag the grip iconto view more or less of the Preview pane.
Click the chart iconto view the events graph.
Click the filter iconto add or remove filters from your preview.
Note: Filters can be directly typed into the SQL code and be previewed.
See:
Alternatively, they can be added through the UI. See:
