TQL Exposes a number of fields, both phsyical and calculated that you can then search against and report off.
- Accumulated Actual Duration
- Actual Duration
- Affected Version
- Agile Runs Count
- All Packages
- All Parents
- Assigned To
- Assignee
- Assignment
- Assignment Id
- Assignments Count
- Attachment Count
- Automated Tests Count
- Blocked
- Change Comment
- Comment
- Component
- Created At
- Created By
- Description
- Destination
- Difficulty
- Difficulty Level
- Directly Related To
- Editor
- Editors
- Entity Type
- Errors
- Estimated Duration
- Estimated Less Actual Duration
- Failed
- Finished At
- Fixed Version
- Has Agile Runs
- Has Assignments
- Has Attachments
- Has Automated Tests
- Has Coverage
- Has Incidents
- Has Requirements
- Has Scripts
- Id
- Imported At
- Incident Count
- In Progress
- Iterations
- Key
- Last Comment
- Last Synchronized At
- Last Updated At
- Last Updated By
- Name
- Notes
- Not Run
- Number
- Objective
- Order Number
- Organisation
- Package
- Parent
- Parent And This Package
- Parent Package
- Passed
- Post Condition
- Pre Condition
- Priority
- Project
- Provides Coverage
- Query
- Raised By
- Related To
- Related To All Packages
- Related To All Parents
- Related To Entity Type
- Related To Id
- Related To Organisation
- Related To Package
- Related To Parent
- Related To Priority
- Related To Project
- Related To Status
- Related To Type
- Relationship
- Relationship Depth
- Relationship Direction
- Relationship Id
- Relationships
- Relationship Type
- Relationship Type Key
- Remaining Estimate
- Requirements Count
- Resolution
- Run By
- Run Number
- Script
- Script Id
- Script Priority
- Script Status
- Script Step Count
- Script Type
- Skipped
- Source
- Started At
- Status
- Step Actual Results
- Step Data
- Step Description
- Step Expected Result
- Step Notes
- Summary
- Test
- Test Id
- Test Scripts Count
- Text
- Ticket Id
- Ticket Key
- Ticket Url
- Total Nodes
- Total Results
- Tracker
- Type
- Undetermined
- Version Number
- Warnings