Overview
This command will list the workspace data in the General data and Task flow tabs.
Related tables
TABLE
|
Description
|
Primary key (PK)
|
Connection tables
|
TSWORKSPACE
|
Stores the SE Kanban workspace
|
CDWORKSPACE
|
ADTEAM
TSWORKSPACEFLOW
|
ADTEAM
|
Stores teams
|
CDTEAM
|
TSWORKSPACE
|
TSWORKSPACEFLOW
|
Stores the workspace task flow
|
CDWORKSPACE
CDFLOW
CDTASKTYPE
|
TSWORKSPACE
TSFLOW
TSTASKTYPE
|
TSFLOW
|
Stores the SE Kanban flowchart
|
CDFLOW
|
TSWORKSPACEFLOW
|
TSTASKTYPE
|
Stores the SE Kanban task types
|
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 = 'WORKSPACE_PREFIX' /*NOTE 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 = 'WORKSPACE_PREFIX' /*NOTE 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 = 'WORKSPACE_PREFIX' /*NOTE 1*/
|
Notes
▪1: Workspace prefix that will be filtered.
Fields used on the view screen
#
|
Field ID
|
Type
|
Description
|
1
|
NMWORKSPACE
|
VARCHAR(255)
|
Workspace name
|
2
|
NMPREFIX
|
VARCHAR(255)
|
Workspace prefix
|
3
|
IDICON
|
VARCHAR(50)
|
Icon name
|
4
|
FGMETHODOLOGY
|
NUMERIC(2)
|
Methodology type: 1 = Kanban and 2 = Scrum;
|
5
|
NMFULLTEAM
|
VARCHAR(255)
|
Management team
|
6
|
NMFULLTEAMRESP
|
VARCHAR(255)
|
Responsible team
|
7
|
FGENABLED
|
NUMERIC(2)
|
Workspace enabled or not: 1 = enabled and 2 = disabled
|
8
|
FGENABLED
|
NUMERIC(2)
|
Task flow enabled or not: 1 = enabled and 2 = disabled
|
9
|
FGINITIATIVE
|
NUMERIC(2)
|
Indicates whether it is an initiative: 1 = sim and 2= no
|
10
|
FGSUBTASK
|
NUMERIC(2)
|
Indicates whether it is a subtask: 1 = sim and 2= no
|
11
|
NMTASKTYPE
|
VARCHAR(255)
|
Task type
|
12
|
NMFLOW
|
VARCHAR(255)
|
Flowchart name
|
|