Email search does not work

[wilibar]

Hello,

I have Sugar CE 5.5.1 and I am unable to search any emails. No mention of issues with email search is mentioned in the Forums.

When I enter a name or email address in the "From" field, I get the following message: "No Emails to display"

The email I am searching is, of course, there but it never returns any results. I see the email page turns grey- I assume this means its searching, but it never returns any search results. The Sugar search for contacts any other items works well, though.

Can someone tell me what I'm doing wrong? Thank you for your help.

Sincerely,

William

[arnaud_carrenet]

Hello,

I'm assuming that if you're using Sugar 551 you've configured your email accounts as IMAP.
To be able to search an email, you need to import your email into Sugar (Right Click on email then Import to Sugar).
You should be able to search in your emails.
SugarCRM is able to see and display emails stored in a different system, like gmail for example, but not able to search in this system unless you import your email to Sugar !
Hope that helps.
Regards,

[johnsopaul]

No, the problem is not that the email is not imported. Searching from the from field does not work. You can return an email from a subject search but you cannot return the same email from a 'from' search. I have tried searching using % as a wildcard, without etc. No combination (that does work in subject) works in the 'from' OR 'to' fields. If these fields require some other approach, it is not documented.

The related record search is buggy too. If you count the emails from a particular object's history, it may or may not equal the number returned from an email search. I can see no particular reason for this - that is, the missing email have the same properties (sent, replied, read, related etc..) as the returned ones as far as I can see.

I am testing 5.5.1

[sugarFLO]

I am having the same problem in CE 6.0.1

Also you can only search for full subject lines, not for single words (which is pretty useless for a search).

An IMAP search should also be possible, otherwhise you always need a secondary email client just to do your searches...

[angelababy]

You should be able to search in your emails.You can return an email from a subject search but you cannot return the same email from a 'from' search.

[carolyny476]

Hello,

I'm assuming that if you're using Sugar 551 you've configured your email accounts as IMAP.
To be able to search an email, you need to import your email into Sugar (Right Click on email then Import to Sugar).
You should be able to search in your emails.
SugarCRM is able to see and display emails stored in a different system, like gmail for example, but not able to search in this system unless you import your email to Sugar !
Hope that helps.
Regards,

Thanks you for the post.

__________________
watch free movies online

[vlatko.surlan]

Hello,

I have Sugar CE 5.5.1 and I am unable to search any emails. No mention of issues with email search is mentioned in the Forums.

When I enter a name or email address in the "From" field, I get the following message: "No Emails to display"

The email I am searching is, of course, there but it never returns any results. I see the email page turns grey- I assume this means its searching, but it never returns any search results. The Sugar search for contacts any other items works well, though.

Can someone tell me what I'm doing wrong? Thank you for your help.

Sincerely,

William

What's wrong is that the programmer who wrote the code that does the search hasn't been executed yet. This is an example query that gets generated when you hit search:

ea_from.email_address='test'

instead of

ea_from.email_address LIKE '%test%'

Once I've changed this in the code it works perfectly....