Category Archives: Maximo-5

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 →