Open topic with navigation

> General / How to use workspaces / Creating new datasources - on premise only / Editing an existing query - on premise only

/  More

Editing an existing query - on premise only

About editing an existing query

You can make changes to all existing queries, including the defaults. Any changes you make to the default queries are saved separately. You can delete these changes but you cannot delete the default query.

To edit an existing query

Open: Workspace Designer > Content Part Designer > Query Editor.

1. Open the Query Editor.
   1. Select Tools > Workspace Designer.
   2. From the Workspace Designer toolbar select Content Part Designer.
   3. From the Content Part Designer toolbar select Query Editor.
2. From the Queries pane (on the right), select the query.
3. In the centre pane, edit the LINQ query text. To see a preview of the changes, click Preview. The preview appears on the Results tab on the bottom pane.

4. To save your changes, click Save All. This saves changes to all queries not just the one displayed.

   The query is now saved but is not used in any workspaces at this point. This allows you to review your queries first.

   Those queries that are saved but not yet used in workspaces are stored in the folder ...Sage\IM Content\Modifications\Queries\Pending.

5. To add the amended query to your workspace, in the General Settings select True from the InProduction drop-down list.