Although the 'Resource OBS' is only used in the first Filter Group, that criteria is also applied to the other Filter Groups.
Steps to Reproduce:
Note: Cheryl Amos & Stacey Sweeney do not belong to the same Resource Department OBS ; Stacey belongs to IT/Development
- Create the following Filter Group Conditions
- Match Filter Group = Any
- Group 1 - Match=All: Employment Type = Employee AND Status = Open; Submitted AND Time Period Start Date > Nov 13, 2022
- Group 2 - Match=All: Time Period Start Date > Nov 1, 2022 AND Resource Name = amos, cheryl
- Correct Results: Cheryl Amos shows the extra timesheet for Nov 1, all other resources show timesheets after Nov 13
- In Group 1 add the 'Resource OBS' = Corporate Department OBS:/IT/Development
- Incorrect Results: Only Stacey Sweeney is returned as she matches the Resource OBS unit in Filter Group 1; no rows are returned for Filter Group 2 because the 'Resource OBS' criteria is being applied to Filter Group 2 or Filter Group 2 is being ignored
Expected Results: Each Filter Group should be evaluated as defined in context of the overall Match Filter Condition All/Any.
Actual Results: The 'Resource OBS' condition is being applied to the other Filter Groups causing incorrect results.
Workaround: Don't use the 'Resource OBS' field in the filtering with Filter Groups defined.