Visão geral
Este comando listará os dados da atividade, no menu Backlog (KN011), na aba detalhes da atividade.
Tabelas relacionadas
TABELA
|
Descrição
|
Chave primária (PK)
|
Tabelas de ligação
|
TSTASK
|
Armazena a atividade do SE Kanban
|
CDTASK
|
ADUSER
TSTASKTYPE
TSPRIORITY
TSWORKSPACE
TSSTEP
SERICHTEXT
TSSPRINT
|
ADUSER
|
Armazena os usuários do sistema
|
CDUSER
|
TSTASK
|
TSTASKTYPE
|
Armazena o tipo de atividades do SE Kanban
|
CDTASKTYPE
|
TSTASK
|
TSPRIORITY
|
Armazena a prioridade do SE Kanban
|
CDPRIORITY
|
TSTASK
|
TSWORKSPACE
|
Armazena o workspace do SE Kanban
|
CDWORKSPACE
|
TSTASK
TSSPRINT
|
TSSTEP
|
Armazena os passos do fluxograma do SE Kanban
|
CDSTEP
|
TSTASK
|
SERICHTEXT
|
Tabela que guarda os dados de richtext do sistema
|
OID
|
TSTASK
|
SETEXT
|
Tabela utilizada para salvar conteúdos grandes em forma de texto, como imagens etc
|
OID
|
SERICHTEXT
|
TSSPRINT
|
Armazena a sprint do SE Kanban
|
CDSPRINT
|
TSTASK
TSWORKSPACE
|
Oracle
SELECT
WKS.NMWORKSPACE,
WKS.NMPREFIX || '-' || CAST(TSTSK.NRTASK AS VARCHAR(255)) AS IDENTIFIER,
STEP.NMSTEP AS NMSTEP,
TSTSK.NMTITLE,
TYPE.NMTASKTYPE,
(
SELECT
MIN(CHKTSK.NMTITLE)
FROM
TSINITIATIVESTRUCT TSSTRUCT
INNER JOIN TSTASK CHKTSK ON (CHKTSK.CDTASK = TSSTRUCT.CDOWNER)
WHERE
TSSTRUCT.CDTASK = TSTSK.CDTASK
) INITIATIVETITLE,
PRIORITY.NMPRIORITY,
TSSPT.NMTITLE AS NMSPRINT,
TSTSK.VLESTIMATE,
TSTSK.DTSTARTPLAN,
TSTSK.DTDEADLINE,
REPORTER.NMUSER NMREPORTER,
ASSIGNEE.NMUSER NMASSIGNEE,
SEDESC.TXDATA AS DESCRIPTION
FROM
TSTASK TSTSK
INNER JOIN ADUSER CREATEDBY ON ( TSTSK.CDCREATEDBY = CREATEDBY.CDUSER )
INNER JOIN ADUSER REPORTER ON ( TSTSK.CDREPORTER = REPORTER.CDUSER )
LEFT JOIN ADUSER ASSIGNEE ON ( TSTSK.CDASSIGNEE = ASSIGNEE.CDUSER )
INNER JOIN TSTASKTYPE TYPE ON ( TSTSK.CDTASKTYPE = TYPE.CDTASKTYPE )
INNER JOIN TSPRIORITY PRIORITY ON ( TSTSK.CDPRIORITY = PRIORITY.CDPRIORITY )
INNER JOIN TSWORKSPACE WKS ON ( TSTSK.CDWORKSPACE = WKS.CDWORKSPACE )
INNER JOIN TSSTEP STEP ON ( TSTSK.CDSTEP = STEP.CDSTEP )
LEFT JOIN SERICHTEXT SERICHDESC ON ( TSTSK.OIDDESCRIPTION = SERICHDESC.OID )
LEFT JOIN SETEXT SEDESC ON ( SERICHDESC.OIDTEXTCONTENT = SEDESC.OID )
LEFT JOIN TSSPRINT TSSPT ON ( TSTSK.CDSPRINT = TSSPT.CDSPRINT AND WKS.FGMETHODOLOGY = 2 )
WHERE
WKS.NMPREFIX || '-' || CAST(TSTSK.NRTASK AS VARCHAR(255)) = 'IDENTIFICADOR_DA_ATIVIDADE' /*OBS 1*/
ORDER BY TSTSK.NRTASK ASC
|
Postgres
SELECT
WKS.NMWORKSPACE,
WKS.NMPREFIX || '-' || CAST(TSTSK.NRTASK AS VARCHAR(255)) AS IDENTIFIER,
STEP.NMSTEP AS NMSTEP,
TSTSK.NMTITLE,
TYPE.NMTASKTYPE,
(
SELECT
MIN(CHKTSK.NMTITLE)
FROM
TSINITIATIVESTRUCT TSSTRUCT
INNER JOIN TSTASK CHKTSK ON (CHKTSK.CDTASK = TSSTRUCT.CDOWNER)
WHERE
TSSTRUCT.CDTASK = TSTSK.CDTASK
) INITIATIVETITLE,
PRIORITY.NMPRIORITY,
TSSPT.NMTITLE AS NMSPRINT,
TSTSK.VLESTIMATE,
TSTSK.DTSTARTPLAN,
TSTSK.DTDEADLINE,
REPORTER.NMUSER NMREPORTER,
ASSIGNEE.NMUSER NMASSIGNEE,
SEDESC.TXDATA AS DESCRIPTION
FROM
TSTASK TSTSK
INNER JOIN ADUSER CREATEDBY ON ( TSTSK.CDCREATEDBY = CREATEDBY.CDUSER )
INNER JOIN ADUSER REPORTER ON ( TSTSK.CDREPORTER = REPORTER.CDUSER )
LEFT JOIN ADUSER ASSIGNEE ON ( TSTSK.CDASSIGNEE = ASSIGNEE.CDUSER )
INNER JOIN TSTASKTYPE TYPE ON ( TSTSK.CDTASKTYPE = TYPE.CDTASKTYPE )
INNER JOIN TSPRIORITY PRIORITY ON ( TSTSK.CDPRIORITY = PRIORITY.CDPRIORITY )
INNER JOIN TSWORKSPACE WKS ON ( TSTSK.CDWORKSPACE = WKS.CDWORKSPACE )
INNER JOIN TSSTEP STEP ON ( TSTSK.CDSTEP = STEP.CDSTEP )
LEFT JOIN SERICHTEXT SERICHDESC ON ( TSTSK.OIDDESCRIPTION = SERICHDESC.OID )
LEFT JOIN SETEXT SEDESC ON ( SERICHDESC.OIDTEXTCONTENT = SEDESC.OID )
LEFT JOIN TSSPRINT TSSPT ON ( TSTSK.CDSPRINT = TSSPT.CDSPRINT AND WKS.FGMETHODOLOGY = 2 )
WHERE
WKS.NMPREFIX || '-' || CAST(TSTSK.NRTASK AS VARCHAR(255)) = 'IDENTIFICADOR_DA_ATIVIDADE' /*OBS 1*/
ORDER BY TSTSK.NRTASK ASC
|
SQL Server
SELECT
WKS.NMWORKSPACE,
WKS.NMPREFIX + '-' + CAST(TSTSK.NRTASK AS VARCHAR(255)) AS IDENTIFIER,
STEP.NMSTEP AS NMSTEP,
TSTSK.NMTITLE,
TYPE.NMTASKTYPE,
(
SELECT
MIN(CHKTSK.NMTITLE)
FROM
TSINITIATIVESTRUCT TSSTRUCT
INNER JOIN TSTASK CHKTSK ON (CHKTSK.CDTASK = TSSTRUCT.CDOWNER)
WHERE
TSSTRUCT.CDTASK = TSTSK.CDTASK
) INITIATIVETITLE,
PRIORITY.NMPRIORITY,
TSSPT.NMTITLE AS NMSPRINT,
TSTSK.VLESTIMATE,
TSTSK.DTSTARTPLAN,
TSTSK.DTDEADLINE,
REPORTER.NMUSER NMREPORTER,
ASSIGNEE.NMUSER NMASSIGNEE,
SEDESC.TXDATA AS DESCRIPTION
FROM
TSTASK TSTSK
INNER JOIN ADUSER CREATEDBY ON ( TSTSK.CDCREATEDBY = CREATEDBY.CDUSER )
INNER JOIN ADUSER REPORTER ON ( TSTSK.CDREPORTER = REPORTER.CDUSER )
LEFT JOIN ADUSER ASSIGNEE ON ( TSTSK.CDASSIGNEE = ASSIGNEE.CDUSER )
INNER JOIN TSTASKTYPE TYPE ON ( TSTSK.CDTASKTYPE = TYPE.CDTASKTYPE )
INNER JOIN TSPRIORITY PRIORITY ON ( TSTSK.CDPRIORITY = PRIORITY.CDPRIORITY )
INNER JOIN TSWORKSPACE WKS ON ( TSTSK.CDWORKSPACE = WKS.CDWORKSPACE )
INNER JOIN TSSTEP STEP ON ( TSTSK.CDSTEP = STEP.CDSTEP )
LEFT JOIN SERICHTEXT SERICHDESC ON ( TSTSK.OIDDESCRIPTION = SERICHDESC.OID )
LEFT JOIN SETEXT SEDESC ON ( SERICHDESC.OIDTEXTCONTENT = SEDESC.OID )
LEFT JOIN TSSPRINT TSSPT ON ( TSTSK.CDSPRINT = TSSPT.CDSPRINT AND WKS.FGMETHODOLOGY = 2 )
WHERE
WKS.NMPREFIX + '-' + CAST(TSTSK.NRTASK AS VARCHAR(255)) = 'IDENTIFICADOR_DA_ATIVIDADE' /*OBS 1*/
ORDER BY TSTSK.NRTASK ASC
|
Observações
▪1: Identificador da atividade a ser filtrada.
Campos utilizados na consulta
Nº
|
ID do campo
|
Tipo
|
Observação
|
1
|
NMWORKSPACE
|
VARCHAR(255)
|
Nome do workspace
|
2
|
IDENTIFIER
|
VARCHAR(255)
|
Identificador da atividade
|
3
|
NMSTEP
|
VARCHAR(255)
|
Nome da etapa
|
4
|
NMTITLE
|
VARCHAR(255)
|
Título da atividade
|
5
|
NMTASKTYPE
|
VARCHAR(255)
|
Tipo de atividade
|
6
|
INITIATIVETITLE
|
VARCHAR(255)
|
Título da iniciativa
|
7
|
NMPRIORITY
|
VARCHAR(255)
|
Nome da prioridade
|
8
|
NMSPRINT
|
VARCHAR(255)
|
Nome da sprint
|
9
|
VLESTIMATE
|
NUMERIC(28,12)
|
Valor estimado
|
10
|
DTSTARTPLAN
|
DATETIME
|
Data de início
|
11
|
DTDEADLINE
|
DATETIME
|
Prazo
|
12
|
NMREPORTER
|
VARCHAR(255)
|
Relator
|
13
|
NMASSIGNEE
|
VARCHAR(255)
|
Responsável
|
14
|
DESCRIPTION
|
VARCHAR (MAX)
|
Descrição
|
|