Maximo

Maximo

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

 View Only

  • 1.  Seeking Help: Maximo PM Search using Location hierarchy

    Posted 26 days ago

    Hi all,

    Maximo allows users to search for PM records using a location value in the Search Location hierarchy field

    This returns all PM records directly linked to the Location records in the hierarchy

    WE have a mixture of PM records linked to Locations and to Assets in the same Hierarchy

    How can the search function be updated to select all PM records from both the locations and the assets linked to location in the hierachy?

    Thanks



  • 2.  RE: Seeking Help: Maximo PM Search using Location hierarchy

    Posted 26 days ago

    Hi Geoff,

    there are two ways how you can achieve this. 
    You may want to implement similar logic in your Advanced Search dialog bean class as one providing Classification search capability (ref. ASSET app, psdi.webclient.beans.common.ClassificationBean searchmore dialog bean class).

    Slightly easier way is to define your own view in the Database Configuration application, link PM table with the newly created view using custom relationship and then add QBE search field in the app.
    This would actually mimic current PM app Search Location Hierarchy behavior, which is using PRIMARYSYSLOCPM.ANCESTOR attribute, where  PRIMARYSYSLOCPM: [PM->LOCANCESTOR, location =:location and systemid =( select systemid from locsystem where primarysystem = '1' and siteid =:siteid) and siteid=:siteid].



    ------------------------------
    Andrzej Więcław
    Naviam
    Wrocław, Poland

    If this post was helpful, please click the Like button to let others know.
    ------------------------------



  • 3.  RE: Seeking Help: Maximo PM Search using Location hierarchy

    Posted 26 days ago
    Thanks Andrzej

    Kind Regards Geoff




    Original Message


  • 4.  RE: Seeking Help: Maximo PM Search using Location hierarchy

    Posted 16 days ago

    Hello,

    I also used to use the PRIMARYSYSLOCPM.ANCESTORattribute in the 'SearchMore' dialog box of PM with an enhanced PRIMARYSYSLOCPM relation.

    The idea is to enhance the Where clause of the PRIMARYSYSLOCPM relation by adding a complementary join criteria : the Asset of PM.

    Here is a solution :  systemid=(select systemid from locsystem where primarysystem='1' and siteid=:siteid) and siteid=:siteid and (location=:location or location in (select location from asset where assetnum=:assetnum and siteid=:siteid))

    Once done, when a user enters i.e. "BOILER" as the Ancestor in the SearchMore dialog box , Maximo will build this query :

    WHERE EXISTS (SELECT 1 FROM locancestor WHERE ancestor='BOILER' AND  
    systemid=(select systemid from locsystem where primarysystem='1' and siteid=pm.siteid) and siteid=pm.siteid and (location=pm.location or location in (select location from asset where assetnum=pm.assetnum and siteid=pm.siteid)))

    Regards,



    ------------------------------
    Hugues LOMBARD
    Managing Applications Consultant
    CAPGEMINI
    ------------------------------



Related Content