|SQL is not honoured in BIRT from eclipse [message #1783426]
||Tue, 13 March 2018 04:00
| Marcelo Sanchez
Registered: March 2018
The following SQL from JIRA does not run the same in eclipse:
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"
projects p ON p.id=i.projectid
issuetypedefinitions td ON td.id=i.typeid
issuestatusdefinitions sd ON sd.id=i.statusid
ISSUECUSTOMFIELDVALUES icv on icv.issueid=i.id
ISSUECUSTOMFIELDDEFINITIONS icd on icd.id=icv.customfieldid
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.
Powered by FUDForum
. Page generated in 0.02571 seconds