Editing Queries

Use the following procedure to edit private or public queries:

1. In the Query Wizard page, select the required query and click Edit on the action bar.

   The Edit Wizard window opens.

2. Perform the following as required:

3. Update the Name and Description ,see Data Translation. This will only be allowed for non SYS queries.

4. To display limited data in the query results, click the Hide detail data on execution check box.

5. To make the query public, click the Public Query check box. Once a query is made public, it can’t be made private again.

   SYS queries (system defined queries) will be allowed to edit/update only for Aptean Administrator based on the security.

• To update the changes in the Results Display tab see Results Display.

• To update the changes in the Criteria tab, see Criteria.

• Optionally, in the Public Access tab you can select the Access Groups for which the query will be available.

  This tab is enabled, only if you have selected thePublic Query check box for the query.

Perform any of the following steps to save or cancel the query after editing:

• To save the query, click Save.
• To save and preview the query, click Save &Preview.
• To cancel the query, click Cancel.