article: Odoo itgen_odoo_article
read only per partition
- Catalog:
Odoo - Schema:
knowledge - Label: itgen_odoo_article
Knowledge Article
Can only retrieve data.
Table Columns
The columns of the table article 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 |
|---|---|---|---|---|---|
active |
boolean |
Active | |||
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 |
||||
article_ |
varchar2 |
||||
article_ |
varchar2 |
Properties | |||
article_ |
varchar2 |
Article Item Properties | |||
article_ |
boolean |
Is Property Field Empty? | |||
article_ |
varchar2 |
Article URL | |||
body |
varchar2 |
Body | |||
can_ |
boolean |
Can Publish | |||
category |
varchar2 |
Section | Used to categozie articles in UI, depending on their main permission definitions. | ||
child_ |
varchar2 |
||||
cover_ |
varchar2 |
||||
cover_ |
varchar2 |
||||
cover_ |
varchar2 |
Cover url | |||
create_ |
datetime |
Created on | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
deletion_ |
datetime |
Deletion Date | |||
display_ |
varchar2 |
Display Name | |||
favorite_ |
int32 |
#Is Favorite | |||
favorite_ |
varchar2 |
||||
full_ |
boolean |
Full width | When set, the article body will take the full width available on the article page. Otherwise, the body will have large horizontal margins. | ||
has_ |
boolean |
Has normal article children? | |||
has_ |
boolean |
Has article item children? | |||
has_ |
boolean |
Is the parent an Item ? | |||
has_ |
boolean |
Has Message | |||
icon |
varchar2 |
Emoji | |||
id |
int32 |
ID | |||
inherited_ |
varchar2 |
Inherited Permission | |||
inherited_ |
varchar2 |
||||
inherited_ |
varchar2 |
||||
internal_ |
varchar2 |
Internal Permission | Default permission for all internal users. (External users can still have access to this article if they are added to its members) | ||
is_ |
boolean |
Is Item? | |||
is_ |
boolean |
Desyncronized with parents | If set, this article won't inherit access rules from its parents anymore. | ||
is_ |
boolean |
Locked | When locked, users cannot write on the body or change the title, even if they have write access on the article. | ||
is_ |
boolean |
Is Published | |||
is_ |
boolean |
Is Favorited | |||
last_ |
datetime |
Last Edited on | |||
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 | |||
name |
varchar2 |
Title | |||
parent_ |
varchar2 |
||||
parent_ |
varchar2 |
||||
parent_ |
varchar2 |
Parent Path | |||
root_ |
varchar2 |
The subject is the title of the highest parent in the article hierarchy. | |||
root_ |
varchar2 |
The subject is the title of the highest parent in the article hierarchy. | |||
sequence |
int32 |
Sequence | The sequence is computed only among the articles that have the same parent. | ||
to_ |
boolean |
Trashed | When sent to trash, articles are flagged to be deleted days after last edit. knowledge_article_trash_limit_days config parameter can be used to modify the number of days. (default is 30) | ||
user_ |
boolean |
Can Read | |||
user_ |
boolean |
Can Write | |||
user_ |
int32 |
User Favorite Sequence | |||
user_ |
boolean |
Has Access | |||
user_ |
boolean |
Has Write Access | |||
user_ |
varchar2 |
User permission | |||
website_ |
varchar2 |
Website communication history | |||
website_ |
boolean |
Visible on current website | |||
website_ |
varchar2 |
Website URL | The full URL to access the document through the website. | ||
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: