IBM Support

Setting an Order By Clause for a Maximo Application

Question & Answer


The purpose of this document is to provide steps on setting up an Order By clause on Maximo application records in App Designer.


The following steps will help you set up an Order By clause in App Designer that will order the records returned in a Maximo application.

Launch App Designer.
Select an application such as WOTRACK.
Highlight the table that appears on the List tab by selecting the table header label in this case Work Orders so that the table highlights in green.
Select Control Properties.
In the Order By property enter an attribute value to sort by such as: STATUS
Out of the box this is set to WONUM.
You can set the order to descending by entering DESC after the attribute selected to sort by, for example WONUM DESC

[{"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Business Unit":{"code":"BU055","label":"Cognitive Applications"},"Component":"Appl Designer","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"6.1;6.2;6.2.1;6.2.2;6.2.3;6.2.4;6.2.5;6.2.6;6.2.7;6.2.8;7.1;7.1.1;7.5;7.6","Edition":"","Line of Business":{"code":"LOB02","label":"AI Applications"}},{"Product":{"code":"SSLKTY","label":"Maximo Asset Management for IT"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":null,"Platform":[{"code":"","label":"All"}],"Version":"","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}},{"Product":{"code":"SSWK4A","label":"Maximo Asset Management Essentials"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":null,"Platform":[{"code":"","label":"All"}],"Version":"","Edition":"","Line of Business":{"code":"LOB02","label":"AI Applications"}}]

Document Information

Modified date:
17 June 2018