Skip to Content
This question has been flagged
domainviewmany2many
16 Replies
34312 Views
Avatar
Vivekrajan Rayappan

Hello,

Is it a way to use domain on many2many field on openerp v6.1?

Here is my object : Code:

class user(osv.osv):

_columns={
    'group_ids':fields.many2many('custom_module.group', 'custom_module_group_user_rel', 'user_id', 'group_id', 'Groups'), 
}
user()

class group(osv.osv):

_columns={
    'user_ids':fields.many2many('custom_module.group', 'custom_module_group_user_rel', 'group_id', 'user_id', 'Users'), 
}
group()

I have added these fields on the views and it works fine. My problem is that I'd like to select only users who are in a specific group but I can't find the correct domain to apply.

Here is my view : Code:

<record ..>
...
<field name="name"/>
<field name="group_id"/>
<field name="user_id" domain="[('id','in', [group_id.user_ids]])]"/>
...
</record>

I would like that by selecting a group, the user could only select a user in this group.

Does somebody know what is wrong with my domain ? Or is it possible ?

Avatar
Discard
Sam path

Hi vivek, you found any solution? even i'm facing the same problem please help me out

Sehrish

Domain on many2many field: http://bit.ly/2DarOfB

Avatar
Mohammad Alhashash
Best Answer

Try this

  ...
  <field name="user_id" domain="[('groupd_ids','=', group_id)]"/>
  ...
Avatar
Discard
Vivekrajan Rayappan
Author

Hi Mohammad,

Thanks for your reply. Your suggestion does not work.

Please see the logic inside your filter

<field name="user_id" domain="[('groupd_ids','=', group_id)]"/>

[field name="user_id" domain="[([1,3,4],'=',[1])]

This does not work. Please suggest me something else.

instead of '=' operator, if you have something like 'group_ids','has','group_id', it can work. But we dont have any such operator.

please suggest me a work around to achieve this.

Thank you

Vivekrajan Rayappan
Author

Hi, i found a link : http://forum.openerp.com/forum/topic23503.html , but I am not able to use that. If you could give me a sample code, It would be great. Please do the needful

Mohammad Alhashash

Actually x2many field handling in left-hand side of domains does not work as you think. You may have to quote the right-hand side ('group_id' instead of group_id). Check it and tell me the result.

Vivekrajan Rayappan
Author

that is also not working. Please see this link and tell me if tat works. http://forum.openerp.com/forum/topic23503.html

Vivekrajan Rayappan
Author

Please somebody help me on this.. I am in a big trouble

Mohammad Alhashash

My answer works in v7.0. I'm not sure about version 6.1. Sorry.

Mohammad Alhashash

It should work too in 6.1. Check the line: &lt;field name="stage_id" domain="section_id and [('section_ids', '=', section_id)] or []" /&gt; in addons/cr,/crm_lead_view.xml

Avatar
ClueLogics Technologies Pvt. Ltd.
Best Answer

Always use  in operator in domain if you seems need to check more then one such as many2many.



it shoud be domain="[('group_ids','in',[group_id])]"

Avatar
Discard
Avatar
Vivekrajan Rayappan
Author Best Answer

Hi Mohammad,

The answer you provided is the right one to filter based on many2many. I actually had the same domain filter in my code. But because of some redundancy of fields, it did not work.

Later I just removed the redundant fields and it worked like a charm.

so, The right answer is what you have suggested at first.

<field name="user_id" domain="[('groupd_ids','=', group_id)]"/>

Thanks for your support and sorry for the delay in updating the answer for my question.

Avatar
Discard
Mohammad Alhashash

You should not create a new answer for responding. Please read the FAQs. If the answer is correct, you should accept it and use the comment feature for response,

Vivekrajan Rayappan
Author

Ok. I shall keep that in mind henceforth. Thanks

Avatar
Gregor Heger
Best Answer

@Daniel Blankco

i know it is late, but in case somebody different reads this: function_id is located in the list view function_ids. Thereby, the scope of the domain lies within function_ids. So it it is not possible to address "function_ids" just by writing "function_ids[0][2]". The parent view, in which function_ids is located, has to be adressen. That is why parent. is for.
Entries in the function_ids list are represented by this list: [(6, 0, [1, 2, 3, 4])]. This is a so called x2many code. The ids of the function id fields is located in [1, 2, 3, 4]. So in order to address it, he writes parent.function_ids[0][2].
I don't really know why he is doing that.

Avatar
Discard
Avatar
namiri
Best Answer

try this

<field name="function_id" readonly="False" domain="[('id', 'in', parent.functions_ids[0][2])]"/>

Avatar
Discard
Ing. Daniel Blanco

@namiri, saw this in another question and post. Could you pleas explain each term inside the domain? I understand that 'id' referes to "the id of function_id", but parent... who is parent in this case? and what [0][2] stands for? refers to the element of the many2one declaration?

Related Posts Replies Views Activity
Domain not working in edit mode on Many2many field Solved
domain view many2many v14
Avatar
1
Sep 22
3698
Many2many domain works when click search more but wrong values in dropdown
domain many2many
Avatar
0
Nov 22
80
[SOLVED] Create rule using many2many - how to? Solved
domain many2many
Avatar
1
Jun 22
8129
Many2many domain not working Solved
domain many2many
Avatar
1
Jul 21
3530
Many2many domain not working Solved
domain many2many
Avatar
Avatar
1
Jul 21
5041