Odoo is the world's easiest all-in-one management software. It includes hundreds of business apps:
CRM | e-Commerce | Accounting | Inventory | PoS | Project management | MRP | etc.
I would like to filter my clients in a view and only list clients that have services (a custom module).
I tried a lot of things but my view keeps listing the whole and it drives me crazy.
My related view/action:
<record id="view_res_partner_tree" model="ir.ui.view">
<field name="arch" type="xml">
<tree string="Contacts" edit="false" create="false" delete="false">
<field name="display_name" domain="[('got_services', '=', True)]"/>
<button name="generate" type="object" string="Générer" icon="oe_highlight"/>
<record model="ir.actions.act_window" id="action_res_partner">
<field name="name">Génération factures</field>
<field name="view_id" ref="view_res_partner_tree" />
<field name="domain">[('got_services', '=', True)]</field>
My model inherited from res.partner:
_name = 'res.partner'
_inherit = 'res.partner'
got_services = fields.Boolean('Got services', compute='_compute_services')
for record in self:
self.env.cr.execute("SELECT * FROM module_service WHERE id = %d;" % record.id)
res = self.env.cr.fetchall()
record.got_services = False if not res else True
I even added this to mymodule_security.xml in /security
<?xml version="1.0" encoding="utf-8"?>
<record id="module_list_clients" model="ir.rule">
<field name="model_id" ref="model_res_partner"/>
<field name="global" eval="True"/>
<field name="domain_force">[('got_services', '=', True)]</field>
Whatever I try every single clients is printed even if my boolean is correctly set to True or False.
Do you guys have an idea please ?
I'm clearly not a technical expert, but I wonder if this problem isn't related to storing the value of your field.
As explained in our documentation, under "computed fields" https://www.odoo.com/documentation/8.0/reference/orm.html:
computed fields are not stored by default, they are computed and returned when requested. Setting store=True will store them in the database and automatically enable searching
My guess is that not storing the result of the function won't allow you to search (and so to have a domain on the field)
Can you try and keep us aware of your findings?
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
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.Register
Odoo Training Center
Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.Test it now
|Asked: 6/2/15, 12:01 PM|
|Seen: 1551 times|
|Last updated: 6/2/15, 2:47 PM|