Use Case:
Large enterprise client is requesting the ability to join Service Tasks and Work Orders within reporting and data queries. This would allow users to report across both entities in a single dataset, eliminating the need for manual data manipulation and providing improved visibility into maintenance execution and performance metrics.

Current Challenge
Today, Service Tasks and Work Orders appear to be treated as separate data entities, limiting customers' ability to create comprehensive reports, dashboards, and operational analyses that span both objects.

Requested Enhancement
Provide support for joins between Service Tasks and Work Orders, enabling customers to:

Report on Service Task details alongside related Work Order information.
Build more comprehensive operational and maintenance reports.
Reduce manual effort required to merge data outside the platform.
Improve visibility into work execution, task completion, and maintenance performance.

Business Impact
This enhancement would enable clients to perform more meaningful analysis of maintenance activities, improve reporting efficiency, and gain deeper insights into the relationship between work orders and the service tasks performed to complete them.