How can I create a query from one or several lists?

• Select the menu " --> Go To Module --> Query" on the top right-hand side of the page.
• In the "Query Schema Browser" select the list to be included in the query.
• Click the "Create New Query" button.

• Introduce a name for the new query and click the button "Create And Edit Source".
• Edit the SQL statements.
  SQL results can be viewed by clicking the "Execute Query" button.
• Save the query using the "Save & Finish" or "Save" button.

How can I edit an existing query?

• Select the menu " --> Go To Module --> Query" on the top right-hand side of the page.
• In the "Query Schema Browser" select the user-defined query to edit.
• Click the "EDIT SOURCE" link.

• Edit the SQL statements.
  SQL results can be viewed by clicking the "Execute Query" button.
• Save the query using the "Save & Finish" or "Save" button.

How can I create a view from a query or "Query Report"?

• Select the menu " --> Manage Views" on the top right-hand side of the page.
• From the "Add Report" menu, select "Query Report".

• Introduce a name for the new view.
• Select schema, query and default view from the dropdown boxes.

• Confirm clicking the button "Save".
• The new view will appear in the list of views, which can be accessed, for example, from the menu " --> Manage Views" on the top right-hand side of the page.

How can I delete a "Query Report"?

• Select the menu " --> Manage Views" on the top right-hand side of the page.
• Select the view or views to delete and click the button "Delete Selected".
• Confirm by clicking the "OK" button on the "Delete" window.