-
Uncategorized
-
1-How to Install Pycharm and Configure PostgreSQL on Ubuntu
-
2-How to Configure Odoo 13 on Pycharm Ubuntu
-
3-Components and Structure of Odoo 13 Module
-
4-How to Create an Empty Module Structure Scaffold Command in Odoo 13
-
5-Building a module in Odoo 13
-
6-Relations Between Models on Odoo: Many2One Fields in Odoo 13
-
7-Relations Between Models in Odoo: One2Many Fields in Odoo 13
-
8-Relations Between Models in Odoo: Many2Many Fields in Odoo 13
-
9-Inheritance - Traditional Class Inheritance in Odoo 13
-
10-Inheritance - Traditional Prototype Inheritance in Odoo 13
-
11-Inheritance - Delegation Inheritance in Odoo 13
-
12-View Inheritance in Odoo 13
-
13-Computed fields and @api.depends in Odoo 13
-
14-Setting Default Value for Fields in Odoo 13
-
15-Onchange mechanism - @api.onchange in Odoo 13
-
16-Model Constraints - Python Constraints in Odoo 13
-
17-Model Constraints - SQL Constraints in Odoo 13
-
18-Tree View Decoration Attribute in odoo 13
-
19-Advanced Views - Calendar View in Odoo 13
-
20-Advanced Views - Search View in Odoo 13
-
21-Advanced Views - Gantt View in Odoo 13
-
22-Pivot View in Odoo
-
23-Graph View in Odoo
-
24-Kanban View in Odoo 13
-
25-Pivot View in Odoo
-
26-Security - Groups and access rights in Odoo
-
27-Wizards - Defining and Launching in Odoo
-
28-Odoo Development - URL Actions in Odoo 13
-
29-Odoo Development - Server Actions in Odoo 13
-
30-Odoo Development - Automated Actions in Odoo 13
-
QZhub - Odoo+BIM
-
25-Pivot View in Odoo
This video explains about the pivot view in odoo. In Pivot view, data can be represented as tables, a dynamic analysis matrix.
Pivot view repeatedly generates table dynamically, while changing the field or row or column. The user can select the row and column field to represent the table. Each time when a user changes the fields, it calls corresponding SQL queries and produces tables accordingly. So Pivot tables are called as dynamic analysis matrix.
Get the module from our repository: https://github.com/CybroOdoo/openacademy
The pivot view is used to visualize aggregations as a pivot table. Its root element is 〈pivot〉 which can take the following attributes:
disable_linking
Set to True to remove table cell’s links to list view.
display_quantity
Set to true to display the Quantity column by default.
default_order
The name of the measure and the order (asc or desc) to use as default order in the view.
name (required)
the name of a field to use in the view. If used for grouping (rather than aggregating)
string
the name that will be used to display the field in the pivot view, overrides the default python String attribute of the field.
type
indicates whether the field should be used as a grouping criteria or as an aggregated value within a group. Possible values are:
row (default)
groups by the specified field, each group gets its own row.
col
creates column-wise groups
measure
field to aggregate within a group
interval
on date and datetime fields, groups by the specified interval (day, week, month, quarter or year) instead of grouping on the specific datetime (fixed second resolution) or date (fixed day resolution).
invisible
if true, the field will not appear either in the active measures nor in the selectable measures (useful for fields that do not make sense aggregated, such as fields in different units, e.g. € and $).
#odoodevelopment #odootutorials #odoo13
For More Videos Subscribe to our YouTube channel.
Visit our company website: https://www.cybrosys.com/
Connect with us:
Facebook: http://ow.ly/Ty0Q30lc5TU
twitter: http://ow.ly/s5cV30lc5Vc
LinkedIn: http://ow.ly/GJfg30lc5WT
Pinterest: http://bit.ly/2I2b5N0
About Us
Cybrosys is enriched with technical experts and research scholars producing high-end quality software tools. Our sophisticated infrastructure and lab facilities constantly bring in new technological innovations and attributions. Partnership with ODOO, MICROSOFT, IBM, Intel, HP, NASSCOM proves our strength and excellence.
We are Odoo Gold Partners standing par excellence in Odoo Implementation, Customization, and allied services. We do Source code sale, Custom software development, and Employee outsourcing. The latest research and developments in Cybrosys are being conducted in Blockchain. Our robust quality product and services are widely used by clients residing across in India, USA, UK, Middle East & Europe.
Pivot view repeatedly generates table dynamically, while changing the field or row or column. The user can select the row and column field to represent the table. Each time when a user changes the fields, it calls corresponding SQL queries and produces tables accordingly. So Pivot tables are called as dynamic analysis matrix.
Get the module from our repository: https://github.com/CybroOdoo/openacademy
The pivot view is used to visualize aggregations as a pivot table. Its root element is 〈pivot〉 which can take the following attributes:
disable_linking
Set to True to remove table cell’s links to list view.
display_quantity
Set to true to display the Quantity column by default.
default_order
The name of the measure and the order (asc or desc) to use as default order in the view.
name (required)
the name of a field to use in the view. If used for grouping (rather than aggregating)
string
the name that will be used to display the field in the pivot view, overrides the default python String attribute of the field.
type
indicates whether the field should be used as a grouping criteria or as an aggregated value within a group. Possible values are:
row (default)
groups by the specified field, each group gets its own row.
col
creates column-wise groups
measure
field to aggregate within a group
interval
on date and datetime fields, groups by the specified interval (day, week, month, quarter or year) instead of grouping on the specific datetime (fixed second resolution) or date (fixed day resolution).
invisible
if true, the field will not appear either in the active measures nor in the selectable measures (useful for fields that do not make sense aggregated, such as fields in different units, e.g. € and $).
#odoodevelopment #odootutorials #odoo13
For More Videos Subscribe to our YouTube channel.
Visit our company website: https://www.cybrosys.com/
Connect with us:
Facebook: http://ow.ly/Ty0Q30lc5TU
twitter: http://ow.ly/s5cV30lc5Vc
LinkedIn: http://ow.ly/GJfg30lc5WT
Pinterest: http://bit.ly/2I2b5N0
About Us
Cybrosys is enriched with technical experts and research scholars producing high-end quality software tools. Our sophisticated infrastructure and lab facilities constantly bring in new technological innovations and attributions. Partnership with ODOO, MICROSOFT, IBM, Intel, HP, NASSCOM proves our strength and excellence.
We are Odoo Gold Partners standing par excellence in Odoo Implementation, Customization, and allied services. We do Source code sale, Custom software development, and Employee outsourcing. The latest research and developments in Cybrosys are being conducted in Blockchain. Our robust quality product and services are widely used by clients residing across in India, USA, UK, Middle East & Europe.
Views | |
---|---|
4149 | Total Views |
0 | Members Views |
4149 | Public Views |
Share by mail
Please login to share this video by email.