Overview
This command will list the task data in the Task details tab of the Backlog (KN011) menu.
Related tables
TABLE
|
Description
|
Primary key (PK)
|
Connection tables
|
TSTASK
|
Stores the SE Kanban task
|
CDTASK
|
ADUSER
TSTASKTYPE
TSPRIORITY
TSWORKSPACE
TSSTEP
SERICHTEXT
TSSPRINT
|
ADUSER
|
Stores system users
|
CDUSER
|
TSTASK
|
TSTASKTYPE
|
Stores the SE Kanban task types
|
CDTASKTYPE
|
TSTASK
|
TSPRIORITY
|
Stores the SE Kanban priority
|
CDPRIORITY
|
TSTASK
|
TSWORKSPACE
|
Stores the SE Kanban workspace
|
CDWORKSPACE
|
TSTASK
TSSPRINT
|
TSSTEP
|
Stores the SE Kanban flowchart steps
|
CDSTEP
|
TSTASK
|
SERICHTEXT
|
Table that stores the richtext data in the system
|
OID
|
TSTASK
|
SETEXT
|
Table used to save large content as text, such as images, etc.
|
OID
|
SERICHTEXT
|
TSSPRINT
|
Stores the SE Kanban sprint
|
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)) = 'TASK_ID' /*NOTE 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)) = 'TASK_ID' /*NOTE 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)) = 'TASK_ID' /*NOTE 1*/
ORDER BY TSTSK.NRTASK ASC
|
Notes
▪1: ID # of the task to be filtered.
Fields used on the view screen
#
|
Field ID
|
Type
|
Description
|
1
|
NMWORKSPACE
|
VARCHAR(255)
|
Workspace name
|
2
|
IDENTIFIER
|
VARCHAR(255)
|
Activity ID #
|
3
|
NMSTEP
|
VARCHAR(255)
|
Step name
|
4
|
NMTITLE
|
VARCHAR(255)
|
Task name
|
5
|
NMTASKTYPE
|
VARCHAR(255)
|
Task type
|
6
|
INITIATIVETITLE
|
VARCHAR(255)
|
Initiative title
|
7
|
NMPRIORITY
|
VARCHAR(255)
|
Priority name
|
8
|
NMSPRINT
|
VARCHAR(255)
|
Sprint name
|
9
|
VLESTIMATE
|
NUMERIC(28,12)
|
Estimated value
|
10
|
DTSTARTPLAN
|
DATETIME
|
Start date
|
11
|
DTDEADLINE
|
DATETIME
|
Deadline
|
12
|
NMREPORTER
|
VARCHAR(255)
|
Reporter
|
13
|
NMASSIGNEE
|
VARCHAR(255)
|
Responsibility
|
14
|
DESCRIPTION
|
VARCHAR (MAX)
|
Description
|
|
