Hi,
The auditors requested a report to list items changed since a specified date. I've set up a BIRT report as follows:
SELECT
HP.packagename,
HPFN.pathfullname,
HI.itemname,
HI.modifiedtime
FROM
haritems HI
INNER JOIN harversions HV ON HI.itemobjid = HV.itemobjid
INNER JOIN harpathfullname HPFN ON HI.parentobjid = HPFN.itemobjid
INNER JOIN harpackage HP ON HV.packageobjid = HP.packageobjid
WHERE
HV.packageobjid IN (
SELECT
packageobjid
FROM
harpackage
WHERE
envobjid = ${PROJECT_ID}
AND stateobjid = ${STATE_ID}
)
AND HI.modifiedtime >= '01-apr-2023'
GROUP BY
HP.packagename,
HPFN.pathfullname,
HI.itemname,
HI.modifiedtime
ORDER BY
HP.packagename,
HPFN.pathfullname,
HI.itemname
The report runs, but completely ignores my AND HI.modifiedtime >= '01-apr-2023'
clause and returns all items. When I run the query in SQL Developer it returns the correct results. Am I missing something?
Regards,
Jarus
------------------------------
Jarus Bosman
Senior Software Developer
State Information Technology Agency
South Africa
------------------------------