Troubleshooting
Problem
STEPS TO REPRODUCE:
1. Go to Application Designer, and export the XML view for the PM application.
2. Add the data attribute "lastcompdate" to the List tab in the XML file.
You will find the modified XML attached (pm.xml).
The XML part added is : <tablecol dataattribute="lastcompdate" id="results_showlist_tablebody_13"/>
3. Import the modified XML file. This will change the PM application so that the LASTCOMPDATE attribute is shown.
4. In Oracle database, change the LASTCOMPDATE of PM '1018' to 5 AM : update pm set lastcompdate = trunc(lastcompdate) + 5/24 where pmnum='1018'; commit;
5. In Maximo, go to the PM application. Filter the table with PMNUM = 1018 and LASTCOMPDATE = 18.06.10.
RESULT:
No results are shown
EXPECTED RESULTS:
PM 1018 should be displayed in the result Note 1: If you filter the table only with PMNUM = 1018 : A result is shown with LASTCOMPDATE having 18.06.10
Environment
TPAE 7611
Resolving The Problem
The lastcompdate attribute is of maxtype DATE and it has no time component (the time defaults to midnight). The reason why you see midnight in the database is because SQL only has datetime type. So all maxtype date attributes default to midnight in the database.
Maximo does not support the use case as described. This is because the lastcompdate can not be updated from the UI, so updating from the database is not supported and will not give you the results you are looking for.
There is no configuration that can help in the case of LASTCOMPDATE as it is maxtype DATE not DATETIME. Their best option is to use a custom query
Document Location
Worldwide
[{"Line of Business":{"code":"LOB59","label":"Sustainability Software"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"ARM Category":[{"code":"a8m50000000CbP6AAK","label":"System Administration"}],"ARM Case Number":"TS004087741","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Version(s)"}]
Was this topic helpful?
Document Information
Modified date:
22 September 2020
UID
ibm16335687