Category Archives: Maximo-7

Information specific to Maximo 7.1 or 7.5

Maximo Hierarchies Report

Posted on 2014-01-22 by QASuper

I went through several options on making Location Hierarchy Reports, and found these queries to be quite beneficial. The code is different, depending on the backend being Oracle or Microsoft. Oracle select level, lpad (‘ ‘, 8 * (level – … Continue reading →

Posted in Maximo, Maximo-5, Maximo-6, Maximo-7, Oracle, SQL, SQL Server (M$) | Comments Off on Maximo Hierarchies Report