Histórico da Página

{replace-and-render}

//projeto
{replace-item:%projeto%}JBTRT4ADME{replace-item}

//sprint
{replace-item:%versao%%sprint%}Sprint 28{replace-item}

//data inicial
{replace-item}{replace-item}

//data final
{replace-item}{replace-item}

//usuario que trabalhou
{replace-item}marcelo.mariano{replace-item}

{replace-body}

{chart:type=line|title=Burnup de teste com sql|dataOrientation=vertical|width=500600|height=300|dateFormat=dd.mm|dataDisplay=false|3D=false|colors=green,blue}

|| Data || PlanejadoProcesso (VP) || Entregue (VA) ||
| 1600.0900 | 10 | 20 |
| 1705.0900 | 470 | 350 |
| 1870.0900 | 595 | 850 |
| 2195.0900 | 695 | 850 |
| 22100.0900 | 10100 | 1150 |
{chart}
| 23.09 | 11 | 12 |
| 24.09 | 14 | 12 |
| 25.09 | 14 | 13 |
| 28.09 | 14 | 14 |
| 29.09 | 15 | 15 |
| 30.09 | 18 | 15 |
| 01.10 | 18 | 15 |
| 02.10 | 18 | 17 |
{chart

{sql-query:datasource=jiraDS|table=false|}
select count(*) from jiraissue
{sql-query}

{sql-query:datasource=jiraDS|table=false|}
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%'
{sql-query}

{sql-query:datasource=jiraDS|table=false|output=html|endRow=</li>|}
select v.description '<li>'||  issue.summary  from projectversion v inner join project p on v.project = p, 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 pissue.pkey like '%projeto%%JBTRT4ADME-%' and v.vname like= '%versao%'
and cf.cfname = 'Parte da Meta' and cf.id = cv.customfield and cv.issue = issue.id and cv.stringvalue = 'Sim'
{sql-query}

{replace-body}
{replace-and-render}