Skip to Content
Menu
This question has been flagged
2 Replies
1566 Views

I want to add a filter to group the timesheet tree by a custom field.


This is what I have:


< record id="hr_timesheet_line_my_timesheet_search_ext" model="ir.ui.view">
< field name="name">view.search.my.timesheet.menu.ext< /field>
< field name="model">account.analytic.line< /field>
< field name="inherit_id" ref="hr_timesheet.hr_timesheet_line_my_timesheet_search"/>
< field name="arch" type="xml">
< search string="Timesheet">
< group expand="0" string="Group By">
< filter name="group_by_custom_field" string="Custom Field" icon="terp-partner" context="{'group_by':'custom_field'}"/>
< /group>
< /search>
< /field>
< /record>

But the custom field is not showing in the groupby dropdown.

Thank you


Avatar
Discard
Best Answer

Hi Brend: The custom field needs to be defined as a Stored field if you want to use it for filter/sort/group by. Make sure the store attribute of the field is set to True.

Avatar
Discard
Author

Hi Paresh,
I set store=True already, still the custom field is not showing in the groupby dropdown..

Try using xpath expr="/search" format for the customization instead of just "search". The search view seems to be inherited through multiple levels of inheritance.

Best Answer

Try this ==> < xpath expr="//filter[@name='salesperson']" position="before" >

< filter name="group_by_custom_field" string="Custom Field" icon="terp-partner" context="{'group_by':'custom_field'}"/>

< /xpath>

Avatar
Discard
Author

Still the custom field is not showing in the groupby dropdown..

what is the type of field and your view is loaded in odoo properly?

Author

It's a Datetime field.
What do you mean with view loaded in view?

You have done like this ?

< record id="hr_timesheet_line_my_timesheet_search_ext" model="ir.ui.view">
< field name="name">view.search.my.timesheet.menu.ext< /field>
< field name="model">account.analytic.line< /field>
< field name="inherit_id" ref="hr_timesheet.hr_timesheet_line_my_timesheet_search"/>
< field name="arch" type="xml">
< xpath expr="//filter[@name='filter_name']" position="after" >
< filter name="group_by_custom_field" string="Custom Field" icon="terp-partner" context="{'group_by':'custom_field'}"/>
</xpath>
< /field>
< /record>

Author

Yes, that's exactly what I did

Related Posts Replies Views Activity
2
Jul 24
937
1
Jun 24
3560
1
Oct 23
8578
1
Oct 23
97
1
Aug 23
2192