Skip to Content
This question has been flagged
viewsearchgroup_by
2 Respostes
10462 Vistes
Avatar
Prakash

In Openerp 7 Form Search view Group by Date Shows in the below Format:-

October 2013
November 2013
December 2013

How to change the date format in List view ? Group by.

In reports can use change date format using the sql query to_char(order_date, 'MM-DD-YYYY') as order_date,

But in the Form list view Group by how to change date format?

Thanks

Avatar
Descartar
Avatar
Solanki Shamji
Best Answer

Hello,

Check with this may be it will help you or you can get idea

<filter string="Order Month" domain="[]" context="{'group_by':'date_order:day'}"/>

Avatar
Descartar
KIT Solutions

can i show weekday instead of :day it gave me error in context i want to show weekday abbr too

Avatar
Rihene
Best Answer

Add a filter in your XML like this:

<record id="view_xxx_filter" model="ir.ui.view">

<field name="model">xxxxx</field>

<field name="arch" type="xml">

<search string="XXXX">

<field name="order_date"/>  

<group expand="0" string="Group By...">

<filter string="Date Order" icon="terp-personal" domain="[]" context="{'group_by':'order_date'}"/> 

</group>

</search>

</field>

</record>

Regards.

Avatar
Descartar
Related Posts Respostes Vistes Activitat
Search View: How to search all fields of contacts?
view search
Avatar
1
de maig 18
8555
How to add a group by to search view of product?
search group_by
Avatar
Avatar
1
de maig 16
7974
Search in Portal template odoo 16
view search portal
Avatar
1
de jul. 23
1809
How to edit search view with inheritance
view inheritance search
Avatar
Avatar
Avatar
2
d’abr. 21
15317
Date search in Odoo8 forms
view search filter_domain
Avatar
0
de des. 16
2474