Overview

This command will list the desired survey execution response, filtering by its ID # and revision. It is used to search for information of the answers and details configured in it. Data listed in this command can also be searched through the Execution Survey execution (SV028) screen.

Related tables

TABLE	Description	Primary key (PK)	Connection tables
SVSURVEY	Survey table	CDSURVEY	ADTEAM GNACTIVITY GNAPPROV GNREVISION GNSURVEY GNSURVEYEXEC GNTEMPLATEFILE SERICHTEXT SVFORMGROUP
GNSURVEY	Evaluation record table	CDSURVEY	ADTEAM ADALLUSERS GNSURVEYTYPE GNSURVEYSHORTURL
ADALLUSERS	User table	CDUSER	ADUSEREXTERNALDATA GNFAVORITE ADALLUSERS
GNACTIVITY	Activity record	CDGENACTIVITY	ADALLUSERS ADDEPARTMENT ADMAILTASKREL ADPOSITION ADROLE ADTEAM ADUSEREXTERNALDATA GNACTIVITYTIMECFG GNAPPROV GNASSOC GNCALENDAR GNCHECKLISTANSWER GNCOSTCONFIG GNEVALRESULTUSED GNEVALREVISION GNFAVORITE GNOBJECTASSOCGROUP GNSECURITY GNTYPEROLE SERICHTEXT
GNSURVEYEXECUSER	Table that stores survey executions per user	CDSURVEYEXECUSER	ADALLUSERS ADCOMPANY ADCONTACT ADPOSITION ADDEPARTMENT ADUSEREXTERNALDATA GNSURVEYEXEC GNSURVEYSHORTURL SVSURVEYEXECMEMBER
GNSURVEYEXEC	Table that stores survey executions	CDSURVEYEXEC	GNSURVEY GNSURVEYSHORTURL
ADUSEREXTERNALDATA	External user table	CDEXTERNALUSER	ADCOMPANY COLICENSEKEY
ADCOMPANY	Company table	CDCOMPANY	ADCOMPANYTYPE
ADDEPARTMENT	Department table	CDDEPARTMENT	ADALLUSERS ADDEPARTMENT ADTEAM COWORKSPACE GNASSOC GNFAVORITE GNMAPPING
ADPOSITION	Position table	CDPOSITION	GNMAPPING

Oracle/Postgres/SQL Server

SELECT AUSER.IDUSER ,
   AUSER.NMUSER ,
   AUSER.NMUSEREMAIL ,
   GNEXECUSR.NMPARTICIPANT ,
   GNEXECUSR.NMPARTICIPANTEMAIL ,
   SRV.QTMAXATTEMPTS ,
   GNEXECUSR.NRATTEMPT ,
   GNEXECUSR.VLNOTE ,
   GNEXECUSR.FGSTATUS ,
   GNEXECUSR.DTSTARTEXECUSER ,
   GNEXECUSR.QTTMTOTALEXECUSER ,
   GNEXECUSR.DTFINISHEXECUSER ,
   ADEUC.NMCOMPANY AS NMEXTERNALCOMPANY ,
   GNEXECUSR.DSREASON ,
   GNEXECUSR.FGREADMAIL
FROM   GNSURVEYEXECUSER GNEXECUSR
     INNER JOIN GNSURVEYEXEC GNX
     ON   (
   GNX.CDSURVEYEXEC = GNEXECUSR.CDSURVEYEXEC
   )
     INNER JOIN SVSURVEY SRV
     ON   (
   SRV.CDSURVEYEXEC = GNEXECUSR.CDSURVEYEXEC
   )
     INNER JOIN GNACTIVITY GNACT
     ON   (
   GNACT.CDGENACTIVITY = SRV.CDGENACTIVITY
   )
     LEFT JOIN ADALLUSERS AUSER
     ON   (
   AUSER.CDUSER = GNEXECUSR.CDUSER
   )
     LEFT JOIN ADUSEREXTERNALDATA ADEU
     ON   (
   ADEU.CDEXTERNALUSER = AUSER.CDEXTERNALUSER
   )
     LEFT JOIN ADCOMPANY ADEUC
     ON   (
   ADEUC.CDCOMPANY = ADEU.CDCOMPANY
   )
WHERE  GNACT.IDACTIVITY = 'SURVEYID’ /* NOTE1 */

Notes

▪1: Survey ID #.

Fields used on the view screen

survey-06

survey-07

#	Field ID	Type	Description
1	IDUSER	VARCHAR(50)	Respondent user ID #
2	NMUSER	VARCHAR(255)	Respondent user name
3	NMUSEREMAIL	VARCHAR(255)	Respondent user e-mail
4	NMPARTICIPANT	VARCHAR(255)	Guest user name
5	NMPARTICIPANTEMAIL	VARCHAR(255)	Guest user e-mail
6	QTMAXATTEMPTS	NUMERIC(9)	Maximum number of attempts
7	NRATTEMPT	NUMERIC(9)	Attempt
8	VLNOTE	NUMERIC(13)	Score
9	FGSTATUS	NUMERIC(5)	Respondent evaluation status: 1- In progress 2- In correction 3- Closed 4- To be started
10	DTSTARTEXECUSER	DATETIME(8)	Respondent evaluation start date
11	QTTMTOTALEXECUSER	NUMERIC(9)	Total time of respondent evaluation
12	DTFINISHEXECUSER	DATETIME(8)	Respondent evaluation end date
13	NMEXTERNALCOMPANY	VARCHAR(255)	Company name
14	DSREASON	TEXT(16)	Reason for incomplete survey
15	FGREADMAIL	NUMERIC(5)	Indicates whether the email was read by the respondent: [1 - Yes; 2 - No; 3 - Does not contain a saved email]

Survey response and details

Overview

Related tables

Oracle/Postgres/SQL Server

Notes

Fields used on the view screen