This is an old revision of the document!

Introduction:

The QuestionOptionsLang table is responsible for storing multilingual text data for the options (answer choices) associated with each question option in the survey. This table allows each option to have different text based on the language selected by the respondent.

It contains multiple versions of the option text, including:

Graph Option Name: Text used in graphical reports.
Report Option Name: Text shown in the downloadable reports.
Import Option Name: Text displayed when importing the survey data.
Open Answer Name: Text for open-ended responses associated with the option.

The table is linked to the QuestionnaireDetailsOptions table via the optionid column and supports multilingual data based on the language column.

Below is the detailed structure of the QuestionOptionsLang table along with descriptions.

Sr. No.	Name	Type	Description	Comments
1	id	int	Unique identifier for each language record for the option.	AUTO_INCREMENT
2	optionid	int	Foreign key referring to the id of the fw_questionnaireoptions table.	Links the language text to a specific option.
3	language	varchar(20)	Stores the language code for the option text.	Example: 'EN', 'NL', 'FR', etc.
4	optionname	varchar(250)	Contains the option text shown to the respondent in the survey.	This text varies based on language.
5	graphoptionname	varchar(250)	Text used in graphical reports for representing the option.	This is often a shorter or summarized version of the option text.
6	reportoptionname	varchar(300)	Text that appears in downloadable reports when this option is selected.	Can differ from the survey option text to make the report easier to understand.
7	importoptionname	varchar(300)	Text shown during the importing of survey data for the option.	This text appears as the column header in import files.
8	importopenansname	varchar(300)	Text shown in the import file when capturing open text answers for this option.	Appears as a separate column header for open text responses.
9	reportopenansname	varchar(300)	Text used in downloadable reports when displaying open-ended responses.	Ensures clarity in the report for open answers.
10	addedfrommodlangsettings	int	Indicates if the option text was added automatically from Module Language Settings.	0 = Manually added, 1 = Automatically added.