you can write a query in the application and save it for later use. you can try running the query in the sql database and write the where part in maximo and save the query.
Many thanks for your rapid reply, unfortunately not being an expert programmer I'm unsure what the correct process of writing the query is.
I've put 'PROJECTS' in the description & saved the query, then when I've edited the saved query I've changed the 'and' to 'not' and also '!' but this just gives a blank report?
Is there something obvious I'm missing??
This is the query WITH the 'PROJECTS' in:
(((status like '%INPRG%' or status like '%WMATL%' or status like '%QUOTEREQ%') and (woclass = 'WORKORDER' or woclass = 'ACTIVITY') and historyflag = 0 and istask = 0 and siteid = 'GSHUK' and (location like '%111166%' or location like '%111168%' or location like '%111169%' or location like '%111194%' or location like '%111195%' or location like '%111196%' or location like '%112393%' or location like '%112375%' or location like '%112390%' or location like '%111060%' or location like '%111069%' or location like '%111062%' or location like '%111065%')) and (exists (select orgid from maximo.plusppricesched where (((gshworktype like '%CM%' or gshworktype like '%QW%'))) and (agreement = workorder.pluspagreement and priceschedule = workorder.plusppricesched and revisionnum =workorder.plusprevnum and orgid = workorder.orgid))))
and (( contains(description,' $gsh & $projects ') > 0 ))Thanks for your patience.
MIB
