Overview

This command will list the task data in the Task (KN010) menu.

Related tables

TABLE	Description	Primary key (PK)	Connection tables
TSTASK	Stores the SE Kanban task	CDTASK	ADUSER TSTASKTYPE TSPRIORITY TSWORKSPACE TSSTEP TSSPRINT
ADUSER	Stores system users	CDUSER	TSTASK
TSTASKTYPE	Stores the SE Kanban task types	CDTASKTYPE	TSTASK
TSPRIORITY	Stores the SE Kanban priorities	CDPRIORITY	TSTASK
TSWORKSPACE	Stores the SE Kanban workspaces	CDWORKSPACE	TSTASK TSSPRINT
TSSTEP	Stores the SE Kanban flowchart steps	CDSTEP	TSTASK
TSSPRINT	Stores the SE Kanban sprints	CDSPRINT	TSTASK TSWORKSPACE

Oracle/Postgres/SQL Server

  SELECT
   TSTSK.DTDEADLINE,
   PRIORITY.NMPRIORITY,
   TYPE.NMTASKTYPE,
   WKS.NMPREFIX + '-' + CAST(TSTSK.NRTASK AS VARCHAR(255)) AS IDENTIFIER,
   TSTSK.NMTITLE,
   TSSPT.NMTITLE AS NMSPRINT,
   TSTSK.VLESTIMATE,
   TSTSK.DTSTARTPLAN,
   TSTSK.DTDEADLINE,
   TSTSK.DTINSERT,
   TSTSK.DTUPDATE,
   TSTSK.DTFINISH,
   ASSIGNEE.NMUSER NMASSIGNEE,
   REPORTER.NMUSER NMREPORTER,
   CREATOR.NMUSER NMCREATOR,
   STEP.NMSTEP AS NMSTEP,
   WKS.NMWORKSPACE

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 )
   LEFT JOIN ADUSER CREATOR ON ( TSTSK.CDCREATEDBY = CREATOR.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 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

kanban-04

#	Field ID	Type	Description
1	DTDEADLINE	DATETIME	Deadline: 'On time' when the deadline is later than the current date, 'Past due' when the deadline is earlier than the current date, and 'Close to due date' when the deadline is the same as the current date.
2	NMPRIORITY	VARCHAR(255)	Priority name
3	NMTASKTYPE	VARCHAR(255)	Task type
4	IDENTIFIER	VARCHAR(255)	Activity ID #
5	NMTITLE	VARCHAR(255)	Task name
6	NMSPRINT	VARCHAR(255)	Sprint name
7	VLESTIMATE	NUMERIC(28,12)	Estimated value
8	DTSTARTPLAN	DATETIME	Planned start date
9	DTDEADLINE	DATETIME	Deadline
10	DTINSERT	DATETIME	Task creation date
11	DTUPDATE	DATETIME	Last update date
12	DTFINISH	DATETIME	Closure date
13	NMASSIGNEE	VARCHAR(255)	Responsibility
14	NMREPORTER	VARCHAR(255)	Reporter
15	NMCREATOR	VARCHAR(255)	Creator
16	NMSTEP	VARCHAR(255)	Step name
17	NMWORKSPACE	VARCHAR(255)	Workspace name

Tasks

Overview

This command will list the task data in the Task (KN010) menu.

Related tables

Oracle/Postgres/SQL Server

Notes

Fields used on the view screen