You’re offline. This is a read only version of the page.
905
Hello,
I have the below fetch XML that will generate the related closed-posted work orders from the bookableresourcebooking in the customer asset entity and I have a related custom entity to the WO that I am bringing from it two fields that will be generated on the report that is built on SSRS.
The query that I have problem with is that is related to the WO is the below:
When the report got generated the only displayed records are the ones that has rows on the targeted entity "haceb_assetdetail" and the WO that is closed-posted.
What I want to achieve is to display all the work order records that are closed posted using the same query regardless of whether the work order does not have a row in this table "haceb_assetdetail".
Example:
The below screenshot shows a list of WO's:
Taking the example of 38241 it does not have a line item under the haceb_assetdetail entity.
As a result, when I generate the report this Work order number is not showing because of that filter logic.
What should be the updated XML query to display all the closed posted work orders with the related lines under haceb_assetdetail regardless if the work order does not have a row in that table?
Please let me know if you need any further information.
Any help is highly appreciated.
Best regards,
EBMRay
Hi EBMRay,
You should use outer link-type instead inner. Please change these lines from
to
Reference:
Share
Report
All responses (
Answers (
