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,
I built a query in SR application, to find the SR's(ticketid)having work orders. Due to some reasons I am not able to get the SR's, please check the query and let me know what is wrong with the query. Any help is appreciated.
where ticketid in (select distinct a.ticketid from relatedrecord a where a.relatedrecwonum is not null)
Thanks
Reddy