Maximo

Maximo-ICON.png

Maximo

Learn how to increase the operational efficiency of the assets you manage, and improve overall equipment effectiveness by using IoT data and AI.

Maximo-ICON.png

TRIRIGA

Reduce the operational costs of the facilities you manage, and create more engaging occupant experiences through the application of IoT data and AI.

Maximo-ICON.png

Engineering

Learn how IoT data and AI are being applied to transform the end-to-end engineering lifecycle.

Expand all | Collapse all

What parts of Maximo honor ORDER BY in the WHERE clause?

  • 1.  What parts of Maximo honor ORDER BY in the WHERE clause?

    Posted 8 days ago
    Edited by User1971 7 days ago
    Maximo 7.6.1.2; Oracle 12c

    I can use the ORDER BY clause in WHERE clauses in Maximo.
    However, just because I can type ORDER BY into a WHERE clause textbox, it doesn't mean Maximo will always honor it.

    Examples:

    Yes, ORDER BY is honored:
    1. List view WHERE clause (example: order by coalesce(parent,wonum) is handy)
    2. Exporting the list view to Excel
    3. Saved queries

    ORDER BY is not honored:
    4. Ad-hoc reports

    Is there anywhere else in Maximo where ORDER BY in the WHERE clause is honored?

    Cheers.


  • 2.  RE: What parts of Maximo honor ORDER BY in the WHERE clause?

    Posted 7 days ago