Does search functionality on email work?

[khalidh]

I am trying to use the search functionality on emails. I tried searching for email addresses, words in an email, and nothing happens. When I click on the search, Sugar behaves as if it is searching for the words, giving me the text loading but then I come back to my inbox with my regular views.

Is search broken or my doing something wrong.

Khalid

[sugarcane]

Hello Khalid,

where exactly are you trying to search? I clicked into the emails module, clicked 'All Emails' from the shortcuts tab, and in the Email Search panel, i entered a word in the 'Subject' search field. In front of the word, I entered the wildcard % sign, and any emails with that word in the subject displayed in the list view.

Without the %, the system will search for all subjects that begin with the word you type in, not contains

[khalidh]

I am trying to search emails in my email folder. So I did not click on "all emails". Instead, I click on my personal emails, click on the search, I am presented with
Search email account: <select email account>
and search options. When I search for anything nothing happens. The screen merely refreshes back to my full email view.


Khalid

[sugarcane]

Hello Khalid,

What version of sugar are you using?

Using 5.1a, i entered my inbound email setting into the 'Settings;. Once I did this, i was able to select this acount in the 'Search email account' dropdown. I am able to successfully search for emails in my inbox using keywords in the Subject, From, To, Date From and Date Until without having to use the wildcard here.

[khalidh]

I am using 5.1. a as well. I am following the same steps you mentioned but it is not working. I wonder if there is a server setting that is stopping the search or if there is an error taking place somewhere.

Khalid

[khalidh]

I am wondering if something went wrong during the upgrade process.

I turned logging on to see what is going on, and here is what I get:

Wed Oct 15 10:19:04 2008 [14605][34d0a79d-dc32-4759-0520-458102d41130][INFO] Query Execution Time:0.00034689903259277
Wed Oct 15 10:19:04 2008 [14605][34d0a79d-dc32-4759-0520-458102d41130][INFO] Query:SELECT category, name, value FROM config
Wed Oct 15 10:19:04 2008 [14605][34d0a79d-dc32-4759-0520-458102d41130][INFO] Query Execution Time:0.00055503845214844
Wed Oct 15 10:19:04 2008 [14605][34d0a79d-dc32-4759-0520-458102d41130][INFO] Query:SELECT id FROM outbound_email WHERE type = 'system'
Wed Oct 15 10:19:04 2008 [14605][34d0a79d-dc32-4759-0520-458102d41130][INFO] Query Execution Time:0.00026988983154297
Wed Oct 15 10:19:04 2008 [14605][34d0a79d-dc32-4759-0520-458102d41130][INFO] Query:SELECT * FROM outbound_email WHERE id = 'ecf1a203-8af3-1e03-44d9-48f4eff92e4d'
Wed Oct 15 10:19:04 2008 [14605][34d0a79d-dc32-4759-0520-458102d41130][INFO] Query Execution Time:0.00049901008605957
Wed Oct 15 10:19:04 2008 [14605][34d0a79d-dc32-4759-0520-458102d41130][DEBUG] Module:Emails using file: EmailUIAjax
Wed Oct 15 10:19:04 2008 [14605][34d0a79d-dc32-4759-0520-458102d41130][INFO] Query:INSERT INTO tracker (monitor_id,user_id,module_name,date_modified,action,session_id ) VALUES ( '72cf1827-5c8c-0846-a710-48f626f37a04','34d0a79d-dc32-4759-0520-458102d41130','Emails','2008-10-15 17:19:04','emailuiajax','76c99d12eed21b617bba8eb0bbea51e8')
Wed Oct 15 10:19:04 2008 [14605][34d0a79d-dc32-4759-0520-458102d41130][INFO] Query Execution Time:0.00093603134155273
Wed Oct 15 10:19:04 2008 [14605][34d0a79d-dc32-4759-0520-458102d41130][DEBUG] ********** EMAIL 2.0 - Asynchronous - at: searchAdvanced
Wed Oct 15 10:19:04 2008 [14605][34d0a79d-dc32-4759-0520-458102d41130][DEBUG] Retrieve InboundEmail : SELECT inbound_email.* FROM inbound_email  WHERE inbound_email.id = '39c215ee-e4f3-183c-1365-47d543a528b5'  AND inbound_email.deleted=0
Wed Oct 15 10:19:04 2008 [14605][34d0a79d-dc32-4759-0520-458102d41130][DEBUG] Limit Query:SELECT inbound_email.* FROM inbound_email  WHERE inbound_email.id = '39c215ee-e4f3-183c-1365-47d543a528b5'  AND inbound_email.deleted=0 Start: 0 count: 1
Wed Oct 15 10:19:04 2008 [14605][34d0a79d-dc32-4759-0520-458102d41130][INFO] Query:SELECT inbound_email.* FROM inbound_email  WHERE inbound_email.id = '39c215ee-e4f3-183c-1365-47d543a528b5'  AND inbound_email.deleted=0 LIMIT 0,1
Wed Oct 15 10:19:04 2008 [14605][34d0a79d-dc32-4759-0520-458102d41130][INFO] Query Execution Time:0.0005500316619873
Wed Oct 15 10:19:04 2008 [14605][34d0a79d-dc32-4759-0520-458102d41130][INFO] *** INBOUNDEMAIL: searching [ personal.khalid ] for [ %job% ]

As you see, the last statement logged shows the query execution but nothing happens after that.

When I increased the time to abandon queries from 100 msc to 99999 msc,I noticed a different behavior. Now, the search screen comes back saying no emails found. Previously, it would refresh with all my inbox items as if the search eas not conducted.

Khalid