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.
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
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.
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.