Visão geral
Este comando listará os dados do workspace contidos nas abas Dados gerais e Fluxo da atividade.
Tabelas relacionadas
TABELA
|
Descrição
|
Chave primária (PK)
|
Tabelas de ligação
|
TSWORKSPACE
|
Armazena o workspace do SE Kanban
|
CDWORKSPACE
|
ADTEAM
TSWORKSPACEFLOW
|
ADTEAM
|
Armazena as equipes
|
CDTEAM
|
TSWORKSPACE
|
TSWORKSPACEFLOW
|
Armazena o fluxo de atividade do workspace
|
CDWORKSPACE
CDFLOW
CDTASKTYPE
|
TSWORKSPACE
TSFLOW
TSTASKTYPE
|
TSFLOW
|
Armazena o fluxograma do SE Kanban
|
CDFLOW
|
TSWORKSPACEFLOW
|
TSTASKTYPE
|
Armazena o tipo de atividades do SE Kanban
|
CDTASKTYPE
|
TSWORKSPACEFLOW
|
Oracle
SELECT
TSWK.NMWORKSPACE,
TSWK.NMPREFIX,
TSWK.IDICON,
TSWK.FGMETHODOLOGY,
ADTEAMEXEC.IDTEAM || ' - ' || ADTEAMEXEC.NMTEAM AS NMFULLTEAM,
ADTEAMRESP.IDTEAM || ' - ' || ADTEAMRESP.NMTEAM AS NMFULLTEAMRESP,
TSWK.FGENABLED,
TSWKFL.FGENABLED,
TSWKFL.FGINITIATIVE,
TSWKFL.FGSUBTASK,
TSFL.NMFLOW,
TSTT.NMTASKTYPE
FROM
TSWORKSPACE TSWK
INNER JOIN ADTEAM ADTEAMEXEC ON ( TSWK.CDTEAM = ADTEAMEXEC.CDTEAM )
INNER JOIN ADTEAM ADTEAMRESP ON ( TSWK.CDTEAMRESPONSIBLE = ADTEAMRESP.CDTEAM )
INNER JOIN TSWORKSPACEFLOW TSWKFL ON ( TSWK.CDWORKSPACE = TSWKFL.CDWORKSPACE )
INNER JOIN TSFLOW TSFL ON (TSWKFL.CDFLOW = TSFL.CDFLOW)
INNER JOIN TSTASKTYPE TSTT ON (TSWKFL.CDTASKTYPE = TSTT.CDTASKTYPE)
WHERE TSWK.NMPREFIX = 'PREFIXO_DO_WORKSPACE' /*OBS 1*/
|
Postgres
SELECT
TSWK.NMWORKSPACE,
TSWK.NMPREFIX,
TSWK.IDICON,
TSWK.FGMETHODOLOGY,
ADTEAMEXEC.IDTEAM || ' - ' || ADTEAMEXEC.NMTEAM AS NMFULLTEAM,
ADTEAMRESP.IDTEAM || ' - ' || ADTEAMRESP.NMTEAM AS NMFULLTEAMRESP,
TSWK.FGENABLED,
TSWKFL.FGENABLED,
TSWKFL.FGINITIATIVE,
TSWKFL.FGSUBTASK,
TSFL.NMFLOW,
TSTT.NMTASKTYPE
FROM
TSWORKSPACE TSWK
INNER JOIN ADTEAM ADTEAMEXEC ON ( TSWK.CDTEAM = ADTEAMEXEC.CDTEAM )
INNER JOIN ADTEAM ADTEAMRESP ON ( TSWK.CDTEAMRESPONSIBLE = ADTEAMRESP.CDTEAM )
INNER JOIN TSWORKSPACEFLOW TSWKFL ON ( TSWK.CDWORKSPACE = TSWKFL.CDWORKSPACE )
INNER JOIN TSFLOW TSFL ON (TSWKFL.CDFLOW = TSFL.CDFLOW)
INNER JOIN TSTASKTYPE TSTT ON (TSWKFL.CDTASKTYPE = TSTT.CDTASKTYPE)
WHERE TSWK.NMPREFIX = 'PREFIXO_DO_WORKSPACE' /*OBS 1*/
|
SQL Server
SELECT
TSWK.NMWORKSPACE,
TSWK.NMPREFIX,
TSWK.IDICON,
TSWK.FGMETHODOLOGY,
ADTEAMEXEC.IDTEAM + ' - ' + ADTEAMEXEC.NMTEAM AS NMFULLTEAM,
ADTEAMRESP.IDTEAM + ' - ' + ADTEAMRESP.NMTEAM AS NMFULLTEAMRESP,
TSWK.FGENABLED,
TSWKFL.FGENABLED,
TSWKFL.FGINITIATIVE,
TSWKFL.FGSUBTASK,
TSFL.NMFLOW,
TSTT.NMTASKTYPE
FROM
TSWORKSPACE TSWK
INNER JOIN ADTEAM ADTEAMEXEC ON ( TSWK.CDTEAM = ADTEAMEXEC.CDTEAM )
INNER JOIN ADTEAM ADTEAMRESP ON ( TSWK.CDTEAMRESPONSIBLE = ADTEAMRESP.CDTEAM )
INNER JOIN TSWORKSPACEFLOW TSWKFL ON ( TSWK.CDWORKSPACE = TSWKFL.CDWORKSPACE )
INNER JOIN TSFLOW TSFL ON (TSWKFL.CDFLOW = TSFL.CDFLOW)
INNER JOIN TSTASKTYPE TSTT ON (TSWKFL.CDTASKTYPE = TSTT.CDTASKTYPE)
WHERE TSWK.NMPREFIX = 'PREFIXO_DO_WORKSPACE' /*OBS 1*/
|
Observações
▪1: Prefixo do workspace que será filtrado.
Campos utilizados na consulta
Nº
|
ID do campo
|
Tipo
|
Observação
|
1
|
NMWORKSPACE
|
VARCHAR(255)
|
Nome do workspace
|
2
|
NMPREFIX
|
VARCHAR(255)
|
Prefixo do workspace
|
3
|
IDICON
|
VARCHAR(50)
|
Nome do ícone
|
4
|
FGMETHODOLOGY
|
NUMERIC(2)
|
Tipo de metodologia: 1 = Kanban e 2 = Scrum;
|
5
|
NMFULLTEAM
|
VARCHAR(255)
|
Equipe de gestão
|
6
|
NMFULLTEAMRESP
|
VARCHAR(255)
|
Equipe responsável
|
7
|
FGENABLED
|
NUMERIC(2)
|
Workspace habilitado ou não: 1 = ativo e 2 = inativo
|
8
|
FGENABLED
|
NUMERIC(2)
|
Fluxo da atividade habilitado ou não: 1 = ativo e 2 = inativo
|
9
|
FGINITIATIVE
|
NUMERIC(2)
|
Indica se é iniciativa: 1 = sim e 2 = não
|
10
|
FGSUBTASK
|
NUMERIC(2)
|
Indica se é subtarefa: 1 = sim e 2 = não
|
11
|
NMTASKTYPE
|
VARCHAR(255)
|
Tipo de atividade
|
12
|
NMFLOW
|
VARCHAR(255)
|
Nome do fluxograma
|
|