Navigation:  Request >

Requests in the being executed step

 Previous  Top  Next

Overview

This command will list the data displayed in the fields of the request data screen.

 

Related tables

TABLE

Description

Primary key (PK)

Connection tables

GNREQUEST

Stores the request data

CDREQUEST

GNREQUESTTYPE

GNREQUESTTYPE

Stores the request type data

CDREQUESTTYPE

ADDEPARTMENT

Department table

CDDEPARTMENT

GNREQUEST

ADPOSITION

Position table

CDPOSITION

GNREQUEST

ADTEAM

Team table

CDTEAM

GNREQUEST

ADALLUSERS

User table

CDUSER

GNREQUEST

 

Oracle/Postgres/SQL Server

SELECT
   GNREQUEST.IDREQUEST,
   GNREQUEST.NMREQUEST,
   GNREQUEST.FGPHASE,
   GNREQUESTTYPE.IDREQUESTTYPE,
   GNREQUESTTYPE.NMREQUESTTYPE,
   GNREQUEST.DTREQUEST,
   GNREQUEST.DTREQUESTDEADLINE,
   GNREQUEST.FGRESPCONTROL,
   ADDEPARTMENT.NMDEPARTMENT,
   ADPOSITION.NMPOSITION,
   ADTEAM.NMTEAM,
   ADALLUSERS.NMUSER
FROM
   GNREQUEST
INNER JOIN 
   GNREQUESTTYPE ON GNREQUESTTYPE.CDREQUESTTYPE = GNREQUEST.CDREQUESTTYPE
LEFT JOIN 
   ADDEPARTMENT ON ADDEPARTMENT.CDDEPARTMENT = GNREQUEST.CDTASKDEPT
LEFT JOIN
   ADPOSITION ON ADPOSITION.CDPOSITION = GNREQUEST.CDTASKPOS
LEFT JOIN
   ADTEAM ON ADTEAM.CDTEAM = GNREQUEST.CDTASKTEAM
LEFT JOIN
   ADALLUSERS ON ADALLUSERS.CDUSER = GNREQUEST.CDTASKUSER
WHERE
        GNREQUEST.FGPHASE = 4 /* NOTE 1 */

 

Notes

▪1: The FGPHASE = 4 field determines that only requests in the being executed step will be displayed.

 

Fields used on the view screen

 

request-01

 

#

Field ID

Type

Description

1

IDREQUEST

VARCHAR(50) NULL

2

NMREQUEST

VARCHAR(255) NULL

3

FGPHASE

NUMERIC(2) NULL

1– Issue

2– Approval

3– Waiting for execution

4– Being executed

5– Closure

6– Finished

7– Cancelled

8– Cancelled (when cancelled by the object)

4

IDREQUESTTYPE

NMREQUESTTYPE

VARCHAR(50) NULL

VARCHAR(255) NULL

5

DTREQUEST

DATETIME NULL

6

DTREQUESTDEADLINE

DATETIME NULL

7

FGRESPCONTROL

NUMERIC(2) NULL

1– Department

2– Position

3– Department/Position

4– User

5– Team

8

NMDEPARTMENT

VARCHAR(255) NULL

9

NMPOSITION

VARCHAR(255) NULL

10

NMTEAM

VARCHAR(255) NULL

11

NMUSER

VARCHAR(255) NULL