Maximo

Maximo

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

 View Only
  • 1.  BIRT Designer, information in report

    Posted Mon January 11, 2021 06:15 AM
    Edited by System Admin Wed March 22, 2023 11:53 AM
    Hello,

    I am new at BIRT Designer in Maximo.

    I have report inventory transactions. Like we see it below:

    Opis ni na voljo
    In my Eclipse code for SQL Query I have code like this: where I get datas from table MXZINVTRANS:

    Opis ni na voljo
    In table MXZINVTRANS I have data like this:

    Opis ni na voljo

    What I want to do is that I want to add at the report beside type of transactions 'Izdaja' number of order(INVUSENUM). Which is in table INVUSELINE I think.

    Opis ni na voljoOpis ni na voljo
    My question is, how to write this in sql query to get this information, because I dont know how to properly connect this to get the right information? Any idea or suggestion?


    ------------------------------
    Blaz Rakar
    ------------------------------
    #AssetandFacilitiesManagement
    #Maximo


  • 2.  RE: BIRT Designer, information in report

    Posted Tue January 12, 2021 12:17 PM
    It would appear that the maximo.mxzinvtrans object is a new custom object?  If so then simply look at the relationships you have in DB config to determine how to make your join.  since it appears to be a custom object it is difficult to say definitively how to create your relationship to your INVUSAGE object and related lines. Once you know the join characteristics just simply determine if you need an inner or outer join and away you go.

    ------------------------------
    Bradley K. Downing , MBA
    IBM Certified Adv. Deployment Prof. Maximo v7.6.1
    IBM
    Bakersfield CA
    ------------------------------