user_input: Odoo itgen_odoo_user_input
read only per partition
- Catalog:
Odoo - Schema:
survey - Label: itgen_odoo_user_input
Survey User Input
Can only retrieve data.
Summary
Metadata for a set of one user's answers to a particular survey
Table Columns
The columns of the table user_input 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 |
|---|---|---|---|---|---|
access_ |
varchar2 |
Identification token | |||
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
||||
activity_ |
datetime |
Next Activity Deadline | |||
activity_ |
varchar2 |
Activity Exception Decoration | Type of the exception activity on record. | ||
activity_ |
varchar2 |
Icon | Icon to indicate an exception activity. | ||
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
Activity State | Status based on activities Overdue: Due date is already passed Today: Activity date is today Planned: Future activities. | ||
activity_ |
varchar2 |
Next Activity Summary | |||
activity_ |
varchar2 |
Activity Type Icon | Font awesome icon e.g. fa-tasks | ||
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
||||
attempts_ |
int32 |
Attempts Count | |||
attempts_ |
int32 |
Number of attempts | |||
attempts_ |
int32 |
Attempt n° | |||
create_ |
datetime |
Created on | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
deadline |
datetime |
Deadline | Datetime until customer can open the survey and submit answers | ||
display_ |
varchar2 |
Display Name | |||
email |
varchar2 |
||||
end_ |
datetime |
End date and time | |||
has_ |
boolean |
Has Message | |||
id |
int32 |
ID | |||
invite_ |
varchar2 |
Invite token | |||
is_ |
boolean |
Limited number of attempts | Check this option if you want to limit the number of attempts per user | ||
is_ |
boolean |
Is in a Session | Is that user input part of a survey session or not. | ||
last_ |
varchar2 |
||||
last_ |
varchar2 |
||||
message_ |
int32 |
Attachment Count | |||
message_ |
varchar2 |
||||
message_ |
boolean |
Message Delivery error | If checked, some messages have a delivery error. | ||
message_ |
int32 |
Number of errors | Number of messages with delivery error | ||
message_ |
boolean |
SMS Delivery error | If checked, some messages have a delivery error. | ||
message_ |
varchar2 |
||||
message_ |
boolean |
Is Follower | |||
message_ |
varchar2 |
||||
message_ |
varchar2 |
||||
message_ |
boolean |
Action Needed | If checked, new messages require your attention. | ||
message_ |
int32 |
Number of Actions | Number of messages which requires an action | ||
message_ |
varchar2 |
||||
my_ |
datetime |
My Activity Deadline | |||
nickname |
varchar2 |
Nickname | Attendee nickname, mainly used to identify them in the survey session leaderboard. | ||
partner_ |
varchar2 |
||||
partner_ |
varchar2 |
||||
predefined_ |
varchar2 |
||||
question_ |
boolean |
Question Time Limit Reached | |||
scoring_ |
numeric |
Score (%) | |||
scoring_ |
boolean |
Quizz Passed | |||
scoring_ |
numeric |
Total Score | |||
scoring_ |
varchar2 |
Scoring | |||
slide_ |
varchar2 |
The related course slide when there is no membership information | |||
slide_ |
varchar2 |
The related course slide when there is no membership information | |||
slide_ |
varchar2 |
Slide membership information for the logged in user | |||
slide_ |
varchar2 |
Slide membership information for the logged in user | |||
start_ |
datetime |
Start date and time | |||
state |
varchar2 |
Status | |||
survey_ |
varchar2 |
||||
survey_ |
varchar2 |
||||
survey_ |
boolean |
Survey Time Limit Reached | |||
test_ |
boolean |
Test Entry | |||
user_ |
varchar2 |
||||
website_ |
varchar2 |
Website communication history | |||
write_ |
datetime |
Last Updated on | |||
write_ |
varchar2 |
||||
write_ |
varchar2 |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: