Navigation:  Project >

Project tasks

 Previous  Top  Next

Overview

This command will list the data of tasks from a project.

 

Related tables

TABLE

Description

Primary key (PK)

Connection tables

PRTASK

Stores the project task data

CDTASK

PRTASKTYPE

ADALLUSERS

PRTASKTYPE

Stores the task type data

CDTASKTYPE

ADALLUSERS

Stores the user data

CDUSER

GNASSOCATTACH

Attachment

CDASSOCATTACH

ADATTACHMENT

GNASSOC

GNCALENDARWORKDAY

Working days

CDCALENDAR

DTDAY

ADPARAMS

General parameters

CDISOSYSTEM

CDPARAM

 

Oracle/Postgres/SQL Server

SELECT
   ACTIVITY.NMIDTASK,
   ACTIVITY.NMTASK,
   ACTIVITY.NMWBS,
   ACTIVITY.FGCONSTRAINT,
   PRTASKTYPE.IDTASKTYPE,
   PRTASKTYPE.NMTASKTYPE,
   ACTIVITY.FGPHASE,
   ADALLUSERS.IDUSER,
   ADALLUSERS.NMUSER,
   ACTIVITY.DTPLANST,
   ACTIVITY.DTPLANEND,
   ACTIVITY.QTPLANDUR,
   ACTIVITY.DTREPLST,
   ACTIVITY.DTREPLEND,
   ACTIVITY.QTREPLDUR,
   ACTIVITY.DTACTST,
   ACTIVITY.DTACTEND,
   ACTIVITY.QTACTDUR,
   ACTIVITY.QTACTPERC
FROM
   PRTASK
INNER JOIN
   PRTASK ACTIVITY ON ACTIVITY.CDBASETASK = PRTASK.CDTASK
LEFT JOIN
   PRTASKTYPE ON PRTASKTYPE.CDTASKTYPE = ACTIVITY.CDTASKTYPE
INNER JOIN   
   ADALLUSERS ON ADALLUSERS.CDUSER = ACTIVITY.CDTASKRESP
WHERE
   PRTASK.FGTASKTYPE = 1 /* NOTE 1 */ AND PRTASK.NMIDTASK = 'PROJECT_ID' /* NOTE 2 */ 
ORDER BY NMWBS   

 

Notes

▪1: Determines that only project task data will return.

▪2: ID # of the project to be filtered.

 

Fields used on the view screen

 

project-03

 

#

Field ID

Type

Description

1

NMIDTASK

VARCHAR(255) NULL

2

NMTASK

VARCHAR(255) NULL

3

NMWBS

VARCHAR(255) NULL

4

FGCONSTRAINT

NUMERIC(2,0) NULL

1– As soon as possible

2– Fixed dates

3– As late as possible

4– Start no earlier than

5– Finish no earlier than

6– Start no later than

7– Finish no later than

8– Must finish on

9– Must start on

5

IDTASKTYPE

NMTASKTYPE

VARCHAR(50) NULL

VARCHAR(255) NULL

6

FGPHASE

NUMERIC(2,0) NULL

1 - Planning

2 - Execution

3 - Verification

4 - Finished

5 - Approval

6– Postponed

7 - Cancelled

7

IDUSER

NMUSER

VARCHAR(50) NULL

VARCHAR(255) NULL

8

DTPLANST

DATETIME NULL

9

DTPLANEND

DATETIME NULL

10

QTPLANDUR

NUMERIC(10,0) NULL

11

DTREPLST

DATETIME NULL

12

DTREPLEND

DATETIME NULL

13

QTREPLDUR

NUMERIC(10,0) NULL

14

DTACTST

DATETIME NULL

15

DTACTEND

DATETIME NULL

16

QTACTDUR

NUMERIC(10,0) NULL

17

QTACTPERC

NUMERIC(10,0) NULL