Maximo Open Forum

We had a request to add "Craft" to the PM Advanced Search dialog. I'm familiar with adding a regular field to the search dialog but not sure if it's even possible because it's a different table (JOBLABOR)? We can get the data with a where clause using an "Exists" subquery, just want the users to be able to do it from the search dialog.

PM to JOBPLAN to JOBLABOR can be done by adding relationships to the advanced search screen. PM->JOBPLAN can be complicated because there is the concept of PM sequences where depending on the interval it would change the job plan. To search only on the next job plan that will be utilized you can do the following: