When building an ETO Results report, the built-in Active Filter object in the Program Enrollment folder is useful for identifying participants who were active in a program in the date range entered in the prompts of the report. However, it is sometimes useful to create the equivalent filters yourself in order to change the behavior of the Active Filter. For instance, you may want to change the text in the prompts from "Begin Date" and "End Date" to something more specific to your needs, or you may want to use a fixed date range without using the prompts. Below you will find the instructions for a set of filters that will perform the same function as the built-in Active Filter but allow for more customization.
- In your report, click Edit Query to view the query you want to filter.
- Using the Program Start Date and Program End Date objects from the Program Enrollment folder, create the following filter structure in the Query Filters pane:
3. To create the nested Program End Date filters, create both filters individually, then click one and drag it on top of the other, and Results will create the nesting, which will default to an "And" relationship. Double-click the word "And" to change it to "Or" so that it matches the image above.
4. This set of filters functions exactly the same as the Active Filter object. Once this is in place, you may modify the filters, for instance to change the prompt text, select a constant for the date ranges, or use objects from the Universe Dimensions folder to select a relative date range.