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.
#Maximo
#AssetandFacilitiesManagement

Original Message:
Sent: Sat November 21, 2020 05:46 PM
From: User1971
Subject: What parts of Maximo honor ORDER BY in the WHERE clause?

Maximo 7.6.1.2; Oracle 12c

I can use the ORDER BY clause in WHERE clause textboxes 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.
#Maximo
#AssetandFacilitiesManagement