Maximo

Expand all | Collapse all

Query Actual Materials from WO Tracking

  • 1.  Query Actual Materials from WO Tracking

    Posted Fri July 30, 2021 03:00 PM

    Hello all!

     

    I'm relearning Maximo after a few years in another industry and am struggling to query actual materials in WO Tracking. Specifically, I need to find all work orders where X part was issued against Y asset in our fleet.

     

    I know someone likely has a saved query that does just this, or something close enough that I can swap out a couple of field names. If you're willing to share, I'd appreciate it!

     

     

    Jennifer R. Hill
    Work Order Supervisor

    jennifer.hill@alstomgroup.com

     



    CONFIDENTIALITY : This e-mail and any attachments are confidential and may be privileged. If you are not a named recipient, please notify the sender immediately and do not disclose the contents to another person, use it for any purpose or store or copy the information in any medium.


  • 2.  RE: Query Actual Materials from WO Tracking

    Posted Mon August 02, 2021 08:45 AM
    Edited by christopher winston Mon August 02, 2021 08:51 AM
    Jennifer,

    To make it a little easier on your users, I would recommend you add fields to the advanced search. Take a look here: https://youtu.be/5RSe5s5FfeU

    In application designer, just remember to identify the attribute with the relationship:



    ------------------------------
    Thanks,
    christopher winston
    ------------------------------



  • 3.  RE: Query Actual Materials from WO Tracking

    Posted Mon August 02, 2021 09:01 AM

    Yes, I actually commented on that video a couple of days ago. I'd prefer to use Advanced Search, but was informed it will take up to 4 months to implement as our site is one small piece of a much larger environment. I'm currently pulling these reports from SQL, which leaves me as a bottleneck for information. I have users comfortable enough with the Where clause that I can give them the base script and let them update the variables as needed. I just need the Where clause to give them.

     

    Thanks!

    Jennifer

     

     



    CONFIDENTIALITY : This e-mail and any attachments are confidential and may be privileged. If you are not a named recipient, please notify the sender immediately and do not disclose the contents to another person, use it for any purpose or store or copy the information in any medium.





  • 4.  RE: Query Actual Materials from WO Tracking

    Posted Mon August 02, 2021 09:22 AM
    wonum in (select refwo from matusetrans where itemnum = 'XXXXX' and assetnum = 'YYYYY')

    ------------------------------
    Travis Herron
    ------------------------------



  • 5.  RE: Query Actual Materials from WO Tracking

    Posted Mon August 02, 2021 09:31 AM
    The syntax generated by the change is:

    {((woclass = 'WORKORDER' or woclass = 'ACTIVITY') and historyflag = 0 and siteid = 'SITEID' and istask = 0) and (exists (select 1 from dbo.matusetrans where ((itemnum like '%ITEMNUMBER%')) and (refwo=workorder.wonum and tositeid=workorder.siteid and linetype not in (select value from synonymdomain where domainid='LINETYPE' and maxvalue='TOOL'))))}

    so perhaps that will help.

    ------------------------------
    Thanks,
    christopher winston
    ------------------------------