Krystal,
You can show details from the Assignment record, like the Scheduled Start/Finish Dates, in a Start Center Result Set by utilizing a Reporting Object Structure to relate the WORKORDER table to the ASSIGNMENT table.
The general steps are:
- Create a Reporting Object Structure in the Integration > Object Structures application
- Grant security access to the Reporting Object Structure in the Administration > Report Administration application
- Use the new Reporting Object Structure in the Result Set portlet
One thing to be careful of is that there can be multiple Assignments for a given Work Order. If you are limiting yourself to a single Assignment per Work Order then there's nothing to worry about. But if you have multiple Assignments per Work Order, then you'll need to consider which of the Assignment records will show in the Result Set for a single Work Order.
Let me know if you have follow up questions. Happy to help.
------------------------------
Alex Walter
A3J Group LLC
------------------------------
Original Message:
Sent: 12-03-2020 12:35
From: Krystal Clark
Subject: Scheduled Start date - 2 different dates?
Hello All,
I recently set up a result set for my maintenance guys that shows work assigned to them. In this I used "Scheduled Start Date" to show when their work is scheduled to be completed, and they can filter/sort by date. I found out afterwards that this date is pulling from the Work Order tab instead of the Assignment tab. I thought these were the same dates so I'm not sure how to get around this. Any insight is appreciated!
#WorkManagement
------------------------------
Krystal Clark
GAF
------------------------------