Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Účtovníctvo
Sklady
PoS
Projektové riadenie
MRP

All apps

All Posts People Badges

Tagy (View all)

odoo accounting v14 pos v15

About this forum

Pomoc

How to check whether two many2many fields are exactly equal or not in odoo9?

odoo odoo8.0 odoo9

1 Odpoveď

8019 Zobrazenia

Sebin Siby

Hi,

I have a many2many field "tag_ids" both in models "news.ads" and "blog.post".

I want to get all the records from "blog.post" whose "tag_ids" exactly matches the "tag_ids" in "news.ads".

I tried the following in my controller but it doesn't worked,

blog_obj = request.registry['blog.post']
p_id = blog_obj.search(cr, uid, ['&', ['id','=',post_id], ['website_published', '=', True]], context=context)
post = blog_obj.browse(cr, uid, p_id, context=context)

ad_obj = request.registry['news.ads']
banner_ads = ad_obj.search(cr, uid, [('state', '=', 'publish'), ('tag_ids', 'in', [post.tag_ids])], context=context)

How do I search such records in odoo9? Any workaround..!!

Pawan

sebin,

what you can do is,

First get the records of both the object as:

news_ads_tags = self.env['news.ads'].browse(news_ads_id).tag_ids

blog_post_tags = self.env['blog.post'].browse(blog_post_id).tag_ids

now to get the ids which are in both of them:
res = [rec.id for rec in new_ads_tags if rec in blog_post_tags]

res will contains all those tags which are in new_ads_tags and blog_post_tags both!!

Hope it helps!!

Sebin Siby

Autor

Hi Pawan,

Thanks for your answer. Actually I need to use it in a domain for a search operation. I updated my question above. How can I use it in the search operation.

Pawan

Sebin,

first p_id is the list returned from search, so either you loop through it or for first element use p_id[0], then you can get the first records object form list using:

post = blog_obj.browse(cr, uid, p_id[0], context=context)

then in banner_ads you can try this:

banner_ads = ad_obj.search(cr, uid, [('state', '=', 'publish'), ('tag_ids', 'in', [id.id for id in post.tag_ids])],

Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Registrácia

Related Posts	Replies	Zobrazenia
Licence Key difference between AGPL-3 and LGPL-3 for Odoo manifest File licensing odoo odoo8.0 odoo9	0 mar 17	10184
How to bring products from opportunity to quotation odoo odoo9	0 okt 23	3584
Preview pdf,docs or other attachment file Solved odoo odoo9	4 dec 21	34783
odoo 9 show user popups Solved odoo odoo9	2 dec 20	9750
odoo v8 requisition line odoo odoo8.0	1 dec 18	3314

This question has been flagged

Enjoying the discussion? Don't just read, join in!