Devart Forums

Hi,

Ran the following query :

select t."Incident ID" "Incident", t."WO Number" "WO", t.OPEN_PERIOD||'W'||t.open_week "PdWk", to_char(t."Open Date",'YYYYMMDD')||' '||t.open_time "Open Date",

-- case
-- when t.description like 'Using default%'
-- then replace(replace(t.description,'-------------------------------------------------'),chr(10),' ')
-- else t.description
-- end "Description",
replace(replace(replace(replace(t.description,'-------------------------------------------------',' '),chr(13)||chr(10),' '),chr(13),' '),chr(10),' ') "Description",

t.item_catalog "Item Catalog", t.resolution "Resolution", t.*
from esp_dev.workorder_report t
-- where open_year = '2007' and open_period = 'P04' and open_week = '4' -- and technology = 'ORACLE' (was example where incident had 'ORACLE' technology, but work order had 'UNIX') and
where "Incident ID" in (
select "Incident Number"
from esp_dev.incident_report
where technology = 'ORACLE' and open_year = '2007' and open_period in ('P09') -- and upper(t.description) like '%SAP%' -- and open_week in ('1','2','3','4')
)
order by 5 --"Incident ID", t."WO Number"

-------------------------------------------------------------
"Output | General" window says :

- 2:32:35 PM -
SQL1.sql: Query opened in 23.273 s [0.282 s exec, 22.991 s fetch]
60 records selected

BUT neither the Data View or Data Window have any data in them !?

We have found the problem and we'll resolve it. The new build will be available in a few days.