Odoo Help


Searching through opportunity/SO internal notes

Pat Miller
on 9/6/16, 3:09 PM 867 views

Hi guys, trying to find a way to search for opportunities and SO's with a particular internal note. We should've been using tags for this, but some slipped by. Short of manually looking through hundreds of internal notes, is there a way to search? The normal search box isn't turning up results.


Fabrice Henrion (fhe)

--Fabrice Henrion (fhe)--
| 7 7 9
San Francisco, United States
--Fabrice Henrion (fhe)--

Director Odoo Americas

Fabrice Henrion (fhe)
On 9/7/16, 9:55 PM

Assuming v9.0 Enterprise:

Use an advanced filter.

- For the opportunity internal note:

- For the SO internal note: use the field "Description" or "Terms and conditions" depending on what you want to search.

Thanks Fabrice - still having trouble with this. We're in 9.0c.

I created the exact filter you suggested, but with the text "Referral" instead of "abc". No results appeared.

I went and manually found an opportunity with a note "Referral" that was logged using the following steps (I recreated it to test):

1. Open opportunity

2. Click "Log an internal note"

3. Select Activity "Note"

4. Enter "Test" and click Log

Circling back around, I searched "Notes" for "Test" and nothing came up still.

Pat Miller
on 9/8/16, 3:40 PM

My answer was for the internal note on the opportunity, which is a field (textarea) in the form view. What you are talking about are the chatter entries. In order to find those (assuming you need to do this only once to fix your situation), do as follows:

- activate developer mode

- go to settings > technical > emails > messages

- use the filter: related document model contains crm.lead ; contents contain Referral

- the field "Related Document ID" in each record will tell you the opportunity ID that contains this chatter entry

Fabrice Henrion (fhe)
on 9/9/16, 1:03 AM

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.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 9/6/16, 3:09 PM
Seen: 867 times
Last updated: 9/7/16, 9:55 PM