Overview

This command will list the desired question, filtering by its description. It is used to search for information of the question and details configured in it. Data listed in this command can also be searched through the File Question (SV003) screen.

Related tables

TABLE	Description	Primary key (PK)	Connection tables
GNQUESTION	Question table	CDQUESTION	GNQUESTIONLEVEL GNQUESTIONGROUP ADALLUSERS
GNQUESTIONLEVEL	Degree of difficulty table	CDQUESTIONLEVEL
GNGENTYPE	Generic type table	CDGENTYPE	ADCHECKLIST GNACTIVITYTIMECFG GNASSOC GNELETRONICFILECFG GNEVAL GNFAVORITE GNMASK GNREVCONFIG GNSECURITY GNTRANSLATION GNTYPEROLE
GNQUESTIONANSWER	Answer table	CDQUESTIONANSWER	GNQUESTION

Oracle/Postgres/SQL Server

SELECT GNQ.DSQUESTION ,
   GNQ.FGTYPEQUESTION ,
   GNTP.IDGENTYPE ,
   GNTP.NMGENTYPE ,
   GNQL.IDQUESTIONLEVEL ,
   GNQL.NMQUESTIONLEVEL ,
   GNQ.DSHELP ,
   GNQ.VLWEIGHT ,
   GNQ.FGREQUIREANSWER ,
   GNQ.FGREQUIRCORRECTANS ,
   GNQ.FGATTACH ,
   GNQ.FGATTACHREQUIRED , --NOTE1
   GNQ.FGMULTCHECK , --NOTE2
   GNQTEMP.DSQUESTION AS QUESTIONMATRIX, --NOTE2
   GNANS.DSANSWER ,
   GNANS.NRORDER ,
   GNANS.VLNOTE , --NOTE3
   GNANS.FGCORRECT ,
   GNANS.FGREQOBSERVATIONS ,
   GNANS.FGOBSREQUIRED ,
   GNANS.FGDEFAULT ,
   GNANS.FGATTACHREQUIRED
FROM   GNQUESTION GNQ
     LEFT JOIN GNGENTYPE GNTP
     ON   (
   GNTP.CDGENTYPE = GNQ.CDQUESTIONGROUP
   )
     LEFT JOIN GNQUESTIONLEVEL GNQL
     ON   (
   GNQL.CDQUESTIONLEVEL = GNQ.CDQUESTIONLEVEL
   )
     LEFT JOIN GNQUESTIONANSWER GNANS
     ON   (
   GNANS.CDQUESTION = GNQ.CDQUESTION
   )
     LEFT JOIN GNQUESTION GNQTEMP
     ON   (
   GNQTEMP.CDQUESTIONOWNER = GNQ.CDQUESTION
   )
WHERE  CAST(GNQ.DSQUESTION AS VARCHAR(4000))= 'Question description'

Notes

▪1: This field will only be displayed on screen in the "Descriptive" question mode.

▪2: This field will only be displayed on screen in the "Matrix" question mode.

▪3: This field will only be displayed on screen if the question is not evaluative.

Fields used on the view screen

survey-03

survey-04

survey-05

#	Field ID	Type	Description
1	DSQUESTION	TEXT(16)	Question description
2	FGTYPEQUESTION	NUMERIC(5)	Question type: 1- Single choice 2- Multiple choice 3- Descriptive 4- Single matrix 5- Multiple matrix 6- Short text 7- Date and time 8- Date 9- Time
3	IDGENTYPE	VARCHAR(50)	Question group ID #
4	NMGENTYPE	VARCHAR(255)	Question group name
5	IDQUESTIONLEVEL	VARCHAR(50)	Degree of difficulty ID #
6	NMQUESTIONLEVEL	VARCHAR(255)	Degree of difficulty name
7	DSHELP	TEXT(16)	Help text
8	VLWEIGHT	NUMERIC(13)	Weight
9	FGREQUIREANSWER	NUMERIC(5)	Indicates whether the question is mandatory: 1 - Yes 2 - No
10	FGREQUIRCORRECTANS	NUMERIC(5)	Indicates whether the question requires at least one correct answer: 1 - Yes 2 - No
11	FGATTACH	NUMERIC(5)	Flag that indicates the option to enter attachments to the question: 1 - Yes 2 - No
12	DSANSWER	VARCHAR(50)	Answer
13	NRORDER	VARCHAR(255)	Answer disposition order
14	VLNOTE	NUMERIC(5)	Score. Note1.
15	FGCORRECT	NUMERIC(5)	Indicates whether it is the correct answer: 1 - Yes 2 - No
16	FGREQOBSERVATIONS	NUMERIC(5)	Indicates whether the answer requires comments: 1 - Yes 2 - No
17	FGOBSREQUIRED	NUMERIC(5)	Indicates whether the comments are required: 1 - Yes 2 - No
18	FGDEFAULT	NUMERIC(5)	Default answer
19	FGATTACHREQUIRED	NUMERIC(5)	Flag that indicates whether the question requires attachments: 1 - Yes 2 - No
20	FGMULTCHECK	NUMERIC(5)	Indicates whether it is possible to check the same answer to all questions (Note2): 1 - Yes 2 - No
21	QUESTIONMATRIX	TEXT(16)	Matrix question description. Field created from “DSQUESTION” (Note2).