Create Data Filter Policies

The Data Filter Policy is a SQL select statement written against an EmpowerID component or object type, such as a Person, that limits which object of that type someone with the policy can view. For example, EmpowerID includes a sample Data Filter for the Person object that only allows a person to view people in or below their location. This means that if Bob is located in London, for example, and has this Visibility Filter through some assignment, he can only see people in the London location (or locations below London).

Create a Data Filter Policy

  1. On the navbar, expand Admin > RBAC and click Visibility Restriction Policies.

  2. On the Find Visibility Page that appears, click the Actions tab and then click Create Data Visibility Filter.


    This opens the Filter Details form for the Data Visibility Filter.

  3. Click the Assign Policy To and select from the following Actor types to receive the policy. 

    • Person – Applies the policy to a specific person.

    • Group – Applies the policy to a specific group. Each person who is a member of the group receives the policy.

    • Business Role and Location – Applies the policy to a specific Business Role and Location. Each person who belongs to the Business Role and Location receives the policy.

    • Management Role – Applies the policy to a specific Management Role. Each person who is a member of the role receives the policy.

    • Management Role Definition – Applies the policy to a specific Management Role Definition. Each Management Role that is a child of the definition receives the policy.

    • Query-Based Collection (SetGroup) – Applies the policy to a specific Business Role and Location. Each person who is a member of the collection receives the policy.

  4. In the Assignee field that appears, do one of the following depending on the Actor type you selected.

    1. Type the name of the specific actor to whom you are assigning the policy and then click the tile for that actor to select it. For example, to assign the policy to a Query-Based Collection (SetGroup), type the name of the SetGroup in the field and click the tile for that SetGroup.

    2. If you selected Business Role and Location as the Actor type, click the Select a Role and Location link and in the Role and Location Selector that appears, search for and select a Business Role and Location and then click Select to close the selector.





  5. Type a name and description for the policy in the Name and Description fields.

  6. In the Priority field, enter a numeric value to set the priority to determine which policy takes precedence when users have more than one policy. The lower the number the higher the priority.

  7. Leave the value of the Mode field set as Default.

  8. Leave the Pre-Query field blank.

  9. In the Select Clause field, type the SQL statement for the filter that returns only those objects allowed by the filter.
    For example, to create a filter that only allows Contractors to see other Contractors, write a query similar to the following example (if the Title field is used in your environment).



    SELECT PersonID FROM dbo.Person (NOLOCK) WHERE Title = 'Contractor'


    At this point, the Filter Details form looks like the following image (with variations for the selected options). The image depicts a Data Filter policy that allows people in the Contractors Query-Based Collection to see only people in EmpowerID who have a Title attribute of Contractor.



  10. Click Save.

Test the Data Filter Policy

  1. Log out of the EmpowerID Web application and log back in as a user with the Data Filter policy.

  2. From the Home page of the Web application, search for any resource object restricted by the policy. For example, if you created a Data Filter policy that restricts which people can be seen, search for people. The search should return only objects allowed by the filter.