ZestyBeanz Technologies Pvt Ltd 4th Floor, Nila, Technopark Thiruvananthapuram,
India – 695581
Phone: +91 471 4063254
Fax : +91 471 2700171


ZestyBeanz Technologies Pvt Ltd
2987, Manikkath Cross Road
Ravipuram, Kochi, India - 682016
Phone: +91 484 4063254


Zesty Labs
Office # 2003, Millennium Plaza Building
Sheikh Zayed Rd, Dubai, UAE
Phone: +971 4333 2222​
Mobile: +971-56-2708993​


ZestyBeanz Technologies GmbH
Reuterstraße 1
90408 Nürnberg
Fon: +49 911 4801 444
Fax: +49 911 4801 445

Filtering in one2many fields -OpenERP

Contact Form

omalbastin's picture

Filtering in one2many fields -OpenERP

Last week I got into a situation that I really need to use filtering in tree view of one2many field. I have seen the use of filtering in search view, but not in tree view of a one2many field.
Note:this is just an example.
I have created a sale order. Here same product comes 2 or 3 times.

Then I was thinking for a solution... then came to find out that we can pass the filter condition in one2many fields as we provide in search views.

<code><field name="order_line" mode="tree,form" colspan="4" nolabel="1" widget="one2many_list" context="{'group_by':'name'}"></code>

Then I was able to get the filter view.

You just need to provide context="{'group_by':'field_name'}".Here field_name is the name of the field in the tree view of the one_2many field.

Huy's picture

i wanto group by one2many

i wanto group by one2many list work in web client 7.0 , what shold i do ? help !

Huy's picture

i want to group by one2many

i want to group by one2many list in web client of openerp 7.0 all in one , what should i do ? help !'s picture

Howdy I am so glad I found

Howdy I am so glad I found your site, I really found you by error, while I was searching on Google for something else, Anyways I am here now and would just like to say thanks for a remarkable post and a all round exciting blog (I also love the theme/design), I don't have time to read through it all at the moment but I have book-marked it and also included your RSS feeds, so when I have time I will be back to read more, Please do keep up the great work.

Does Plan My Baby Works's picture

Does your site have a contact

Does your site have a contact page? I'm having trouble locating it but, I'd like to send you an e-mail. I've got some creative ideas for your blog you might be interested in hearing. Either way, great blog and I look forward to seeing it improve over time.

The Tao Of Badass Review's picture

Hello, i think that i saw you

Hello, i think that i saw you visited my blog so i came to “return the favor”.I am attempting to find things to improve my website! I suppose its ok to use a few of your ideas!!

Does the tao of Badass Works's picture

Spot on with this write-up, I

Spot on with this write-up, I seriously believe this website needs a great deal more attention. I'll probably be back again to read more, thanks for the info!

Anonymous's picture

Hi, good tutorials thanks. I

Hi, good tutorials thanks.
I try to use this exactly like you do but doesn't wor in GTK or web. Using 6.0.4 version. Editing /sale_view.xml ln 124.

  1. <field colspan="4" mode="tree,form,graph" name="order_line" nolabel="1" widget="one2many_list" context="{'group_by':'name'}">
  2. <code>
  3. Thanks

The Fat Loss Factor Review's picture

At this moment I am going to

At this moment I am going to do my breakfast, afterward having my breakfast coming over again to read more news.

Marcel's picture

Nice post. I was checking

Nice post. I was checking constantly this blog and I'm impressed! Extremely helpful info specially the last part :) I care for such info a lot. I was looking for this certain info for a very long time. Thank you and best of luck.

Does The Fat Loss Factor Works's picture

Heya exceptional website!

Heya exceptional website! Does running a blog such as this take a great deal of work? I've no understanding of coding however I had been hoping to start my own blog soon. Anyway, should you have any ideas or techniques for new blog owners please share. I know this is off subject however I just had to ask. Many thanks!