BIRT report displays "No records to display"

Products

• CA Harvest Software Change Manager

Issue/Introduction

We ran a BIRT report from Eclipse IDE with query

SELECT HARPACKAGE.PACKAGENAME, HARSTATE.STATENAME
FROM HARPACKAGE, HARSTATE
WHERE HARPACKAGE.STATEOBJID = HARSTATE.STATEOBJID
AND HARPACKAGE.ENVOBJID = (SELECT ENVOBJID FROM HARENVIRONMENT WHERE ENVIRONMENTNAME = [project])

and got "No records to display" message

 

Environment

version 14.5, Eclipse IDE 4.31 with Harvest Eclipse plugin

Resolution

Please use this query

SELECT HARPACKAGE.PACKAGENAME, HARSTATE.STATENAME
FROM HARPACKAGE, HARSTATE
WHERE HARPACKAGE.STATEOBJID = HARSTATE.STATEOBJID
AND HARPACKAGE.ENVOBJID = (SELECT ENVOBJID FROM HARENVIRONMENT WHERE ENVOBJID = ${PROJECT_ID}) 

That is, change the syntax for project from [project] to ${PROJECT_ID}

Please note that this query will return the package names and their states for the current project in Eclipse IDE that is integrated and connected to Harvest broker for the BIRT report.