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 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 (Client Sheet) category.
questiontypecode	Index	1= Single Response, 2= Open answer, 3= Multiple Response, 4= Aspect, 5= NPS, 6= Image Picker Question, 7= Rapportcifer, 8= Infoquestion, 9= Organisation question, 10= Multiple Image Picker, 12= Multiple Response Aspect question.
dualaspects	int	1=Show Aspect question text 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 question text.
qtextdisplayparams	text	Query param condition to show the selected question text. This query returns the required index of an array formed by exploding the question with “	”.
optiondisplayparams	text	Condition to show only selected options, which meet the conditions defined in column “optiondisplayparamcond” in `fw_questionoptions`.
ansqdetailids	varchar(200)	Id of answers of questionnaire details.
extrabaringraphs	varchar(250)	For NPS, CES, EPS, GEM.
status	int	1=active, 0=inactive, 2=archive.
mandatory	int	Make open-answer questions mandatory. 0=Nothing.
importdatamandatory	int	Make questions mandatory in import data. 0=Nothing.
hidebackbtn	int	If set to 1, hides the back button in the survey; if 0, the back button is shown.
spectrumview	varchar(50)	Configure 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 in option-number order or random with exclusion of any option. Excluded options contain `rand()	`.
mulimediaoptiondisplayordertype	varchar(100)	Used for multimedia questionnaires only. Defines whether options are in option-number order or random with exclusion of any option. Excluded options contain `rand()	`.
minansopt	int	If this column contains not equal to zero then there should be a restriction for number of options to be chosen.
maxansopt	int	If this column contains not equal to zero then there should be a restriction for number of options to be chosen.
ghostquestion	int	0=Normal question, 1=Last question.
optionquery	text	Stores query to fetch options which are not from the option table.
updateparms	text	First param is table name, second param is column name and last param is condition.
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 orders inside radio buttons for questions of question type codes 5, 7. 1=show, 0=do not show.
dependentqtns	int	Defines whether this question has dependent questions or not. 1=has dependent questions, 0=no.
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.
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)
newtranslationapi	text	Language ID of the translated text.