IBM Support

Setting an Order By Clause for a Maximo Application

Question & Answer


Question

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

Answer

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.


Steps:
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
Save.

[{"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

UID

swg21318054