Query Editor desktop

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

The Query Editor desktop is arranged into four panes:

• Model Models 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). pane.

  This shows all of the tables in the database for the selected Data Store. You can expand each table to see a full list of fields for that database table.

  This is only for reference and the tables cannot be edited here.

• Centre pane.

  This pane is not titled. This is where you enter the text for a new query, or change the text of an existing query.

• Queries pane.

  This lists all of the current queries for the selected model. All of the Sage 200 default database queries are listed here.

• Output and Results pane.

  The Output tab shows everything that has been loaded the first time you open the Query Editor. When you create a new query, it shows whether the build has been successful. Any query errors are highlighted.

  The Results tab (displayed when you click Preview) shows a preview of the query results.

  

Note: To view or amend existing Sage 200 Workspace Queries you will require a SDK licence. See Copy Workspace Queries from SDK.

Query Editor toolbar

• New: Create a new query.

• Save All: Save changes to all queries not just the current one.

• Delete: Delete a new query or delete a modification to an existing default query.

• Preview: Show the results of a query on the Results tab.

• Cut, Copy, Paste: Use these options to copy or move part of a query.

• Undo, Redo: Undo and redo changes to the current query only.

• Data Store: Displays a list of currently installed Models Models 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)..