Search filter group_by for more than 1 field

Question

Hi:
I'm using Odoo 12 Enterprise. I was wondering if it's posible to add a group by filter by more than 1 field, something like this:
< filter  string= "My Filter"  name= "my_filter"  context= "{'group_by':['field_1','field_2']}" />  I tried it this way and it did not work , Odoo Views Documentation refers in the filter section:
context  a Python dictionary, merged into the action’s domain to generate the
search domain
The key group_by can be used to define a groupby available in the
‘Group By’

Demdoum Walid · Accepted Answer

Baiju KS · Answer

You can Add filter to Favorites like this by code or just add from front-end:- By Credit Note account.invoice.report [('move_type', '=', 'out_refund')] {'group_by': ['invoice_date:month', 'invoice_user_id']}

hosam hamdy · Answer

this kinda of solution by using same name for filters and enable them by default you can get the result of group by state>customer or you can swap filter order in code to get customer>state

you can do in search tag it like this example

<search>
<group string="Group By">
	<filter string="State" name="customer" context="{'group_by': 'state'}"/>
	<filter string="Customer" name="customer" context="{'group_by': 'customer_id'}"/>
group>
</search>

and in model="ir.actions.act_window" enable both on them :

<record id="model_name_action" model="ir.actions.act_window">
	#rest of code
	<field name="context">{'search_default_customer': 1}field>
record>

Dev Prince · Answer

Hi Daniel Almaguer
Check this answer:
https://www.odoo.com/forum/help-1/search-filter-group-by-for-more-than-1-field-148380 [1]
I hope it will help you.
Thank You

[1] https://www%5C.odoo%5C.com/forum/help%5C-1/search%5C-filter%5C-group%5C-by%5C-for%5C-more%5C-than%5C-1%5C-field%5C-148380

Andres Penagos · Answer

many years after, maybe it is usefull for some one...solution working on ver14 enterprise

conceptos liquidados nomina

hr\.payslip\.line
\ \ \ \ \ \ \ \ pivot\ \-\->
\ \ \{'search_default_day':1,
\ \ \ \ \ \ \ \ \ \ 'search_default_concepto':\ 1,
\ \ \ \ \ \ \ \ \ \ 'search_default_dif0':\ 1,
\ \ \}

\ \ \ \ \ \

\ "\ rel="ugc">ir\.ui\.view">
\ \ \ \ hr.payslip.line

afgo · Answer

in Odoo 14 it's not working as well.
It seems still not fixed now, or no plan to fix it. because the error text is : ""group_by" value must be a string" for

context="{'group_by':['field_1','field_2']}"

This question has been flagged

Enjoying the discussion? Don't just read, join in!