Hello,
I am new at BIRT Designer in Maximo.
I have report inventory transactions. Like we see it below:

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

In table MXZINVTRANS I have data like this:

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.


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