IBM Support

The listing of records in Work Order Tracking is not restricted by the Clause in the View/Manage Queries in Maximo 7.5.x

Troubleshooting


Problem

The retrieval of records in the Maximo Work Order Tracking Application is returning all records when it should be using the Select Statement where clause to reduce the amount of records returned.

This was working correctly in Maximo 7.5.0.5 or earlier, and after upgrading to Maximo 7.5.0.11 it is no longer working.

Symptom

In the Work Order Tracking Application, when pressing return to list the records, all records are returned, when the expectation is that a smaller subset is displayed as Specified in the View/Manage Queries.

Cause

This is a code defect, and has been corrected from Maximo 7.5.0.11. 

However, environments that upgrade from earlier versions, might not benefit from the code improvement.

Environment

This will affect upgraded Maximo 7.5.0.11 environments that have been upgraded from Maximo 7.5.0.5 or earlier.  It will not impact new installations of Maximo 7.5.0.11.

Diagnosing The Problem

Go to -> Work Order Tracking -> Select Save Query -> View/Manage Queries

Notice that for the queries available, the Clause Field is populated and displayed.

This is the expected behaviour.

Resolving The Problem

This is a known issue, and was fixed in Maximo 7.5.0.11.

However, when upgrading a Maximo 7.5.0.5 or earlier, the issue does not get resolved because the library.xml used to resolve the issue, is from the original install of 7.5.0.5.

Lets look at the library.xml files from both scenarios:

The original 7.5.0.11 wotrack library.xml contains:

<tabledetails id="searchvmqr_tabledtails" sigoption="BMXVIEWMANAGEWHER" sigoptiondatasrc="MAINRECORD">

However it should only contain:

<tabledetails id="searchvmqr_tabledtails" sigoption="BMXVIEWMANAGEWHER">

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"Maximo 7.5.0.5 or earlier","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
16 August 2018

UID

ibm10728075