This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.
Hi,
I want to achieve custom sort to a query, that will say not asc or desc.
I have tried following clauses to build the query. Both are valid and run eg. In Oracle SQL developer but as a query in Maximo they don't work. They don't give any errors but they do not sort either:
1)
ownergroup='TIER1' and internalpriority < 4 ORDER BY (case when status='QUEUED' then 0 when status = 'INPROG' then 1 when status = 'PENDING' then 2 else 3 end) asc
2)
ownergroup='TIER1' and internalpriority < 4 ORDER BY DECODE(status, 'QUEUED', 1, 'INPROG', 2, 'PENDING', 3) asc NULLS LAST
--> has anyone done this and found a working solution?
The queries would be used in the start center
Regards,
Mikael Lahtonen
What version of Maximo? Can you also post the entire SQL query you tested in Oracle?