Combine Task/Request in one report
We'd like a query to capture both Tasks (request, change, project) and Requests that are over not closed and are older than 6 months - sorted by Technician:
Technician
Request/Task ID
Request Status
Created Date
Created By
Subject
Project Title
We'd like to be able to modify the query to filter by Technician