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 8 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-item}

select cast((count/(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('1')))as float) 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')

Unknown macro: {replace-item}
Unknown macro: {sql-query}

select cast((count/(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('3')))as float) 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')

Unknown macro: {replace-item}
Unknown macro: {sql-query}

select cast((count/(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('5')))as float) 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')

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'))*5/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'))*70/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'))*70/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'))*70/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'))*70/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'))*70/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'))*70/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'))*70/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'))*70/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'))*70/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'))*70/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'))*70/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'))*70/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'))*70/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

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'))*70/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')
Unknown macro: {sql-query}

select count from jiraissue

Unknown macro: {sql-query}

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

Unknown macro: {html}

<ul>

Unknown macro: {sql-query}

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'

Unknown macro: {html}

<ul>

  • Sem rótulos