Maximo

Maximo

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

 View Only

  • 1.  Views in db config: Purpose of "Join to Object" field?

    Posted Wed November 03, 2021 10:14 PM
    Edited by System Admin Wed March 22, 2023 11:46 AM
    MAM 7.6.1.2:

    What is the intended use case for the Join to Object field in Database Configuration?


    Also, what kind of join is it? An inner join?

    Thanks.
    #Maximo
    #AssetandFacilitiesManagement


  • 2.  RE: Views in db config: Purpose of "Join to Object" field?

    Posted Thu November 04, 2021 07:50 AM
    I've never used it, but according to the JavaDocs on MAXOBJECTCFG (https://bportaluri.com/wp-content/MaximoJavaDocs76/psdi/app/configure/MaxObjectCfgRemote.html) it causes an inner join to the other object. I personally think it's easier to just do that in the view from and specify the exact syntax that you want it to join on.

    ------------------------------
    Steven Shull
    ------------------------------

    Original Message


  • 3.  RE: Views in db config: Purpose of "Join to Object" field?

    Posted Thu November 04, 2021 02:20 PM
    The best examples of this are PURCHVIEW, LEASEVIEW which connect CONTRACT to the application-specific tables such as CONTRACTPURCH, CONTRACTLEASE. View the script of these and you observe they connect to 2 tables using an inner join.

    ------------------------------
    Nivin Jacob George Senior Consultant
    Senior Consultant
    Praxis Solutions
    Kuwait
    ------------------------------

    Original Message


Related Content