Maximo

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 Sat November 21, 2020 05:46 PM
    Edited by User1971 Mon November 23, 2020 06:44 AM
    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 Mon November 23, 2020 06:44 AM