Hi,
I created a BIRT report in Eclipse. I can retrieve data from JIRA through the report while not using input parameters.
Followed the instructions from BIRT https://kintosoft.atlassian.net/wiki/spaces/SFJRC/overview and
changed the SQL to accept an input parameter.
This runs, however, DOES not display the total amount of rows.
By entering this in the report query text:
SELECT
p.name AS "Project",
i.key AS "Issue",
i.created AS "Created",
td.name AS "Type",
sd.name AS "Status",
i.assignee AS "Assignee",
i.created AS "Issue Created",
i.summary AS "Summary",
i.reporter AS "Reporter",
i.updated AS "Updated" ,
i.due AS "Due date",
icf.RESOLUTION_TIME,
icf.response,
icf.notification_TIME,
icf.IMPACT_START_TIME,
ipd.name as priority,
ic.body,
ic.projectroleid,
ic.author AS "Author",
ic.updated AS "comment_date"
FROM
issues i
INNER JOIN
projects p ON p.id=i.projectid
INNER JOIN
ISSUEPRIORITYDEFINITIONS ipd ON ipd.id = i.priorityid
INNER JOIN
issuetypedefinitions td ON td.id=i.typeid
INNER JOIN
issuestatusdefinitions sd ON sd.id=i.statusid
INNER JOIN
issuecustomfields icf ON icf.issueid = i.id
INNER JOIN
issuecomments ic ON ic.issueid = i.id
WHERE p.name=? and
i.jql='status in (Open, Resolved) AND assignee in (membersOf("AUS Service Ops Admin")) ORDER BY summary DESC'
it only retrieves 2 rows (after selecting the input parameters from a list created previously).
However, when I change the WHERE p.name = 'Customer A' and.....
it does retrieves all the customers that satisfies this condition.
This works directly in JIRA, so I know the SQL works well...where to have a look in eclipse to see how the input parameter is set correctly and to find out why this is working? I am lost!
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.