Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

SQL does not honours input parameter from BIRT Reports

Marcelo Sanchez March 13, 2018

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!

 

0 answers

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events