3layer - 3PUP
Árvore de páginas

Atualização Necessária

Todo o conteúdo deste espaço carece de atualização e, embora tenha validade nas suas intenções, as informações existentes podem ter divergências quanto à realidade atualizada, pois tratam-se de materiais bastante antigos (alguns com mais de 5 anos de existência) e que sofreram adaptações e evoluções ao longo dos anos, sem terem sido atualizados aqui.
Assim, pede-se ao leitor evitar de tomar decisões com base apenas no material aqui existente.

Skip to end of metadata
Go to start of metadata

Você está vendo a versão antiga da página. Ver a versão atual.

Comparar com o atual Ver Histórico da Página

« Anterior Versão 109 Próxima »

Unknown macro: {replace-and-render}

//projeto

Unknown macro: {replace-item} JBTRT4ADME

//sprint

Unknown macro: {replace-item} Sprint 28

//data inicial

Unknown macro: {replace-item}

//data final

Unknown macro: {replace-item}

//usuario que trabalhou

Unknown macro: {replace-item} marcelo.mariano
Unknown macro: {replace-body}
chart: Erro durante a conversão de wiki markup para o formato de armazenamento.

Dias

Esperado

Pronto

01

6.66

Unknown macro: {sql-query}

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')

02

13.32

Unknown macro: {sql-query}

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')

03

19.98

Unknown macro: {sql-query}

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')

04

26.64

Unknown macro: {sql-query}

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')

05

33.33

Unknown macro: {sql-query}

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')

06

39.96

Unknown macro: {sql-query}

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')

07

46.62

Unknown macro: {sql-query}

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')

08

53.28

Unknown macro: {sql-query}

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')

09

59.94

Unknown macro: {sql-query}

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')

10

66.60

Unknown macro: {sql-query}

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')

11

73.26

Unknown macro: {sql-query}

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')

12

79.92

Unknown macro: {sql-query}

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')

13

86.58

Unknown macro: {sql-query}

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')

14

93.24

Unknown macro: {sql-query}

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')

15

100

0

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%.

Teste passando apenas um sql.

  • Sem rótulos