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.
It is possible to do a "word search" on a COMM LOG message by doing a nested select...from WOTRACK application.
The trick is to join on the WORKORDERID to commlog.OWNERID
... WHERE WORKORDERID IN (SELECT OWNERID FROM COMMLOG WHERE OWNERTABLE='WORKORDER' and upper(MESSAGE) like `%23/08/12%')
Also, if you add this field to the advanced search screen, it would be based on a database relationship, similar to above join and thus easier for users.
The relationship will basically give you the same SQL statement when clicking find from the advanced search as if you went to the where clause with a nested select.
w/br
John Reeve
Manager, Practice Leader Maintenance and Reliability Solutions
Cell: 423 314 1312
http://www.linkedin.com/pub/john-reeve/11/644/9b2