Maximo List Archive

This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.



Sorting the report list

From: maximal (2016-01-19 05:47)

I had the bitchiest time trying to solve this, because I looked at the data first before the XML. Dumb dumb dumb. For Actuate 8 and Maximo 6.x, this XML works to control the sort of reports in the dialog:

table label="Reports to Run" id="reportFilesPO_table" mboname="REPORT" whereclause="appname='PO' and runtype<>'QUERY' and norequestpage=0" orderby="description asc" beanclass="psdi.webclient.beans.report.ReportRoxListBean" startrow="0" rowsperpage="5" inputmode="readonly" hidehelp="true">

I also tried adding to the whereclase, but Maximo didn't like the "ORDER BY description" and returned a 933 SQL error. So now I know. And now you know.

Damn that sucked.

-C




From: therron (2016-01-19 07:55)

Not sure if you were asking for help or not, but. . .

Maybe that was a copy-and-paste omission, but you don't have an opening <.

I think the syntax is incorrect at and norequestpage=0'' seems the 0 ought to be enclosed in single quotes.


From: maximal (2016-01-19 10:11)

You have to use orderby="column asc|desc" to sort. The use of an unquoted 0 for a yes/no Boolean is right out of the system XML. I'm hoping they let me bring down the system again.

---In MAXIMO@yahoogroups.com, <therron@pcci.edu> wrote :
Not sure if you were asking for help or not, but. . .
Maybe that was a copy-and-paste omission, but you don't have an opening <.
I think the syntax is incorrect at and norequestpage=0'' seems the 0 ought to be enclosed in single quotes.