Histórico da Página

{replace-and-render}

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

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

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

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

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

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

{replace-body}

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

|| DataDias || Processo (VP)Esperado || Entregue (VA)Pronto ||
| 00.0001 | 06.66 | 03 |
| 05.0002 | 7013.32 | 504 |
| 70.0003 | 9519.98 | 50 |
| 95.0004 | 9526.64 | 50 |
| 100.0005 | 10033.33 | 50 |
{chart}

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

|| Data || Processo (VP) || Entregue (VA) ||
| 0 | 0 | {sql-query:datasource=jiraDS|table=false|}select count(ji.*) from jiraissue ji, project p, projectversion pv --count = 350
where ji.project =  pv.project
and pv.project = p.id
and p.pkey like('%projeto%')--nome do projeto
and pv.vname like('%sprint%')
and ji.issuestatus in('1','5'){sql-query} |
| 05.00 | 70| 50 |
| 07 | 46.62 | 50 |
| 08 | 53.28 | 50 |
| 09 | 59.94 | 50 |
| 10 | 66.60 | 50 |
| 11 | 73.26 | 50 |
| 12 | 79.92 | 50 |
| 70.0013 | 9586.58 | 50 |
| 95.0014 | 9593.24 | 50 |
| 100.0015 | 100 | 50%totalissues% |
{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}

{html}
<ul>
{html}
{sql-query:datasource=jiraDS|table=false|output=html|endRow=</li>|}
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'
{sql-query}
{html}
<ul>
{html}

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