Teste Burnup

select count(ji.*) as total from jiraissue ji, project p, projectversion pv --count = 350
where ji.project = pv.project
and pv.project = p.id
and p.pkey like('%JBTRT4ADME%')--nome do projeto
and pv.vname like('%Sprint 29%')
and ji.issuestatus in('1','3','5')

select count from jiraissue

select v.description from projectversion v inner join project p on v.project = p.id and p.pkey like '%projeto%' and v.vname like '%sprint%'

<ul>

select '<li>'|| issue.summary from projectversion v, nodeassociation n, jiraissue issue, customfield cf, customfieldvalue cv where
n.source_node_entity='Issue' and n.sink_node_entity='Version' and
n.association_type='IssueFixVersion' and n.sink_node_id =
v.id and n.source_node_id = issue.id and issue.pkey like '%JBTRT4ADME-%' and v.vname = '%versao%'
and cf.cfname = 'Parte da Meta' and cf.id = cv.customfield and cv.issue = issue.id and cv.stringvalue = 'Sim'

<ul>