Maximo Open Forum

 View Only

 2 Labor Records Assigned to a WO

  • Maximo Application Suite
  • Reporting
  • Work Centers
Carlos Mestre's profile image
Carlos Mestre posted 04-17-2023 17:20

Hi All, 

I have created a Portlet Result Set against Application WOTRACK and Object Structure Work Order Details. I added the Assignment table to the Object List Tree under Work Order Details so assignment.laborcode could be retrieved. My goal is to pull all the internal WOs that have a labor record assigned to them. These are the fields I have selected:
- WONUM
- DESCRIPTION
- STATUS
- WORKTYPE
- LABOR
- SITE

The query I've created successfully pulls Work Orders that have a labor record assigned to them. However, if the WO has more than one Labor record associated to it, my Portlet result only shows the top labor record per WO. How could I make my result set show all the Labor records that are associated to each WO? Thank you!

Steven Shull's profile image
Steven Shull

Going from WO to ASSIGNMENT isn't possible in the start center portlets today. We only support 1:1 relationships like going from a WO to ASSET based on the ASSETNUM field. By default, we prevent customers from selecting data from a 1:many relationship by the webclient.allowMultipleCardinality system property being set to 0 (the default) to avoid confusion.

What you should be able to do is the reverse (going from ASSIGNMENT to WO) but it's a bit tricky because there is no application out of the box you can use. A result set portlet must have an application where the main object is the main object of that application. Assignment Manager isn't available to be selected for portlets (it's a special type of app) and that's the only one where the main object is set to ASSIGNMENT. But if you create a new application where ASSIGNMENT is the main object and then create a Report Object Structure (ROS) that has ASSIGNMENT and WORKORDER you would be able to display data from both.

Something to be aware of is that you can filter on related attributes, but you cannot sort on them. If you needed to sort based on Work Order scheduled finish for example, that would be a problem with ASSIGNMENT being the main object. 

As we continue to enhance our new dashboards, we'll hopefully soon have a much better answer here.