Odoo Help


Create a custom Filter for relational object

Faheem Khan
on 9/1/15, 4:46 AM 1,233 views

I want to create a custom filter for a relational field as below.

In account.voucher model I need to filter queries based on customer tag and salesperson (category_id and user_id in res.partner), how can I achieve this task in debug view.

Same situation in sale order tree view. Filter sale orders based on customer tag (category_id in res.partner).



Customer A ~ F have a tag ('category_id' field in partner model) 'Urban Customer'.

Customer G ~ Z have a tag ('category_id' field in partner model) 'Rural Customer'.

Now I want to search payments recieved from 'Urban customer' only in "customer Payment" ("account_voucher" model), same as for 'rural customer'.

Below is an image for customer category.

Hope you got my point.

You can add filter in search view. Like sample http://preview.tinyurl.com/ng7gzcl

on 9/1/15, 8:30 AM

This is not the answer. I already know how to access debug mode. Question is how to create this specific filter where model is account.voucher and filter should come from partner tag. I need syntax.

Faheem Khan
on 9/1/15, 8:48 AM

Anil R. Kesariya

--Anil R. Kesariya--
| 6 5 8
Rajkot, India
--Anil R. Kesariya--

Odoo Techno Functional Expert

* Engaged with odoo since May - 2012.

* Customise existing module or develop new module base on customer requirement.

* Played key developer role in many past and running projects.

* Expert in requirement gathering of business and transforming requirement into odoo platform.

* Major expertise in core modules, database, report development and theme development.

* Integration expert.

Linkedin  : https://in.linkedin.com/in/anil-kesariya-97b20a66

Anil R. Kesariya
On 9/1/15, 11:03 AM

Hi Faheem,

Customer filter is already there inside the filters.

Do you want to set default filter as customer when you see any vouchers like customer payment ?

So by applying default filter you have to override the Action of Customer Payment to Set Default filter as Customer. so your vouchers will be filtered/ grouped by customers.

Same thing you can apply for Supplier Payment.

These stuff you will find inside account_voucher module.

Here is the syntax to apply default filter this this line inside the existing actions or by overrding action in your module.

<field name="context">{'default_customer_filter_name':1}</field>

If i goes in wrong way than please give more description about your question.

Hope this might help.



Thanks for your help but it could not help me. I have updated my question to describe my problem in depth. Please read it again and guide me to solve the issue..

Faheem Khan
on 9/1/15, 11:52 AM

@Faheem: If you are talking about base category field than it is many2many field you can't directly group with many2many field. or else add your field as many2one and add it as filter by overriding search view than your customer will be filtered base on that field.

Anil R. Kesariya
on 9/1/15, 1:05 PM

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.


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)


Asked: 9/1/15, 4:46 AM
Seen: 1233 times
Last updated: 9/1/15, 11:50 AM