{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-body}

{chart:type=bar|title=Burnup de teste|dataOrientation=vertical|subTitle=Acompanhamento da sprint com sql|width=600|height=300|dataDisplay=false|yLabel=Projeto Concluído em %|xLabel=Em dias|3D=true|borderColor=black|colors=yellow,green|thumbnail=true}

|| Dias || Esperado || Pronto ||
| 01 | 6.66 | {sql-query:datasource=jiraDS|table=false|}
select ((select count(*) from jiraissue ji, project p, projectversion pv 
where ji.project =  pv.project
and pv.project = p.id
and p.pkey like('%projeto%')--nome do projeto
and pv.vname like('%sprint%')--nome da versao
and ji.issuestatus in('1'))*6.66/count(*)) as openstatus from jiraissue ji, project p, projectversion pv 
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','3','5')
{sql-query}
 |
| 02 | 13.32 | {sql-query:datasource=jiraDS|table=false|}
select ((select count(*) from jiraissue ji, project p, projectversion pv 
where ji.project =  pv.project
and pv.project = p.id
and p.pkey like('%projeto%')--nome do projeto
and pv.vname like('%sprint%')--nome da versao
and ji.issuestatus in('3'))*13.32/count(*)) as openstatus from jiraissue ji, project p, projectversion pv 
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','3','5')
{sql-query} |
| 03 | 19.98 | {sql-query:datasource=jiraDS|table=false|}
select ((select count(*) from jiraissue ji, project p, projectversion pv 
where ji.project =  pv.project
and pv.project = p.id
and p.pkey like('%projeto%')--nome do projeto
and pv.vname like('%sprint%')--nome da versao
and ji.issuestatus in('3'))*19.98/count(*)) as openstatus from jiraissue ji, project p, projectversion pv 
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','3','5')
{sql-query} |
| 04 | 26.64 | {sql-query:datasource=jiraDS|table=false|}
select ((select count(*) from jiraissue ji, project p, projectversion pv 
where ji.project =  pv.project
and pv.project = p.id
and p.pkey like('%projeto%')--nome do projeto
and pv.vname like('%sprint%')--nome da versao
and ji.issuestatus in('3'))*26.64/count(*)) as openstatus from jiraissue ji, project p, projectversion pv 
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','3','5')
{sql-query} |
| 05 | 33.33 | {sql-query:datasource=jiraDS|table=false|}
select ((select count(*) from jiraissue ji, project p, projectversion pv 
where ji.project =  pv.project
and pv.project = p.id
and p.pkey like('%projeto%')--nome do projeto
and pv.vname like('%sprint%')--nome da versao
and ji.issuestatus in('3'))*33.33/count(*)) as openstatus from jiraissue ji, project p, projectversion pv 
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','3','5')
{sql-query} |
| 06 | 39.96 | {sql-query:datasource=jiraDS|table=false|}
select ((select count(*) from jiraissue ji, project p, projectversion pv 
where ji.project =  pv.project
and pv.project = p.id
and p.pkey like('%projeto%')--nome do projeto
and pv.vname like('%sprint%')--nome da versao
and ji.issuestatus in('3'))*39.96/count(*)) as openstatus from jiraissue ji, project p, projectversion pv 
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','3','5')
{sql-query} |
| 07 | 46.62 | {sql-query:datasource=jiraDS|table=false|}
select ((select count(*) from jiraissue ji, project p, projectversion pv 
where ji.project =  pv.project
and pv.project = p.id
and p.pkey like('%projeto%')--nome do projeto
and pv.vname like('%sprint%')--nome da versao
and ji.issuestatus in('3'))*46.62/count(*)) as openstatus from jiraissue ji, project p, projectversion pv 
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','3','5')
{sql-query} |
| 08 | 53.28 | {sql-query:datasource=jiraDS|table=false|}
select ((select count(*) from jiraissue ji, project p, projectversion pv 
where ji.project =  pv.project
and pv.project = p.id
and p.pkey like('%projeto%')--nome do projeto
and pv.vname like('%sprint%')--nome da versao
and ji.issuestatus in('3'))*53.28/count(*)) as openstatus from jiraissue ji, project p, projectversion pv 
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','3','5')
{sql-query} |
| 09 | 59.94 | {sql-query:datasource=jiraDS|table=false|}
select ((select count(*) from jiraissue ji, project p, projectversion pv 
where ji.project =  pv.project
and pv.project = p.id
and p.pkey like('%projeto%')--nome do projeto
and pv.vname like('%sprint%')--nome da versao
and ji.issuestatus in('3'))*59.94/count(*)) as openstatus from jiraissue ji, project p, projectversion pv 
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','3','5')
{sql-query} |
| 10 | 66.60 | {sql-query:datasource=jiraDS|table=false|}
select ((select count(*) from jiraissue ji, project p, projectversion pv 
where ji.project =  pv.project
and pv.project = p.id
and p.pkey like('%projeto%')--nome do projeto
and pv.vname like('%sprint%')--nome da versao
and ji.issuestatus in('3'))*66.6/count(*)) as openstatus from jiraissue ji, project p, projectversion pv 
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','3','5')
{sql-query} |
| 11 | 73.26 | {sql-query:datasource=jiraDS|table=false|}
select ((select count(*) from jiraissue ji, project p, projectversion pv 
where ji.project =  pv.project
and pv.project = p.id
and p.pkey like('%projeto%')--nome do projeto
and pv.vname like('%sprint%')--nome da versao
and ji.issuestatus in('3'))*73.26/count(*)) as openstatus from jiraissue ji, project p, projectversion pv 
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','3','5')
{sql-query} |
| 12 | 79.92 | {sql-query:datasource=jiraDS|table=false|}
select ((select count(*) from jiraissue ji, project p, projectversion pv 
where ji.project =  pv.project
and pv.project = p.id
and p.pkey like('%projeto%')--nome do projeto
and pv.vname like('%sprint%')--nome da versao
and ji.issuestatus in('5'))*79.92/count(*)) as openstatus from jiraissue ji, project p, projectversion pv 
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','3','5')
{sql-query} |
| 13 | 86.58 | {sql-query:datasource=jiraDS|table=false|}
select ((select count(*) from jiraissue ji, project p, projectversion pv 
where ji.project =  pv.project
and pv.project = p.id
and p.pkey like('%projeto%')--nome do projeto
and pv.vname like('%sprint%')--nome da versao
and ji.issuestatus in('5'))*86.58/count(*)) as openstatus from jiraissue ji, project p, projectversion pv 
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','3','5')
{sql-query} |
| 14 | 93.24 | {sql-query:datasource=jiraDS|table=false|}
select ((select count(*) from jiraissue ji, project p, projectversion pv 
where ji.project =  pv.project
and pv.project = p.id
and p.pkey like('%projeto%')--nome do projeto
and pv.vname like('%sprint%')--nome da versao
and ji.issuestatus in('5'))*93.24/count(*)) as openstatus from jiraissue ji, project p, projectversion pv 
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','3','5')
{sql-query} |
| 15 | 100 | 0 |
{chart}


Eis aqui um exemplo de o que é para acontecer no gráfico com os percentuais de execução em cada dia de uma sprint de 15 dias.

    * primeiro dia deve, mostra o percentual de issues com status 'Open'.
    * segundo dia em diante deve mostrar o percentual de issues com status 'InProgress' até 70% do projeto.
    * entre 70% e 95% mostra o percentual de issues com status 'Resolved' até 95%.

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

Teste passando apenas um sql.

{run:autorun=true|heading=Heading text|prompt=Prompt text|titleRun=Submit|help=@self|
replace=
r1:choice value 2:Radio button horizontal:radio::choice value 1:choice text 1:choice value 2:choice text 2:choice value 3:choice text 3,
r2:choice value 1:Radio button vertical:radio:-1:choice value 1:choice text 1:choice value 2:choice text 2:choice value 3:choice text 3,
r3:choice value 1:Radio button 2 rows:radio:2:choice value 1:choice text 1:choice value 2:choice text 2:choice value 3:choice text 3:choice value 4:choice text 4,
r4:15:Radio button 5 per line:radio:-5:1::2::3::4::5::6::7::8::9::10:11::12::13::14::15::16::17::18::19,
c1:choice value 3:Checkbox horizontal:checkbox::choice value 1:choice text 1:choice value 2:choice text 2:choice value 3:choice text 3,
c2:'choice value 3,choice value 1':Checkbox vertical:checkbox:-1:choice value 1:choice text 1:choice value 2:choice text 2:choice value 3:choice text 3,
s1:choice value 2:Select:select::choice value 1:choice text 1:choice value 2:choice text 2:choice value 3:choice text 3,
s2:'3,4':Select multiple:select-multi::1::2::3::4::5::6::7::8::9::10:11::12::13::14::15::16::17::18::19,
t1:text value:Text,
a1:5 lines (default):Text area:textarea,
a2:'3 lines':Text area:textarea:3,
i1:0:Integer:integer-required:0:2000,
f1:-3.55:Float:float,
d1:2010.01.01:Date:date:::yyyy.MM.dd,
o1:Output text:Output only:output,
h1:hidden value:Hidden description:hidden}


{sql:datasource=jiraDS|table=true|}
select ji.* from jiraissue ji, projectversion pv
where ji.project = pv.project
and pv.vname like('%Sprint 29%')
and ji.issuestatus in('3')
and ji.pkey like('%JBTRT4ADME%')
{sql}

{run}