---
title: "Manage query & folder templates"
id: "manage-query-folder-templates"
project: "EHR User Guide"
url: "https://help.cloud5.com.au/articles/ehr-user-guide/manage-query-folder-templates"
updated: 2026-10-19T00:54:08Z
---

# Manage query & folder templates

Security templates allow you to control who can access Query Manager's public queries and Catalogue folders. You manage templates, their authorised users, and their objects (queries and folders) from Query Management Administration.

## Assign a user to a template![](/resources/Storage/ehr-user-guide/ehr-user-guide/icons/desktop%20icon.png)

To assign a user to a template:

1. Go to **Administration** &gt; **System Security** &gt; **Query Manager Administration**.
2. EmpowerHR displays the **Query Manager - Administrator** screen.
3. Click **Template Users**.
4. At the **Template Users** tab, select a template from the **Template Name** dropdown list.
5. EmpowerHR displays the **Authorised Users** and **Unauthorised Users** lists.
6. Click **Open**.
7. To:
    1. assign a user to the template, select the user in the **Unauthorised Users** list, and click **Move Left**. The user is added to the **Authorised Users** list.
    2. remove an assigned user from the template, select the user in the **Authorised Users** list, and click **Move Right**. The user is moved to the **Unauthorised Users** list.

1. Click **Save**.

## Change access to an object![](/resources/Storage/ehr-user-guide/ehr-user-guide/icons/desktop%20icon.png) 

To change access to an object (query or folder):

1. Go to **Administration** &gt; **System Security** &gt; **Query Manager Administration**.
2. EmpowerHR displays the **Query Manager - Administrator** screen.
3. At the **Access Profile** tab, select a template from the **Template Name** dropdown list.
4. EmpowerHR displays a list of **Authorised Users** and the objects (queries and folders) for which the template provides access.
5. Click **Open**.
6. Review the objects listed in the **Query/Folder Access** panel and use the following table to understand what the check marks mean:

| **This check mark...** | **means...** |
| --- | --- |
| green | access is granted |
| clear | access is undefined (that is, access is neither granted nor denied) |
| orange | access is mixed (access is granted to some descendant objects, while denied for others) |

1. To change access to granted or denied, double-click the object. When you grant access to a query, EmpowerHR automatically grants access to any sub-queries, drill-down queries, and union queries associated with the query.

| ![Information](/resources/Storage/ehr-user-guide/ehr-user-guide/Info.png) | If you change access for a parent folder, the change applies to all its descendants. |
| --- | --- |

1. Click **Save**.

## Assign templates to a user![](/resources/Storage/ehr-user-guide/ehr-user-guide/icons/desktop%20icon.png) 

You can assign multiple templates to a user.

To assign a template to a user:

1. Go to **Administration** &gt; **System Security** &gt; **Query Manager Administration**.
2. EmpowerHR displays the **Query Manager - Administrator** screen.
3. Click **User Templates**.
4. At the **User Templates**tab, select a user from the **User Name** dropdown list.
5. EmpowerHR displays the **Authorised Templates**and **Unauthorised Templates**lists.
6. Click **Open**.
7. To:
    1. assign a template to the user, select the template in the **Unauthorised Templates**list, and click **Move Left**. The template is added to the **Authorised Templates**list.
    2. remove an assigned template from the user, select the template in the **Authorised Templates**list, and click **Move Right**. The template is moved to the **Unauthorised Templates**list.

1. Click **Save**.

## Define folders![](/resources/Storage/ehr-user-guide/ehr-user-guide/icons/desktop%20icon.png) 

You can define the folders/sub-folders where authorised Query Manager users can store their saved queries.

To define a folder/sub-folder:

1. Go to **Administration** &gt; **System Security** &gt; **Query Manager Administration**.
2. EmpowerHR displays the **Query Manager - Administrator** screen.
3. Click **Folder Control**.
4. At the **Folder Control** tab, select a folder from the **Classification Folder** dropdown list.
5. EmpowerHR displays the **Approved Sub-Classification Folders**and **Available Sub-Classification Folders**lists.
6. Click **Open**.
7. To:
    1. add a sub-folder, select the item in the **Available Sub-Classification Folders**list, and click **Move Left**. The item is added to the **Approved Sub-Classification Folders**list.
    2. remove an assigned sub-folder, select the item in the **Approved Sub-Classification Folders**list, and click **Move Right**. The item is moved to the **Available Sub-Classification Folders**list.

| ![Information](/resources/Storage/ehr-user-guide/ehr-user-guide/Info.png) | Query Manager prevents you from removing an assigned sub-folder that already exists in Saved Queries, |
| --- | --- |

1. Click **Save**.

## Define element filters![](/resources/Storage/ehr-user-guide/ehr-user-guide/icons/desktop%20icon.png) 

You can define the pay elements and leave elements you want to use as filters in Query Manager.

Registered element filters are available from the **Filters** tab of Query Manager.

To define and register element filters:

1. Go to **Administration** &gt; **System Security** &gt; **Query Manager Administration**.
2. EmpowerHR displays the **Query Manager - Administrator** screen.
3. Select a template.
4. Click **Filter Control**.
5. At the **Filter Control** tab, select an element type from the **Element Type** dropdown list.
6. EmpowerHR displays the **Registered Element Filters**and **Available Elements**lists.

| ![Information](/resources/Storage/ehr-user-guide/ehr-user-guide/Info.png) | Users can still modify or delete any payment code associated with a pay element. Query Manager lists all element definitions, showing deleted elements with coloured highlighting. |
| --- | --- |

1. Click **Open**.
2. To:
    1. add an element, select the element in the **Available Elements**list, and click **Move Left**. The element is added to the **Registered Element Filters**list.
    2. remove an element, select the element in the **Registered Element Filters**list, and click **Move Right**.

1. If you try to remove a registered element:
    1. not currently used in any queries, after you click **Move Right**, the element is moved to the **Available Elements**list.
    2. currently used in a query, EmpowerHR displays a warning with a list of queries. Check the list and modify or delete each of the existing queries and then remove the element.

| ![Information](/resources/Storage/ehr-user-guide/ehr-user-guide/Info.png) | Query Manager prevents you from removing a registered pay element that is currently used in a query. EmpowerHR displays a warning and lists each query, the owner, date last used, and the saved queries folder/subfolder. You must modify or delete the existing queries before you can remove the element. |
| --- | --- |

1. Click **Save**. ​

## Create a new template![](/resources/Storage/ehr-user-guide/ehr-user-guide/icons/desktop%20icon.png) 

To create a new template:

1. Go to **Administration** &gt; **System Security** &gt; **Query Manager Administration**.
2. EmpowerHR displays the **Query Manager - Administrator** screen.
3. Click **New**.
4. At **Define Security Template**, enter a name for the new template, and then press **Tab**.
5. Click **Save**.
6. Follow the preceding instructions to assign users, determine access, etc.

| Next topic<br><br>[Register & manage self service forms](/articles/ehr-user-guide/register-manage-self-service-forms) |
| --- |

© 2023 Fusion5. All rights reserved.