Rule Filter On Report
  • Updated on 02 May 2016
  • 2 minutes to read
  • Print
  • Dark
    Light

Rule Filter On Report

  • Print
  • Dark
    Light

Overview

The Decisions tool lets you set up rules to filter the results of a report. In a business environment, filtering reports may be useful for refining large sets of data, for example groups of users.
Standard report filters (for example, the Created By Me filter) let you filter reports quickly and easily. However, if no standard filter exists for the function you have in mind you can create a custom rule filter. This example creates a custom rule filter.


Example

This example will demonstrate filtering an Accounts Report based on whether the current user is an administrator. Our Report will return all users if the current user is an administrator, or will show only the current user.
In the tool, under My Designs, open or create a new Designer Folder. At the bottom of the panel, click Create Report/Page > Create Report.
2018-03-26_1554362.png

We name the Report and clickOK.
2017-12-19_165208.png

In the Report Designer, under Data Sources, click Add then search for the Account Data Source. Select it and click Close.
2017-12-19_165352.png

Next, under Data Fields, click Add and search for Email AddressCreated on Date, and Created By fields and add them to the report.
2017-12-19_165637.png

Now we will create the custom Rule Filter. Under Filters click Add > Infrastructure > Rule Filter.
Click Rule Filter, then in the right panel under Filter Rule click [...]. Name your rule and click Create. In the Create New Rule pop-up, name your rule and click OK.
2017-12-20_090516.png

2017-12-20_090701.png

2017-12-20_090824.png

In the Start Rule pop-up, under Rule Data, click Show Editor. In the Data Definitions pop-up, create a string type input data called "created by" then click Close.
2017-12-20_090948.png

Now click Add Either/Or Group. In the workspace, on the Either branch, click Add > Add Condition.
Expand Flow Data and click InitiatingUserGroups, then click Next. Under List, click List Contains then click Next. Under Inputs > Value, enter the value "Administrators" then click Done > Close.
On the Or branch, click Add > Add Condition. The "created by" input data appears at the top of the menu; click itthen click Next.
Under Text Rules, click Equals then click Next. Under Inputs > Mapping Type click Select Value [From Flow]. Under Path, click Pick > Flow Data > Initiating Account > InitiatingUserEmail then click OK > Done > Close.
The Rule should look like this:
2017-12-20_092951-1.png

The following details to create the Rule are:
2017-12-20_091325.png

2017-12-20_091454.png

2017-12-20_091634.png

2017-12-20_091819.png

2017-12-20_091912.png

2017-12-20_092027.png

2017-12-20_092254.png

2017-12-20_092357.png

2017-12-20_092424.png

2017-12-20_092511.png

2017-12-20_092703.png

2017-12-20_092746.png

2017-12-20_092842.png

2017-12-20_092951.png

Save and close the Rule Designer.
Now, when you run the Accounts Report , this custom rule will filter results based on the administrator status of the user.

Was this article helpful?