Maximo Open Forum

 View Only

 MX 7.6.1.2 w/Scheduler 7.6.8 - Graphical Work Week - Work Query NOT Returning Expected Results

  • Scheduling
Kevin Hutson's profile image
Kevin Hutson posted 06-22-2021 16:25
Basic query to return all Work Order records not in 'COMP' status.  29 day duration for schedule, not a rolling schedule, include Work Orders without Dates, Refresh when opening Gantt View.

((woclass = 'WORKORDER' or woclass = 'ACTIVITY') and historyflag = 0 and istask = 0 and status not in ('COMP'))

Should return 130 records 48 of which should be worktype = 'PM'.  It returns only 2 PM WO, and 40 non-PM WO's.

Anybody?​
Lori Pilgrim's profile image
Lori Pilgrim posted 06-23-2021 16:57
Hi Kevin

I don't think I have enough information to answer the question here.  Graphical Work Week always restricts the work/assignments it brings into a work list by the Start and End Date of the work list.  If the work orders you are missing have dates outside of these that would explain it.  Also we don't bring in work/assignments that have no dates (target or schedule) by default, there is a flag at the work list level -- Include Work Orders Without Dates? -- 
If you use this be careful there is a warning on selecting this value that schedule dates will be written back to the work based on the first date of the schedule.
Kevin Hutson's profile image
Kevin Hutson posted 06-23-2021 17:02
Thanks Lori, I actually figure it out on my own.  I appreciate your response.

Related Content