Hi All,
I've recently discovered GWW and thought it was ideal solution for the scheduling request from users. I created a new schedule using a simple query to return Outstanding work (status and worktype), but although the query returns the correct work orders it also returns other work orders from different sites, different status's and different worktypes. We found the incorrect work orders were actually tasks of another work order which had the same wonum as one of the correct work orders! I tried restricting these in the query but GWW still returned the incorrect tasks. The work order highlighted below is the correct one, the others are from a different site, different status and dates from the query?

The GWW guide says that work order tasks and those in history will not be included in the results (these are not included when you use the Quick Query Buider).
I also found an IFIX IJ27930 has been released for incorrectly displaying child work orders, but this is showing tasks.
We noticed that if you untick the 'Include Tasks in Scheduler' check box on the work order then this solved the problem, but this does not seem to be a great solution as all workorders by default have this check box ticked, so it means removing this from all existing work orders and changing the default to 0. Also this would mean the tasks would not be shown in Graphical assignment if the work order is used there.
Has anybody else had similar issues or some suggestions in how to solve.
Thanks in advance
Ges

------------------------------
ges purnell
Maximo Administrator
Toyota UK Ltd
Derby
01332 284750
------------------------------



#AssetandFacilitiesManagement
#Maximo
#MaximoScheduler

Hi Ges,

You will want to include siteid as criteria in your query.  

Graphical Work Week looks at the WMASSIGNMENT table.  The rows displayed in the table are a hybrid of information about the work order or task and assignment.  The intended solution is to use the Include Tasks in Schedule checkbox to indicate if you want to include the the tasks to assign.  This checkbox exists at the work order level and on each individual task (for scenario where you do want to assign 1 task but not another). When you uncheck the checkbox on the work order, it is unchecked on the tasks.  This checkbox also exists on the Job Plan and Job Plan tasks so you can template it.  You are correct, by default this checkbox is checked.  You can have this changed in Database Configuration though by changing the default value to 0 instead of 1.  

Here is a link with good information about the Graphical Work Week application.  Check out slide 5 - it provides examples of what will be brought into your work list depending on how you have that Include Tasks in Schedule checkbox set.

https://ibm.ent.box.com/s/o12r15003jmkk6qqduxlmmawq0oev698

https://community.ibm.com/community/user/iot/viewdocument/scheduler-768?CommunityKey=60718772-c63c-4d74-bdad-56d8beac4ba3&tab=librarydocuments&LibraryFolderKey=8801357d-ecca-4509-a50e-d0f82fbe8d83&DefaultView=folder





------------------------------
Lacey Lurges
------------------------------

Hi Lacey, thanks for your reply. I think I may have responded to you privately but the answer is basically the same as I have answered to Pedro. We had changed the default to 0 and removed the ticked checkbox for all existing open wo's which proved this method worked. But I'm still not convinced we should have to do this as GWW should not show tasks at all. 
Kind Regards
Ges

------------------------------
ges purnell
Maximo Administrator
Toyota UK Ltd
Derby
01332 284750
------------------------------

Original Message:
Sent: Mon July 11, 2022 12:26 PM
From: Lacey Lurges
Subject: Graphical Work Week - Unexpected results from Query

Hi Ges,

You will want to include siteid as criteria in your query.  

Graphical Work Week looks at the WMASSIGNMENT table.  The rows displayed in the table are a hybrid of information about the work order or task and assignment.  The intended solution is to use the Include Tasks in Schedule checkbox to indicate if you want to include the the tasks to assign.  This checkbox exists at the work order level and on each individual task (for scenario where you do want to assign 1 task but not another). When you uncheck the checkbox on the work order, it is unchecked on the tasks.  This checkbox also exists on the Job Plan and Job Plan tasks so you can template it.  You are correct, by default this checkbox is checked.  You can have this changed in Database Configuration though by changing the default value to 0 instead of 1.  

Here is a link with good information about the Graphical Work Week application.  Check out slide 5 - it provides examples of what will be brought into your work list depending on how you have that Include Tasks in Schedule checkbox set.

https://ibm.ent.box.com/s/o12r15003jmkk6qqduxlmmawq0oev698

https://community.ibm.com/community/user/iot/viewdocument/scheduler-768?CommunityKey=60718772-c63c-4d74-bdad-56d8beac4ba3&tab=librarydocuments&LibraryFolderKey=8801357d-ecca-4509-a50e-d0f82fbe8d83&DefaultView=folder





------------------------------
Lacey Lurges
------------------------------

Hi Ges Prunell, thanks for share about your experience, I would like to confirm a few items with you:
- Is possible to share your query? I mean due to the fact Scheduler applications such as Graphical Work Week are Organization level applications, and we follow the same approach as Assignment Manager of Maximo. So to restrict work on the Site level that needs to be added to the query condition.
- The process of loading is pretty simple once that is a flat view focus on Assignment objects, but once you don't have an assignment that will return possible records you can add Assignments, and as your Query didn't restrict by the Complete work that will appear to you, so we advise to use that as a restriction on the query conditions for the Main work. So please share additional to the Query the Start and End Date of your record so we can understand, once the dates are restrictions at the record side and not at the Query level.
- And you are correct about the Fix we did at the IFIX02 around the  'Include Tasks in Scheduler' check box was for consistency cross Graphical Scheduling and Graphical Assignment application that allows the user to exclude from Planning and assignment records that are not effort and doesn't need to be Planned, Schedule and Assigned.

So let's start to understand your query and build similar scenarios where we can expect design of the tool and purpose some suggestions that will bring the value you are looking for, remember main object of Graphical Work Week is the WMASSIGNMENT object. For others that are already using this application please feel free to add comments to the Query process too.

------------------------------
Pedro Spadacini
Product Manager and Architect, Maximo Scheduler
IBM
São Paulo
------------------------------

Hi Pedro, thanks for reply. The query is very simple it defines the siteid, wostatus's, worktypes, crewid and persongroup the customer required for planning.
((status = 'APPR' or status = 'CONF' or status = 'HOLD' or status = 'INPRG' or status = 'WAPPR' or status = 'WMATL' or status = 'WSCH') and (woclass = 'WORKORDER' or woclass = 'ACTIVITY') and upper(crewid) = 'F_F_C' and historyflag = 0 and persongroup = 'F_F_C_1' and istask = 0 and siteid = 'TMMFF' and (worktype = 'CM' or worktype = 'H&S' or worktype = 'INV' or worktype = 'KZN' or worktype = 'MBR' or worktype = 'MOD' or worktype = 'PM' or worktype = 'PMD' or worktype = 'REQ' or worktype = 'STAT' or worktype = 'STATD' or worktype = 'TRG'))
It looks a bit messy because I used the quick Query Builder (I have tried writing a simpler query but still the GWW is showing work orders with the wrong site, status and worktype. It even returns work orders out of the dates set on the Start and End Dates)!
As mentioned before the solution to untick the 'Include Task in Scheduler' on wo's works (I have confirmed by removing this from all existing work orders) and the GWW returns only the wo's defined in the query. But it does not seem to be correct solution as you might want to see the tasks if you are using GA.
Looking at the WMASSIGNMENT object there is a relationship for WORKORDER (wonum=:wonum and siteid=:siteid), should this filter the wo on wonum and site?
Kind Regards
Ges

------------------------------
ges purnell
Maximo Administrator
Toyota UK Ltd
Derby
01332 284750
------------------------------

Original Message:
Sent: Mon July 11, 2022 05:49 PM
From: Pedro Spadacini
Subject: Graphical Work Week - Unexpected results from Query

Hi Ges Prunell, thanks for share about your experience, I would like to confirm a few items with you:
- Is possible to share your query? I mean due to the fact Scheduler applications such as Graphical Work Week are Organization level applications, and we follow the same approach as Assignment Manager of Maximo. So to restrict work on the Site level that needs to be added to the query condition.
- The process of loading is pretty simple once that is a flat view focus on Assignment objects, but once you don't have an assignment that will return possible records you can add Assignments, and as your Query didn't restrict by the Complete work that will appear to you, so we advise to use that as a restriction on the query conditions for the Main work. So please share additional to the Query the Start and End Date of your record so we can understand, once the dates are restrictions at the record side and not at the Query level.
- And you are correct about the Fix we did at the IFIX02 around the  'Include Tasks in Scheduler' check box was for consistency cross Graphical Scheduling and Graphical Assignment application that allows the user to exclude from Planning and assignment records that are not effort and doesn't need to be Planned, Schedule and Assigned.

So let's start to understand your query and build similar scenarios where we can expect design of the tool and purpose some suggestions that will bring the value you are looking for, remember main object of Graphical Work Week is the WMASSIGNMENT object. For others that are already using this application please feel free to add comments to the Query process too.

------------------------------
Pedro Spadacini
Product Manager and Architect, Maximo Scheduler
IBM
São Paulo
------------------------------

Hi Ges,

Like Pedro said it's really hard to understand without seeing the query.  The query that Pedro posted, I assumed came from you, so unless the OR statement and brackets on your original are set incorrectly, it will work.  BTW: I've posted that same query written in more shorthand SQL.

It's important to always include the SITEID in your query as it seems that you've got more than one site and in reality, you only wanted them from the one sited.  it's also important to include ISTASK=0 to remove the task work orders, HISTORYFLAG you can remove and you've already stated what statuses you want.  That said, IBM have stated that ISTASK and HISTORYFLAG are added in the background by default and so are not needed in the query.

Yes, the relationship that you have mentioned does filter on the WONUM and the SITEID, so that is only about getting info from the work order.  The WMASSIGNMENT is a view that uses the following Where Clause
FROM assignment RIGHT OUTER JOIN workorder on assignment.wonum = workorder.wonum and assignment.siteid = workorder.siteid

As you can see, it does not filter out the task, so even though your Work Queries do, the tasks will still show (unless you uncheck "Include Tasks in Scheduler" which is filtered by the code on the Gantt Chart).  BTW: If you not assigning people at the task level, there is no need to have tasks displayed.  This can be seen as frustrating, but it's a reality that you assigning only at the work order, so no need for tasks.

There should be no way, you should be seeing assignments from another site unless your Work Queries are not filtered.

If the work has a Job Plan, then you can set the Include Tasks in Schedule? to off in the Job Plan, otherwise, yes it's a manual change per work order.

=========================

(status in ('APPR','CONF','HOLD','INPRG','WAPPR','WMATL','WSCH')
and (woclass = 'WORKORDER' or woclass = 'ACTIVITY')
and upper(crewid) = 'F_F_C'
and historyflag = 0
and persongroup = 'F_F_C_1'
and istask = 0
and siteid = 'TMMFF'
and worktype IN ('CM','H&S','INV','KZN','MBR','MOD','PM','PMD','REQ','STAT','STATD','TRG'))

------------------------------
===============================
Craig Kokay,
Lead Senior Maximo/IoT Consultant
ISW
Sydney, NSW, Australia
Ph: 0411-682-040
=================================
#IBMChampion2022
------------------------------

Hi Craig

Thanks for your reply.
Sorry for delay but I tried using your query in a test schedule but it would not run on our system and after 5 mins gave a server error (although it did run, very quickly, in work order tracking).
After trying various times with no success, I changed the query to this 
siteid = 'TMMFF'
and status in ('APPR','CONF','HOLD','INPRG','WAPPR','WMATL','WSCH')
and worktype in ('CM','H&S','INV','KZN','MBR','MOD','PM','PMD','REQ','STAT','STATD','TRG')
and crewid = 'F_F_A'
and persongroup = 'F_F_A_1'
and it ran, taking about 2 mins - which I gather is acceptable for GWW.
But the query still returns workorders from different sites, different status and start date well out of the range specified in the schedule, see below

The WAITASGN workorders are correct but the one highlighted is from a different site etc. Selecting wo's with the same wonum shows the query returns all the task wo's from the parent whose wonum is the same as the wonum from a correct workorder

We have found this can be solved by removing the 'include task in scheduler' check box on the work orders, but should we have to do this?
Also I have tried using the where clause you mentioned for the WMASSIGNMENT view and this does filter on site, so why do we still get the wo's from the other sites?
Thanks for your help..

------------------------------
ges purnell
Maximo Administrator
Toyota UK Ltd
Derby
01332 284750
------------------------------

Original Message:
Sent: Wed July 13, 2022 01:37 AM
From: Craig Kokay
Subject: Graphical Work Week - Unexpected results from Query

Hi Ges,

Like Pedro said it's really hard to understand without seeing the query.  The query that Pedro posted, I assumed came from you, so unless the OR statement and brackets on your original are set incorrectly, it will work.  BTW: I've posted that same query written in more shorthand SQL.

It's important to always include the SITEID in your query as it seems that you've got more than one site and in reality, you only wanted them from the one sited.  it's also important to include ISTASK=0 to remove the task work orders, HISTORYFLAG you can remove and you've already stated what statuses you want.  That said, IBM have stated that ISTASK and HISTORYFLAG are added in the background by default and so are not needed in the query.

Yes, the relationship that you have mentioned does filter on the WONUM and the SITEID, so that is only about getting info from the work order.  The WMASSIGNMENT is a view that uses the following Where Clause
FROM assignment RIGHT OUTER JOIN workorder on assignment.wonum = workorder.wonum and assignment.siteid = workorder.siteid

As you can see, it does not filter out the task, so even though your Work Queries do, the tasks will still show (unless you uncheck "Include Tasks in Scheduler" which is filtered by the code on the Gantt Chart).  BTW: If you not assigning people at the task level, there is no need to have tasks displayed.  This can be seen as frustrating, but it's a reality that you assigning only at the work order, so no need for tasks.

There should be no way, you should be seeing assignments from another site unless your Work Queries are not filtered.

If the work has a Job Plan, then you can set the Include Tasks in Schedule? to off in the Job Plan, otherwise, yes it's a manual change per work order.

=========================

(status in ('APPR','CONF','HOLD','INPRG','WAPPR','WMATL','WSCH')
and (woclass = 'WORKORDER' or woclass = 'ACTIVITY')
and upper(crewid) = 'F_F_C'
and historyflag = 0
and persongroup = 'F_F_C_1'
and istask = 0
and siteid = 'TMMFF'
and worktype IN ('CM','H&S','INV','KZN','MBR','MOD','PM','PMD','REQ','STAT','STATD','TRG'))

------------------------------
===============================
Craig Kokay,
Lead Senior Maximo/IoT Consultant
ISW
Sydney, NSW, Australia
Ph: 0411-682-040
=================================
#IBMChampion2022
------------------------------