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">
Is there a way to use orderby in a URL? Is there an event argument and what is the proper syntax? I am using sqlwhere to query a data set but I can't simply append "order by reportdate desc" at the end of the where clause. Please help!
ReplyDeletedid you try sub query in additionaleventvalue like this???
Deletehttp://localhost/maximo/ui/maximo.jsp?event=loadapp&value=wotrack&additionalevent=sqlwhere&additionaleventvalue=status=%27APPR%27%20and%20wonum%20in%20(select%20wonum%20from%20workorder%20order%20by%201)
Yes, and it puts it in the where clause; however, no results display and when I go into where clause, and copy and paste the exact text it, it then displays properly. This has led me to believe there is an event that handles sorting.
Delete