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.

Adding Failure Codes Cause and Remedy field to Maximos Advanced Search

https://www-01.ibm.com/support/docview.wss?uid=swg21611218

So this is not something that is setup OOB for Maximo but will be extremely useful if you are using failure codes (Problem/Cause/Remedy). Problem already exists OOB in Maximo but for some reason cause/remedy where not. Follow the steps in the link above to implement this into your system.

To summarize what needs to happen

  1. You will be creating two new relationships on the workorder table. That will link back to failurereport table. One for Cause and one for Remedy.
  2. You will create two new lookups in the lookups.xml for your system that will be used in your advanced search dialog (searchmore)
  3. You will update your application wotrack or plusgwo (or your equivalent industry solution module) advanced search dialog to use the new relationship and lookup.

It’s a fairly simple change and you shouldn’t need to take the server down or move it into admin mode. Remember follow your change management rules.

Posts navigation

1 2 3
Scroll to top