How to modify a where clause in a ADHOC/ QBR Maximo report

As there is no OOB way to do this via the front end your going to need DBA access and some very minor elbow grease. Maybe in the future IBM will resolve this.

This is something that can be done on simple ADHOC / QBR reports that are scheduled to go out to the business when nothing else on the report needs to be changed.

Make sure you test in your test environments first. Update the where clause on the QBR

1. Get a DBA to run an update 
update reportadhoc set whereclause ='<insert new where clause>' where  reportname ='report_name.rptdesign'

2. Export the existing report from Maximo Report Administrator

3. Open in your favorite text editor and update the following property <text-property name="text"> to ensure the query shows correctly at the end of the report 

4. Search for sqlText = 

and update your where clause as you would when developing a birt report. *Pay attention to not remove your extra brackets after the params["where"] and after your where clause

5. Save and import the new report using report administration. 

6. Generate the request page and your done.
Scroll to top