Create a custom Filter for relational object
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.