Maximo

Maximo

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

 View Only

  • 1.  Object Structure --> Database Join Required

    Posted Wed October 06, 2021 09:52 PM
    Edited by System Admin Wed March 22, 2023 11:48 AM
    MAM 7.6.1.2:

    Object Structures application --> Source Objects table window

    What is the purpose of the Database Join Required field? 


    The Alt+F1 field help says this, but I still don't understand:
     - MAXINTOBJDETAIL.RELATIONJOINREQUIRED
     - "Nonpersistent field used to populate maxrelationship.dbjoinrequired for Reporting Object Structures"

    Thanks.



    #AssetandFacilitiesManagement
    #Maximo


  • 2.  RE: Object Structure --> Database Join Required

    Posted Fri October 08, 2021 10:17 AM
    Edited by System Admin Wed March 22, 2023 11:50 AM
    QBR (Ad Hoc) Reporting and Report Object Structures - Revision 3 (page 76)

    4.5.2 Database Join Required

    The type of database join between two tables determines the data that is returned in a report. It is probably one of the most important aspects in defining the report relationships.

    There are two types of joins. A required database join, and an optional, or left outer join. The type of join used in the maxrelationship will determine the type of data returned in the Ad Hoc report.

    If the join is defined as required, or an inner join, a '1' will be used in the MAXRELATIONSHIP.DBJOINREQUIRED field. This type of join will only return results that have corresponding data in both tables. These inner joins limit the data that is returned.

    If the join is defined as NOT required, or an outer join, its value will be '0'. This is the default value. This type of join will return results that may or may not have corresponding data.

    Looking further at the relationship between the PR to PR Line table - If the MAXRELATIONSHIP.DBJOINREQUIRED = '1', only PRs with entries in the PRLINE table will be returned in the report.

    If the MAXRELATIONSHIP.DBJOINREQUIRED = '0', any PR – with or without entries in the PRLINE table -
    will be returned in the report.

    In this case, you can create and save a PR without defining any PRLINES, so the DBJOINREQUIRED = 0.

    Note: For Detail reports, the DB Join Required field does not apply to the relationship between the Category sections and the Header section. For example, if PR is in the header and PRLINE is in a separate Category section, PRs will show in the header even when there are no related PRLINES . This is because separate SQL queries are executed to retrieve the data for these sections.



    #Maximo
    #AssetandFacilitiesManagement