From the Maximo Support Desk - Find All Your Work Orders

October 25, 2017 TomRichardson

Here's one of the many Maximo "tips and tricks" that I find to be of great value. It's possible to run a query to find all of the Work Orders that were entered by the logged-in User...

 The default query at the Work Order List tab shows all open records.  The procedure described here is a way to make a single-click query available to find only the Work Orders that you have entered. (the logged-in User)  This is merely setting up a List tab query that can be used permanently.

  1. At the List tab in Work Order Tracking:
  2. With the cursor in the Work Order field press Enter to execute the default query
  3. Click the Save Query button
  4. In the Query Name field enter "Reported By Current User" or other appropriate value
  5. In the Description field enter "Work Orders Entered By Current User" or other appropriate value
  6. Click the "Public?" checkbox, then click OK
  7. Click the drop-down arrow on the Save Query button, then click View/Manage Queries
  8. Expand the details for the query that you just created
  9. In the Clause field replace the value with:

 reportedby = (select personid from person where personid = (select personid from maxuser where userid = :USER ))

image


The user can now select this from the Available Queries section. Alternately, it could be made the default query for all users by checking the Default check-box from the View/Manage Queries dialog box.

 


Tom Richardson is an IBM Maximo Support Engineer and frequent contributor to the Asset Management Blog community.  For a complete index of links to his articles, visit
Index of articles by Tom Richardson, Support Engineer

Previous Article
From the Maximo Support Desk - Populating Manufacturer, Model, and Catalog# Fields on a PO

Maximo Users have asked if there is an algorithm for populating an item's Manufacturer, Model, and Catalog#...

Next Article
From the Maximo Support Desk - Measure Point is Reached and No Work Order Was Generated

Perhaps you've run into the scenario whereby no Work Orders are being generated for an Asset when its assoc...

×

Want our latest news? Subscribe to our blog!

Last Name
First Name
Thank you!
Error - something went wrong!