What I ended up doing was adding a new row to the REP_ASSET object structure for PLUSCASSETSTATUS with the default relationship. However, as you pointed out, the report contained a line for each status change. So I copied the relationship on the ASSET table and added "changedate=:statusdate" to the query. Went back to the object structure, changed the relationship, and now I only get the latest memo in the report. Thanks for guiding the way!
------------------------------
Jason Johnson
RSI
------------------------------
Original Message:
Sent: 04-23-2025 08:54
From: Alex Walter
Subject: Asset status memo
Jason,
The status change memo for Asset status changes is stored in the PLUSCASSETSTATUS table (the regular ASSETSTATUS table stores downtime information about assets). You should be able to create a new Reporting Object Structure that links the ASSET object to the PLUSCASSETSTATUS object, and use that in the Ad Hoc report builder. Similarly, you can duplicate an out-of-box Reporting Object Structure and modify it.
If you're set on the BIRT route, you can obviously do that too. You'll just have to join the PLUSCASSETSTATUS table to the ASSET table in your SQL statement that you create in the open() method.
Be aware that regardless of the route taken, the relationship between ASSET and PLUSCASSETSTATUS is one-to-many, so you may get more records back than you expect if there have been multiple status changes for a single asset record.
Hope this helps,
------------------------------
Alex Walter
A3J Group LLC
Original Message:
Sent: 04-22-2025 08:22
From: Jason Johnson
Subject: Asset status memo
We would like to display the status change memo on a QBR. Since this is a non-persistent table, it's not available to be selected in the AdHoc wizard. I can see that it's not possible in the interface, however, IBM states that it could be possible in the BIRT definition.
Non Persistent attributes in Birt reports
The relevant quote "The report developer would have to replicate the business logic inside the report in order to calculate the appropriate value you wish to include in the report."
Has anyone done this or something similar with another non-persistent table in BIRT?
#Reporting
------------------------------
Jason Johnson
RSI
------------------------------