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.