SQL is not honoured in BIRT from eclipse [message #1783426] |
Tue, 13 March 2018 00:00  |
Eclipse User |
|
|
|
Hi There,
The following SQL from JIRA does not run the same in eclipse:
SELECT
p.name AS "Project",
i.key AS "Issue",
td.name AS "Type",
sd.name AS "Status",
i.assignee AS "Assignee",
i.created AS "Created",
i.summary AS "Summary",
i.reporter AS "Reporter",
i.updated AS "Updated" ,
i.due AS "Due date",
icd.name AS "Custom Field",
icv.value AS "Value"
FROM
issues i
INNER JOIN
projects p ON p.id=i.projectid
INNER JOIN
issuetypedefinitions td ON td.id=i.typeid
INNER JOIN
issuestatusdefinitions sd ON sd.id=i.statusid
INNER JOIN
ISSUECUSTOMFIELDVALUES icv on icv.issueid=i.id
INNER JOIN
ISSUECUSTOMFIELDDEFINITIONS icd on icd.id=icv.customfieldid
WHERE
p.name = 'AU: Australian Health Managment' and
jql='status in (Open,
Resolved) AND assignee in (membersOf("AUS Service Ops Admin")) ORDER BY summary DESC'
The sql results in 23 rows while running the same SQL in a BIRT report in eclipse is just returning 5 rows.
I have exhausted problem determination and as I a new on BIRT/eclipse I would like to ask for some pointer on how to be able to fix this issue.
Thanks.
Marcelo/
|
|
|
|
|
|
Powered by
FUDForum. Page generated in 0.04940 seconds