Many Maximo applications have a default sort in the tables that displays objects both in the ‘List’ tab and in the details of the objects. Those default order by clauses can be easily changed with the Application Designer.
This technique, used in conjunction with the automatic display of table results, can greatly improve the usability of a Maximo application and speedup the completion of user’s tasks.
For example you may want to show the work orders with nearest Scheduled Start in the Work Order Tracking application.
Open the WOTRACK application in the Application Designer and select main table. Right click on it and select ‘Properties’ to bring up the Control Properties dialog. Type ‘WOPRIORITY’ the Order By field and then select the ‘Start Empty’ checkbox and untick it again.
Close the Control Properties dialog and save the application.
Now open the Work Order Tracking application and you will see that the work orders with the lower priority will be automatically listed.
If you want to reverse the ordering use the DESC keyword. In our example the Order By field will be ‘WOPRIORITY DESC’.
The same technique can also be used to modify the sorting of the tables in the other application tabs.