Overview

This command will list the main data of an isolated action.

Related tables

TABLE	Description	Primary key (PK)	Connection tables
GNACTIVITY	Table that stores common activity information (it is also used by other components, such as Workflow, Survey, Asset, etc.)	CDGENACTIVITY	GNTASK ADUSER ADEXTERNALUSER ADTEAM GNCOSTCONFIG GNCALENDAR GNEVALRESULTUSED
GNTASK	Specific actions table	CDTASK	GNACTIVITY GNGENTYPE
GNGENTYPE	Generic type table (category)	CDGENTYPE	GNTASK
ADUSER	Internal users view	CDUSER	GNACTIVITY
ADEXTERNALUSER	External users view	CDEXTERNALUSER	GNACTIVITY
ADTEAM	Team table	CDTEAM	GNACTIVITY
GNCOSTCONFIG	Cost table	CDCOSTCONFIG	GNACTIVITY
GNCALENDAR	Calendar table	CDCALENDAR	GNACTIVITY
GNEVALRESULTUSED	Generic evaluation table	CDEVALRESULTUSED	GNACTIVITY
GNEVALRESULT	Evaluation result table	CDEVALRESULT	GNEVALRESULTUSED

Oracle/Postgres/SQL Server

SELECT GNACTIVITY.CDGENACTIVITY, /*NOTE*/
GNACTIVITY.IDACTIVITY,
GNACTIVITY.NMACTIVITY,
GNACTIVITY.FGSTATUS,
GNACTIVITY.DSDESCRIPTION,
GNACTIVITY.DSACTIVITY,
GNACTIVITY.DTSTARTPLAN,
GNACTIVITY.QTTIMESTARTPLAN,
GNACTIVITY.DTFINISHPLAN,
GNACTIVITY.QTTIMEFINISHPLAN,
GNACTIVITY.QTDURATIONPLAN,
GNACTIVITY.DTSTART,
GNACTIVITY.QTTIMESTART,
GNACTIVITY.DTFINISH,
GNACTIVITY.QTTIMEFINISH,
GNACTIVITY.QTDURATIONREAL,
GNACTIVITY.VLPERCENTAGEM,
GNACTIVITY.FGUSETYPEACCESS,
GNTASK.FGIMMEDIATEACTION,
GNTASK.DSWHERE,
GNTASK.DSWHY,
GNGENTYPE.IDGENTYPE,
GNGENTYPE.NMGENTYPE,
ADUACTRESP.IDUSER AS IDUSERACTRESP,
ADUACTRESP.NMUSER AS NMUSERACTRESP,
ADUEXEC.IDUSER AS USEREXEC,
ADUEXEC.NMUSER AS NMUSEREXEC,
ADEXTERNALUSER.NMEMAIL,
ADEXTERNALUSER.NMUSER,
ADTEAM.IDTEAM,
ADTEAM.NMTEAM,
GNCOSTCONFIG.MNCOSTPROG,
GNCOSTCONFIG.MNCOSTREAL,
GNCALENDAR.IDCALENDAR,
GNCALENDAR.NMCALENDAR,
GNEVALRESULT.NMEVALRESULT,
GNEVALRESULTUSED.VLEVALRESULT
FROM GNACTIVITY
INNER JOIN GNTASK ON GNTASK.CDGENACTIVITY = GNACTIVITY.CDGENACTIVITY
INNER JOIN ADUSER ADUACTRESP ON ADUACTRESP.CDUSER = GNACTIVITY.CDUSERACTIVRESP
LEFT OUTER JOIN ADUSER ADUEXEC ON ADUEXEC.CDUSER = GNACTIVITY.CDUSER
LEFT OUTER JOIN ADEXTERNALUSER ON ADEXTERNALUSER.CDEXTERNALUSER = GNACTIVITY.CDEXTERNALUSER
LEFT OUTER JOIN GNGENTYPE ON GNGENTYPE.CDGENTYPE = GNTASK.CDTASKTYPE
LEFT OUTER JOIN ADTEAM ON ADTEAM.CDTEAM = GNACTIVITY.CDTEAM
LEFT OUTER JOIN GNCOSTCONFIG ON GNCOSTCONFIG.CDCOSTCONFIG = GNACTIVITY.CDCOSTCONFIG
LEFT OUTER JOIN GNCALENDAR ON GNCALENDAR.CDCALENDAR = GNACTIVITY.CDCALENDAR
LEFT OUTER JOIN GNEVALRESULTUSED ON GNEVALRESULTUSED.CDEVALRESULTUSED = GNACTIVITY.CDEVALRSLTPRIORITY
LEFT OUTER JOIN GNEVALRESULT ON GNEVALRESULT.CDEVALRESULT = GNEVALRESULTUSED.CDEVALRESULT
WHERE GNACTIVITY.CDACTIVITYOWNER IS NULL
AND GNACTIVITY.IDACTIVITY = 'Isolated_action_ID' /*NOTE2*/

Notes

▪1: Unique internal code of the isolated action;

▪2: Isolated action ID #.

Fields used on the view screen

action_plan-03