Maximo

Maximo-ICON.png

Maximo

Learn how to increase the operational efficiency of the assets you manage, and improve overall equipment effectiveness by using IoT data and AI.

Maximo-ICON.png

TRIRIGA

Reduce the operational costs of the facilities you manage, and create more engaging occupant experiences through the application of IoT data and AI.

Maximo-ICON.png

Engineering

Learn how IoT data and AI are being applied to transform the end-to-end engineering lifecycle.

Expand all | Collapse all

BIRT Designer, information in report

  • 1.  BIRT Designer, information in report

    Posted 7 days ago
    Edited by Blaz Rakar 7 days ago
    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
    ------------------------------


  • 2.  RE: BIRT Designer, information in report

    Posted 5 days ago
    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
    ------------------------------