---
title: "question (Odoo)"
description: "itgen_odoo_question"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/odoo/Odoo.survey.question
original: https://documentation.invantive.eu/en/datamodels/odoo/Odoo.survey.question
updated: 2023-03-01T15:29:04Z
license: https://documentation.invantive.eu/en/
---

# question: Odoo itgen_odoo_question

`read only` `per partition`

- Catalog: `Odoo`
- Schema: `survey`
- Label: itgen_odoo_question

Survey Question

Can only retrieve data.

## Summary

Questions that will be asked in a survey.

        Each question can have one of more suggested answers (eg. in case of
        multi-answer checkboxes, radio buttons...).

        Technical note:

        survey.question is also the model used for the survey's pages (with the "is_page" field set to True).

        A page corresponds to a "section" in the interface, and the fact that it separates the survey in
        actual pages in the interface depends on the "questions_layout" parameter on the survey.survey model.
        Pages are also used when randomizing questions. The randomization can happen within a "page".

        Using the same model for questions and pages allows to put all the pages and questions together in a o2m field
        (see survey.survey.question_and_page_ids) on the view side and easily reorganize your survey by dragging the
        items around.

        It also removes on level of encoding by directly having 'Add a page' and 'Add a question'
        links on the tree view of questions, enabling a faster encoding.

        However, this has the downside of making the code reading a little bit more complicated.
        Efforts were made at the model level to create computed fields so that the use of these models
        still seems somewhat logical. That means:
        - A survey still has "page_ids" (question_and_page_ids filtered on is_page = True)
        - These "page_ids" still have question_ids (questions located between this page and the next)
        - These "question_ids" still have a "page_id"

        That makes the use and display of these information at view and controller levels easier to understand.

## Table Columns

The columns of the table `question` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `allowed_triggering_question_ids` | `varchar2` |  | [ ] |  |  |
| `answer_date` | `datetime` | Correct date answer | [ ] |  | Correct date answer for this question. |
| `answer_datetime` | `datetime` | Correct datetime answer | [ ] |  | Correct date and time answer for this question. |
| `answer_numerical_box` | `numeric` | Correct numerical answer | [ ] |  | Correct number answer for this question. |
| `answer_score` | `numeric` | Score | [ ] |  | Score value for a correct answer to this question. |
| `background_image` | `varbinary` | Background Image | [ ] |  |  |
| `background_image_url` | `varchar2` | Background Url | [ ] |  |  |
| `comment_count_as_answer` | `boolean` | Comment is an answer | [ ] |  |  |
| `comments_allowed` | `boolean` | Show Comments Field | [ ] |  |  |
| `comments_message` | `varchar2` | Comment Message | [ ] |  |  |
| `constr_error_msg` | `varchar2` | Error message | [ ] |  |  |
| `constr_mandatory` | `boolean` | Mandatory Answer | [ ] |  |  |
| `create_date` | `datetime` | Created on | [ ] |  |  |
| `create_uid` | `varchar2` |  | [ ] |  |  |
| `create_uid_label` | `varchar2` |  | [ ] |  |  |
| `description` | `varchar2` | Description | [ ] |  | Use this field to add additional explanations about your question or to illustrate it with pictures or a video |
| `display_name` | `varchar2` | Display Name | [ ] |  |  |
| `id` | `int32` | ID | [ ] |  |  |
| `is_conditional` | `boolean` | Conditional Display | [ ] |  | If checked, this question will be displayed only         if the specified conditional answer have been selected in a previous question |
| `is_page` | `boolean` | Is a page? | [ ] |  |  |
| `is_placed_before_trigger` | `boolean` | Is misplaced? | [ ] |  | Is this question placed before its trigger question? |
| `is_scored_question` | `boolean` | Scored | [ ] |  | Include this question as part of quiz scoring. Requires an answer and answer score to be taken into account. |
| `is_time_limited` | `boolean` | The question is limited in time | [ ] |  | Currently only supported for live sessions. |
| `matrix_row_ids` | `varchar2` |  | [ ] |  | Labels used for proposed choices: rows of matrix |
| `matrix_subtype` | `varchar2` | Matrix Type | [ ] |  |  |
| `page_id` | `varchar2` |  | [ ] |  |  |
| `page_id_label` | `varchar2` |  | [ ] |  |  |
| `question_ids` | `varchar2` |  | [ ] |  |  |
| `question_placeholder` | `varchar2` | Placeholder | [ ] |  |  |
| `question_type` | `varchar2` | Question Type | [ ] |  |  |
| `questions_selection` | `varchar2` | Question Selection | [ ] |  | If randomized is selected, add the number of random questions next to the section. |
| `random_questions_count` | `int32` | # Questions Randomly Picked | [ ] |  | Used on randomized sections to take X random questions from all the questions of that section. |
| `save_as_email` | `boolean` | Save as user email | [ ] |  | If checked, this option will save the user's answer as its email address. |
| `save_as_nickname` | `boolean` | Save as user nickname | [ ] |  | If checked, this option will save the user's answer as its nickname. |
| `scoring_type` | `varchar2` | Scoring Type | [ ] |  |  |
| `sequence` | `int32` | Sequence | [ ] |  |  |
| `suggested_answer_ids` | `varchar2` |  | [ ] |  | Labels used for proposed choices: simple choice, multiple choice and columns of matrix |
| `survey_id` | `varchar2` |  | [ ] |  |  |
| `survey_id_label` | `varchar2` |  | [ ] |  |  |
| `time_limit` | `int32` | Time limit (seconds) | [ ] |  |  |
| `title` | `varchar2` | Title | [x] |  |  |
| `triggering_answer_id` | `varchar2` |  | [ ] |  | Answer that will trigger the display of the current question. |
| `triggering_answer_id_label` | `varchar2` |  | [ ] |  | Answer that will trigger the display of the current question. |
| `triggering_question_id` | `varchar2` |  | [ ] |  | Question containing the triggering answer to display the current question. |
| `triggering_question_id_label` | `varchar2` |  | [ ] |  | Question containing the triggering answer to display the current question. |
| `user_input_line_ids` | `varchar2` |  | [ ] |  |  |
| `validation_email` | `boolean` | Input must be an email | [ ] |  |  |
| `validation_error_msg` | `varchar2` | Validation Error | [ ] |  |  |
| `validation_length_max` | `int32` | Maximum Text Length | [ ] |  |  |
| `validation_length_min` | `int32` | Minimum Text Length | [ ] |  |  |
| `validation_max_date` | `datetime` | Maximum Date | [ ] |  |  |
| `validation_max_datetime` | `datetime` | Maximum Datetime | [ ] |  |  |
| `validation_max_float_value` | `numeric` | Maximum value | [ ] |  |  |
| `validation_min_date` | `datetime` | Minimum Date | [ ] |  |  |
| `validation_min_datetime` | `datetime` | Minimum Datetime | [ ] |  |  |
| `validation_min_float_value` | `numeric` | Minimum value | [ ] |  |  |
| `validation_required` | `boolean` | Validate entry | [ ] |  |  |
| `write_date` | `datetime` | Last Updated on | [ ] |  |  |
| `write_uid` | `varchar2` |  | [ ] |  |  |
| `write_uid_label` | `varchar2` |  | [ ] |  |  |



## Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver:

- [Odoo](/en/release-notes/drivers?driver=odoo)

