This is an old revision of the document!

Introduction:

This table outlines the detailed structure of the Questionnaire Details table, which contains essential information and settings for managing questionnaire questions. Each row corresponds to specific attributes of a question within a survey, including its display conditions, options, and behavior. Below, you'll find a list of fields in the table along with their descriptions and data types.

Name	Type	Comments
id	Primary	ID of questionnaire details table (auto-incremented).
qid	Index	ID of the questionnaire header table.
branchid	Index	ID of the branch related to the questionnaire.
majorqid	Index	Series number for main questions.
minorqid	Index	Series number for aspect-type questions.
displayorder	int	Defines the display order of the question.
surveypageno	int	The survey page number where the question appears.
cscategoryord	int	This category must be set when there is a CS (Customer Satisfaction) category.
questiontypecode	Index	Defines the type of the question: 1 = Single Response, 2 = Open Answer, 3 = Multiple Response, 4 = Aspect, 5 = NPS, 6 = Image Picker, 7 = Rapportcifer, 8 = Info question, 9 = Organisation question, 10 = Multiple Image Picker, 12 = Multiple Response Aspect question.
dualaspects	int	1 = Show aspect question text on both sides of options (like dual X-axis); 0 = Normal aspect question display.
startdate	date	The start date of the questionnaire.
enddate	date	The end date of the questionnaire.
displaycondition	varchar(200)	Conditions for displaying the question.
displayparams	text	Additional parameters for displaying the question.
qtextdisplaycond	varchar(200)	Display condition for the question text.
qtextdisplayparams	text	Query parameter condition to show the selected question text. This query returns the required index of an array formed by exploding the question with “	”.
optiondisplayparams	text	Conditions to show only selected options that meet the conditions defined in the “optiondisplayparamcond” column in the `fw_questionoptions` table.
ansqdetailids	varchar(200)	IDs of answers associated with the questionnaire details.
extrabaringraphs	varchar(250)	For specific metrics such as NPS, CES, EPS, GEM (Customer Experience or Engagement Scores).
status	int	1 = Active, 0 = Inactive, 2 = Archived.
mandatory	int	Whether open-answer questions are mandatory. 0 = Not mandatory, 1 = Mandatory.
importdatamandatory	int	Whether questions are mandatory when importing data. 0 = Not mandatory, 1 = Mandatory.
hidebackbtn	int	If set to 1, hides the back button in the survey; if 0, the back button is shown.
spectrumview	varchar(50)	Configures the display as either horizontal or vertical.
showcolorincsheet	int	Whether to show colors in the client sheet. 1 = Show color, 0 = Do not show color.
optiondisplayordertype	varchar(100)	Defines whether options are displayed in option-number order or randomly, with exclusion of any option. Excluded options contain `rand()	`.
mulimediaoptiondisplayordertype	varchar(100)	Used for multimedia questionnaires only. Defines whether options are displayed in order or randomly. Excluded options contain `rand()	`.
minansopt	int	If this column is non-zero, it restricts the minimum number of options that can be selected.
maxansopt	int	If this column is non-zero, it restricts the maximum number of options that can be selected.
ghostquestion	int	0 = Normal question, 1 = Last question (ghost question is typically hidden).
optionquery	text	Stores the query used to fetch options that are not from the option table.
updateparms	text	Contains parameters for updating the table, e.g., table name, column name, and conditions.
questionimg	longblob	Stores the image of the question.
questionimgorder	int	Defines the order of the question image if there are multiple images.
shownumbers	int	Used to show option numbers inside radio buttons for certain question types (e.g., question type codes 5, 7). 1 = Show, 0 = Do not show.
dependentqtns	int	Defines whether this question has dependent questions. 1 = Has dependent questions, 0 = No dependent questions.
hideinsurvey	int	Defines whether this question should be hidden in the survey. 1 = Hide, 0 = Show.
enablestarrating	int	Whether star rating is enabled for the question. 1 = Enabled, 0 = Disabled.
showoptsindropdown	int	1 = Show the options in a dropdown list (e.g., OLAC); 0 = Do not show dropdown if there are fewer than 50 options.
saveandreloadsurvey	int	If set to 1, saves the entered data and reloads the page with updated answers.
invisiblequestion	int	The question is printed in the questionnaire but not displayed in the survey. Typically used for question type code 9.
noofrowsforcomment	int	Number of rows for comment input. Default is 8 rows.
showNEVafterthis	varchar(250)	Defines the condition or text to display after this question, typically related to a NEV (Not Enough Valid) response.
newtranslationapi	text	Language ID of the translated text.