Maximo

Maximo

Come for answers, stay for best practices. All we're missing is you.

 View Only

  • 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.

    #AssetandFacilitiesManagement
    #Maximo


  • 2.  RE: Query Actual Materials from WO Tracking

    Posted Mon August 02, 2021 08:45 AM
    Edited by System Admin Wed March 22, 2023 11:49 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
    ------------------------------

    Original Message


  • 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.



    Original Message


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

    Original Message


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

    Original Message