JQL Query for EPICs and Subtasks

Job ID: 38583741

Budget: $100 – $250 CAD

I need a JQL query that will return all EPICs, their issues, and subtasks that are currently "IN PROGRESS".

Key Requirements:
- The JQL needs to be compatible with Jira Data Center.
- It should include all relevant issue types: EPICs, Tasks, Sub-tasks (also "User Stories", and "Bugs" at the "Task" level).
- You should be able to deal with our standard fields and statuses, as I am not sure if we have custom ones.

Ideal Skills:
- Proficiency in JQL, particularly for Jira Data Center.
- Experience with EPICs and their associated issue types.
- Ability to work with standard Jira fields and statuses.