Sample queries

You must use the proper query to populate your schedule or work list with relevant data.

Work queries for a schedule or work list

The following queries are examples of common queries you might use to populate a schedule or work list. They are based on a Maximo® 7.x deployment on an Oracle database. These queries are to be used as templates for your actual production queries, which should be tested thoroughly before deployment. Your database syntax might vary.

You can also create queries using the relevant Maximo application's list page, in the Advanced Search window. You can do a query by example on the field combinations of interest. Once executed, you can see and modify the SQL statement in the Where Clause window, available from the dropdown menu in the Advanced Search window.

All work orders scheduled for a two week period

((woclass = 'WORKORDER' or woclass = 'ACTIVITY') and schedstart <= '2010-04-16 09:08:24.000' and historyflag = 0 and siteid = 'BEDFORD' and istask = 0 and schedstart >= '2010-04-05 09:08:04.000' )

All work orders that a specific user owns, and are approved or in progress

owner = (select personid from person where personid = (select personid from maxuser where userid = 'WILSON' )) and status in ('APPR','INPRG') note that the attribute owner could just as easily be supervisor or lead, or any field that resolves to a person id.

All work orders that are scheduled for this week

((woclass = 'WORKORDER' or woclass = 'ACTIVITY') and historyflag = 0 and siteid = 'BEDFORD' and istask = 0 and schedstart >= sysdate and schedstart <= (sysdate + 7))

All work orders targeted to be complete that are not (backlog)

((woclass = 'WORKORDER' or woclass = 'ACTIVITY') and historyflag = 0 and siteid = 'BEDFORD' and istask = 0 and targcompdate <= sysdate and status != 'COMP')

All in progress work for a group of assets with a similar prefix, found anywhere on a work order (as the primary asset or an entry in the Multiple Assets, Locations, and CIs table window)

((woclass = 'WORKORDER' or woclass = 'ACTIVITY') and status = ‘INPRG' and historyflag = 0 and siteid = 'BEDFORD' and istask = 0) and (exists (select 1 from maximo.multiassetlocci where ((assetnum like 'A80%')) and (recordkey=workorder.wonum and recordclass=workorder.woclass and worksiteid=workorder.siteid)))


Feedback