BIRT Item audit report

[Jarus Bosman]

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
------------------------------

[Jarus Bosman]

Hi guys, please ignore. I found my problem: I should be using harversions.modifiedtime.

------------------------------
Jarus Bosman
Senior Software Developer
State Information Technology Agency
South Africa
------------------------------