Advanced Filter Options

Join query parameters

1. Click the 1st query parameter from the filter box.
2. Click (. Note the ( appears in the filter box.
3. Click the 2nd query parameter from the filter box.
4. Click ). Note the ) appears in the filter box.

   Remove query joins

5. Click the 1st query parameter from the filter box.
6. Click -(. Note the ( disappears.
7. Click the 2nd query parameter from the filter box.
8. Click -). Note the ) disappears.

For example, you may want to filter to locate all organization units with the Close the Books process where the risk control matrix has not been started. This would display in the filter box as shown below.