Histórico da Página

{run:autorun=false|heading=Teste passando parametros|titleRun=Executar|help=http://www.google.com|replace=key::Chave:text,project::Projeto:text,users::Usuários:text,issuestatus::Status:checkbox::1:Open:3:In Progress:5:Resolved}

{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}
|10|2|{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('%JBTRT4ADME%')--nome do projeto
and pv.vname like('%Sprint 29%')--nome da versao
and ji.issuestatus in('$t1'))*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('%JBTRT4ADME%')--nome do projeto
and pv.vname like('%Sprint 29%')
and ji.issuestatus in('1','3','5'){sql-query}|
|50|4|7|
|100|10|8|
{chart}

{beanshell:output=wiki}

print("status selecionados: $issuestatus");
print("chave digitada: $key");
print("projeto digitado: $project");
print("usuarios: $users");

print( "{sql-query:datasource=jiraDS|border=1|table=true|render=true} ");
print( " select ji.* from jiraissue ji, projectversion pv ");
print( " where ji.project = pv.project ");
print( " and pv.vname like('%$key%') ");
if("$issuestatus" != ""){
print( " and ji.issuestatus in($issuestatus) ");
}
print( " and ji.pkey like('%$project%') ");
print( "{sql-query}");

{beanshell}

{run}