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.
Hi All,
Iam using the query (WHERE status not in('CAN','CLOSE','COMP','APPRCLOSE') and istask = 0 and siteid = 'CLE' and crewid = 'ECAL')to display the work orders in start center under 'Result Set' . The workorders are displaying fine.
For the above query if I added (order by pluscoverduedate), the work orders are displaying in the work order application, but the Work Orders are not displaying in the Start Center 'Result Set'.
Is there any thing wrong in the query, please help me on this.
Thanks
Reddy