How to search for contacts that are linked to a company with a specific tag?

Question

I am trying to do a search for contacts that are linked to a company record where the company has either a field with a specific value or a specific tag set on it. Can this be done in Odoo v8.0?

I have tried search in the Customers view with a filter for both "Contacts" and "Tag contains My_Tag" and i'm not returning any records. The contacts i am searching for don't have "My_Tag" set on them. Only the companies that they work for have the tag set.

Garth Mathers · Accepted Answer

Hello Vasanth

I my database the companies I'm searching for have a tag set called "Veterinary". If i do a search for "Companies" and Tag = "Veterinary", i get a list of all of the Veterinary Companies in the DB. So that part is working OK.

Now, what i'm trying to do is to search for a list of all of the contacts (people) that work for these veterinary companies. These contacts don't have the "Veterinary" tag set on them - but their related companies do have the Veterinary tag set. If i search

Vasanth · Answer

Hi,

for example you tag is "Retail" means, you can search in the customer search view by using "Customers" ans in the advanced search you can use Tags contains Retail.Please check before your tag is created correctly

José DESGRIS · Answer

Hello,

If you search for a company that has no custom field, your research won't give anything.

I would say, you have to create a custom "Related partners" text field that will have company names separated by commas for example.

Once you update the fields in your res_partner database, you will be able to search for companys that work with another company.

Best regards,

José

신고된 질문입니다

토론이 재미있으신가요? 직접 참여해보세요!