====== 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. ^ **Sr. No.** ^ **Name** ^ **Type** ^ **Comments** ^ | 1 | **id** | Primary | ID of questionnaire details table (auto-incremented). | | 2 | **qid** | Index | ID of the questionnaire header table. | | 3 | **branchid** | Index | ID of the branch related to the questionnaire. | | 4 | **majorqid** | Index | Series number for questions. | | 5 | **minorqid** | Index | Series number for aspect type questions. | | 6 | **displayorder** | int | Defines the display order of the question. | | 7 | **surveypageno** | int | The survey page number where the question appears. | | 8 | **cscategoryord** | int | This category must be set when there is a CS (Client Sheet) category. | | 9 | **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. | | 10 | **dualaspects** | int | 1=Show Aspect question text both sides of options (like dual X-axis), 0=Normal Aspect question display. | | 11 | **startdate** | date | The start date of the questionnaire. | | 12 | **enddate** | date | The end date of the questionnaire. | | 13 | **displaycondition** | varchar(200) | Conditions for displaying the question. | | 14 | **displayparams** | text | Additional parameters for displaying the question. | | 15 | **qtextdisplaycond** | varchar(200) | Display condition for question text. | | 16 | **qtextdisplayparams** | text | Query param condition to show the selected question text. This query returns the required index of an array which is formed by exploding the question with "**^**". | | 17 | **optiondisplayparams** | text | Condition to show only selected options, which meet the conditions defined in column "optiondisplayparamcond" in `fw_questionoptions`. | | 18 | **ansqdetailids** | varchar(200) | Id of answers of questionnaire details. | | 19 | **extrabaringraphs** | varchar(250) | For NPS, CES, EPS, GEM. | | 20 | **status** | int | 1=active, 0=inactive, 2=archive. | | 21 | **mandatory** | int | Make open-answer questions mandatory. 0=Nothing. | | 22 | **importdatamandatory** | int | Make questions mandatory in import data. 0=Nothing. | | 23 | **hidebackbtn** | int | If set to 1, hides the back button in the survey; if 0, the back button is shown. | | 24 | **spectrumview** | varchar(50) | Configure either horizontal or vertical. | | 25 | **showcolorincsheet** | int | Whether to show colors in the client sheet. 1 = Show color, 0 = Do not show color. | | 26 | **optiondisplayordertype** | varchar(100) | Defines whether options are in option-number order or random with exclusion of any option. Excluded options contain `**rand()^**`. | | 27 | **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()^**`. | | 28 | **minansopt** | int | If this column contains not equal to zero then there should be a restriction for number of options to be chosen. | | 29 | **maxansopt** | int | If this column contains not equal to zero then there should be a restriction for number of options to be chosen. | | 30 | **ghostquestion** | int | 0=Normal question, 1=Last question. | | 31 | **optionquery** | text | Stores query to fetch options which are not from the option table. | | 32 | **updateparms** | text | First param is table name, second param is column name and last param is condition. | | 33 | **questionimg** | longblob | Stores the image of the question. | | 34 | **questionimgorder** | int | Defines the order of the question image if there are multiple images. | | 35 | **shownumbers** | int | Used to show option orders inside radio buttons for questions of question type codes 5, 7. 1=show, 0=do not show. | | 36 | **dependentqtns** | int | Defines whether this question has dependent questions or not. 1=has dependent questions, 0=no. | | 37 | **hideinsurvey** | int | Defines whether this question should be hidden in the survey. 1 = Hide, 0 = Show. | | 38 | **enablestarrating** | int | Whether star rating is enabled for the question. | | 39 | **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. | | 40 | **saveandreloadsurvey** | int | If set to 1, saves the entered data and reloads the page with updated answers. | | 41 | **invisiblequestion** | int | The question is printed in the questionnaire but not displayed in the survey. Typically used for question type code 9. | | 42 | **noofrowsforcomment** | int | Number of rows for comment input. Default is 8 rows. | | 43 | **showNEVafterthis** | varchar(250) | | | 44 | **newtranslationapi** | text | Language ID of the translated text. |