I am using BIRT to write reports for IBM's Maximo 7 software.<br />
<br />
I am using the following SQL query for a report:<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
select
dbo.workorder.wonum,
dbo.workorder.description,
dbo.workorder.worktype,
dbo.workorder.status,
dbo.workorder.wopriority,
dbo.workorder.location,
dbo.workorder.actfinish,
dbo.workorder.reportdate,
dbo.workorder.failurecode,
dbo.workorder.wo3,
fc.description,
locs.description
from
dbo.workorder
--Bring in Description of Failure Class:
left outer join dbo.failurecode as fc on dbo.workorder.failurecode=fc.failurecode
--Bring in Address of Loaction:
left outer join dbo.locations as locs on dbo.workorder.location=locs.location
where
dbo.workorder.status='COMP'
and
dbo.workorder.actfinish >= ?
and
dbo.workorder.actfinish <= ?
and
dbo.workorder.location like ?
</pre>
<br />
The first to parameters work fine (start and end date). But the last parameter is giving me a headache.<br />
<br />
The way Maximo creates work orders is ABC-012345 where ABC is the location and 012345 is the actual work order number, however these are not stored in separate locations. So the last parameter works if I replace the line with:<br />
"dbo.workorder.location like 'ABC%' "<br />
but if I use any of these:<br />
"dbo.workorder.location like ? "<br />
"dbo.workorder.location like '?' "<br />
"dbo.workorder.location like '?%' "<br />
or anything similar (I swear I've tried them all), it does not return any results when the user enters "ABC%" in the parameter menu when running the report<br />
<br />
Any and all help would be greatly appreciated!
