SQL is not honoured in BIRT from eclipse [message #1783426] |
Tue, 13 March 2018 04:00 |
Marcelo Sanchez Messages: 3 Registered: March 2018 |
Junior Member |
|
|
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/
|
|
|
Re: SQL is not honoured in BIRT from eclipse [message #1783530 is a reply to message #1783426] |
Tue, 13 March 2018 19:48 |
|
Your problem is that the query generated by JIRA is NOT the query you need to send to the database. JIRA uses that "jql" piece to modify the base query using JIRA-internal functionality. You will need to find out what the "membersOf" function does - probably a lookup into user name groups, and write your own equivalent of "status in (Open, Resolved)"
|
|
|
|
|
Powered by
FUDForum. Page generated in 0.02555 seconds