Navigation:  Project >

Projects

 Previous  Top  Next

Overview

This command will list the data of created projects.

 

Related tables

TABLE

Description

Primary key (PK)

Connection tables

PRTASK

Stores the project data

CDTASK

PRTASKTYPE

ADALLUSERS

PRTASKTYPE

Stores the project type data

CDTASKTYPE

ADALLUSERS

Stores the user data

CDUSER

 

Oracle/Postgres/SQL Server

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

 

Notes

▪1: Determines that only project data will return.

 

Fields used on the view screen

 

project-01

 

#

Field ID

Type

Description

1

NMIDTASK

VARCHAR(255) NULL

2

NMTASK

VARCHAR(255) NULL

3

IDTASKTYPE

NMTASKTYPE

VARCHAR(50) NULL

VARCHAR(255) NULL

4

FGPHASE

NUMERIC(2,0) NULL

1 - Planning

2 - Execution

3 - Verification

4 - Finished

5 - Approval

6– Postponed

7 - Cancelled

5

IDUSER

NMUSER

VARCHAR(50) NULL

VARCHAR(255) NULL

6

DTPLANST

DTPLANEND

QTPLANDUR

DATETIME NULL

DATETIME NULL

NUMERIC(10,0) NULL

7

DTREPLST

DTREPLEND

QTREPLDUR

DATETIME NULL

DATETIME NULL

NUMERIC(10,0) NULL

8

DTACTST

DTACTEND

QTACTDUR

QTACTPERC

DATETIME NULL

DATETIME NULL

NUMERIC(10,0) NULL

NUMERIC(10,0) NULL