Report Editor: Combining filters

When setting filters in a report, the filter combination by default is set to AND. This means that Filter A AND Filter B will have to be true for the filters to work.

Example: Filter A is set to Definition contains "Application Function". Filter B is set to Title starts with "Adobe". The result of this will be that only objects of the type "Application Function" where the Title starts with "Adobe" are returned.

Let's say we want to get objects that are of type "Application Function" or where the Title starts with "Adobe":

1. Create filter A using a filter on Definition and set it to equals. Use "Application Function" as the value.
2. Create filter B using a filter on Title and set it to starts with. Use "Adobe" as the value.
3. Apply the filter.
4. Most likely there are no results. This is because the filters are combined using an AND expression and usually there are no Application Functions whose title starts with "Adobe". To make this work, we need to add another step.
5. Go to Custom Filter Expression in the lower-right corner. Click to expand it and enter "A or B" in the text box.
6. Apply the filter. You will now see Application Functions as well as all objects whose title starts with "Adobe" (if any).
7. Your filters should look something like this:

You can combine multiple filters, and also use negations (like the NOT operator) to further specify the filter order and combinations.

Example: Filter A is set to Definition contains "Application Component". Filter B is set to Title starts with "Adobe". The result of this will be that only objects of the type "Application Component" where the Title starts with "Adobe" are returned. Set the custom filter expression to "A and (not B)". The result will be that you get all "Application Component" objects except those that start with "Adobe":