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)))