This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.
I have version 6.2.6 and would like to have an excel report with completion remarks. I am use MSquery. This report currently shows closed non-pm workorders with hours from last 30days.
If I add the worklog table to my query do I need to join and if so on which fields? I couldn't find a common field.
=================================================================
SELECT WORKORDER.WONUM, WORKORDER.DESCRIPTION, WORKORDER.LOCATION, WORKORDER.ASSETNUM, WORKORDER.STATUS, WORKORDER.REPORTEDBY, WORKORDER.REPORTDATE, WORKORDER.ACTFINISH, WORKORDER.ACTLABHRS
FROM MAXIMO.WORKORDER WORKORDER
WHERE (WORKORDER.STATUS='CLOSE') AND (WORKORDER.ISTASK=0) AND (WORKORDER.PMDUEDATE Is Null) AND (WORKORDER.ACTFINISH>SYSDATE-30)
===================================================================
--- In MAXIMO@yahoogroups.com, "s_angel0" <sharon_yates@...> wrote:
>
> I was speaking to a few IBM support folks at PULSE this year - it seemed unanimous - put tech completion notes in the new LOG tab that is now in v7 (not sure if it was in v6). Ok. BUT, has anyone successfully managed to get the Log tab with Work Log and Comm Log sub tabs inside of Quick Reporting? This is where most of our admins / techs go to complete a WO with time/materials/comments yet QR is stuck with Failure Remarks tab which IBM advised against using for completion comments. I started looking into this but it seemed I either need to get into Java class extensions or at the very least some XML modifications.
>
> Thanks!
> Sharon
>
You need to create a new reporting object that you can reference in the qbr. Make sure you have relationships between the main mbo and the worklog and commlog mbo,s . If you are not using 7.1.1.7 or above then you will need to go direct into database and make the cardinality multiple for wonum (for example).
There is an ibm best practice reporting guide for qbr which explains this all
http://www.ibm.com/developerworks/wikis/display/maximo/Creating+Report+Object+Structures
Brian Scott
Service Management Connect
Sent from my iPad
On 30 Jul 2011, at 23:17, "rudy.banks" <rudolph.banks@ge.com> wrote:
> I have version 6.2.6 and would like to have an excel report with completion remarks. I am use MSquery. This report currently shows closed non-pm workorders with hours from last 30days.
>
> If I add the worklog table to my query do I need to join and if so on which fields? I couldn't find a common field.
> =================================================================
> SELECT WORKORDER.WONUM, WORKORDER.DESCRIPTION, WORKORDER.LOCATION, WORKORDER.ASSETNUM, WORKORDER.STATUS, WORKORDER.REPORTEDBY, WORKORDER.REPORTDATE, WORKORDER.ACTFINISH, WORKORDER.ACTLABHRS
>
> FROM MAXIMO.WORKORDER WORKORDER
>
> WHERE (WORKORDER.STATUS='CLOSE') AND (WORKORDER.ISTASK=0) AND (WORKORDER.PMDUEDATE Is Null) AND (WORKORDER.ACTFINISH>SYSDATE-30)
> ===================================================================
>
>
> --- In MAXIMO@yahoogroups.com, "s_angel0" <sharon_yates@...> wrote:
> >
> > I was speaking to a few IBM support folks at PULSE this year - it seemed unanimous - put tech completion notes in the new LOG tab that is now in v7 (not sure if it was in v6). Ok. BUT, has anyone successfully managed to get the Log tab with Work Log and Comm Log sub tabs inside of Quick Reporting? This is where most of our admins / techs go to complete a WO with time/materials/comments yet QR is stuck with Failure Remarks tab which IBM advised against using for completion comments. I started looking into this but it seemed I either need to get into Java class extensions or at the very least some XML modifications.
> >
> > Thanks!
> > Sharon
> >
>
>