invantive documentation
Invantive Support ForumsLog In / Sign Up

visitor: Odoo itgen_odoo_visitor

read only per partition

  • Catalog: Odoo
  • Schema: website
  • Label: itgen_odoo_visitor

Website Visitor

Can only retrieve data.

Table Columns

The columns of the table visitor 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_token varchar2 Access Token
country_flag varchar2 Country Flag Url of static flag image
country_id varchar2
country_id_label varchar2
create_date datetime First Connection
create_uid varchar2
create_uid_label varchar2
display_name varchar2 Display Name
email varchar2 Email
event_registered_ids varchar2
event_registration_count int32 # Registrations
event_registration_ids varchar2
has_push_notifications boolean Push Notifications Enabled
id int32 ID
is_connected boolean Is connected ? A visitor is considered as connected if his last page view was within the last 5 minutes.
lang_id varchar2 Language from the website when visitor has been created
lang_id_label varchar2 Language from the website when visitor has been created
last_connection_datetime datetime Last Connection Last page view date
last_visited_page_id varchar2
last_visited_page_id_label varchar2
lead_count int32 # Leads
lead_ids varchar2
livechat_operator_id varchar2
livechat_operator_id_label varchar2
livechat_operator_name varchar2 Operator Name
mail_channel_ids varchar2
mobile varchar2 Mobile
name varchar2 Name
page_count int32 # Visited Pages Total number of tracked page visited
page_ids varchar2
partner_id varchar2 Partner of the last logged in user.
partner_id_label varchar2 Partner of the last logged in user.
partner_image varbinary Image
product_count int32 Products Views Total number of product viewed
product_ids varchar2
push_subscription_ids varchar2
session_count int32 # Sessions
time_since_last_action varchar2 Last action Time since last page view. E.g.: 2 minutes ago
timezone varchar2 Timezone
visit_count int32 # Visits A new visit is considered if last connection was more than 8 hours ago.
visitor_page_count int32 Page Views Total number of visits on tracked pages
visitor_product_count int32 Product Views Total number of views on products
website_id varchar2
website_id_label varchar2
website_track_ids varchar2
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: