Odoo Help

0

What is the first day of each of these columns in a pivot table?

By
Pascal Tremblay
on 3/7/17, 10:39 AM 1,063 views

Hello all,

We have here a new pivot table which is defined with the xml below. Note the "interval='week'" in it.

For each column (each week), what is the first day of the week?

Can we change the first day of the week?


XML

<record id="view_account_invoice_report_hebdo_graph_vtm2" model="ir.ui.view">
         <field name="name">account.invoice.report.hebdo.graph.vtm2</field>
         <field name="model">account.invoice.report.vtm2</field>
         <field name="arch" type="xml">
             <graph string="Invoices Analysis" type="pivot">
                 <field name="fiscal_position" type="row"/>
                 <field name="date" interval="week" type="col"/>
                 <field name="price_total" type="measure"/>
             </graph>
         </field>
    </record>


Image




0

Pascal Tremblay

--Pascal Tremblay--
1839
| 5 3 7
Alma, Canada
--Pascal Tremblay--


Pascal Tremblay
On 3/7/17, 11:53 AM

I created a new filter on the invoice tree view. Invoices are now grouped by week.

Since the invoice with the date 2017-03-05 (a sunday) is in the week W9;

Since the invoice with the date 2017-03-06 (a monday) is in the week W10;

Then Odoo seems to consider monday as the first day of the week.

One question persists : could we change this comportment to get sunday as the first day of the week?


Image





About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

Register

Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)

Stats

Asked: 3/7/17, 10:39 AM
Seen: 1063 times
Last updated: 3/10/17, 1:27 PM