Open topic with navigation

> General / How to use workspaces / Creating new datasources - on premise only / Creating a new query - on premise only

/  More

Creating a new query - on premise only

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. Select the ModelModels are data schemas that describe how the information held in a particular database can be accessed and displayed within Sage 200. Each model is contained in its own dynamic link library (dll). from the Data Store drop-down list.

3. From the Query Editor toolbar, select New.

   A New Workspace Query is added to the Queries pane (on the right).

4. To change the name of the new query, select New Workspace Query in the query pane.
5. In the General Settings section, enter the Name of the query.
6. Add the LINQLanguage Integrated Query. Used to extract information from a database, which can then be used in workspaces. query text in the blank centre pane. To see a preview of the query, click Preview on the toolbar. The preview appears on the Results tab in the bottom pane.

7. To save the new query 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.

8. To add the new query to your workspaces, in the General Settings, select True from the InProduction drop-down list.