Showing posts with label orderby. Show all posts
Showing posts with label orderby. Show all posts

Monday, 8 May 2017

Sort out of the box lookups using ORDERBY by using LOOKUP.XML - IBM Maximo

1. Open LOOKUP.XML in your favorite editor, mine is Notepad++ and find html tag looks like this:

<table id="worktype" inputmode="readonly" selectmode="single"
2. append this line and add where clause, and it will become like this:
<table id="worktype" inputmode="readonly" selectmode="single" orderby=" REPORTDATE desc">