Apply the reporting rules to a fresh mix of candidate, absence, position and worker requests. Don't reuse a worker filter on a position field just because the labels look similar. First confirm the primary business object, then match the field and operator to that object.
Some tasks produce no rows. An empty result can be correct when the criteria are intentionally impossible; it doesn't justify relaxing the filter. Other tasks keep workers with blank managers or exclude candidate stages that are no longer part of an active pipeline. Read the requested AND or OR logic, and use runtime prompts only when the request calls for a reusable response.