Enhanced Search 3.0.6 Support

[kenshiro]

Enhanced Search 3.0.6 has been just released.

This version has been tested as fully compatible with Sugar 5.2.0i (a complete list of the bugs fixed can be found on the changelog ) .

Please report the new support issues in this thread.

[Alloran]

I ran a couple of test and it seems to work fine. Both bugs are fixed.

Thanks. Great Job

[jgosen]

Does anyone know if Enhanced Search 3.0.6 will work with Sugar 5.2j? I have Sugar setup on a development server and i upgraded it from 5.2i to 5.2j. As expected the enhanced search stopped functioning as it always does when i install one of the sugar patches. I then uninstalled the enhanced search and went to upload it again to reinstall to fix the problem (like i have done for all the other patches) and i keep getting an error that says
"The uploaded file is not compatible with this flavor (Community Edition, Professional, or Enterprise) of Sugar: PRO"

I even went back to the Sugar Xchange and downloaded the demo 3.0.6 Enhanced Search zip again and tried to upload it through the Module Loader; and the problem persists?

Any ideas?

[kenshiro]

Does anyone know if Enhanced Search 3.0.6 will work with Sugar 5.2j? I have Sugar setup on a development server and i upgraded it from 5.2i to 5.2j. As expected the enhanced search stopped functioning as it always does when i install one of the sugar patches. I then uninstalled the enhanced search and went to upload it again to reinstall to fix the problem (like i have done for all the other patches) and i keep getting an error that says
"The uploaded file is not compatible with this flavor (Community Edition, Professional, or Enterprise) of Sugar: PRO"

I even went back to the Sugar Xchange and downloaded the demo 3.0.6 Enhanced Search zip again and tried to upload it through the Module Loader; and the problem persists?

Any ideas?

The Enhanced Search release for the Professional and Enterprise editions is the enhancedSearch 3 0 6 PRO ENT demo that can be downloaded from the Project's Page.

It is compatible with Sugar CE/PRO/ENT 5.2.0j

[jgosen]

Thanks. I have no idea how i overlooked the separate Pro version. It must be one of those days.

Thanks. that worked.

[crmnovice]

Hello,

Does Enhanced Search work with custom modules? The majority of our SugarCRM modules are custom, and we are interested in Enhanced Search. I want to check prior to downloading and testing.

Thanks!

[kenshiro]

Hello,

Does Enhanced Search work with custom modules? The majority of our SugarCRM modules are custom, and we are interested in Enhanced Search. I want to check prior to downloading and testing.

Thanks!

Hello,

Yes, Enhanced Search has the same behaviour with SugarCRM and custom modules.

You can test it yourself through the DEMO version, that you can freely download from the download page.
Even if the DEMO version has less functionalities than the FULL, it may be enough to try what you are interested to.

[Spinaker]

I have installed the newest version of ES on sugar 5.2.0i CE. I have Mysql database.
After installing tab basic search wont work correctly.
When I click on Assigned to: the popup list shows up, but I cannot chose anything - when I click on any person I still have a blank field. This same happens when I click on the Team:.
When I click on Related to than nothing appears... After uninstalling is all just fine.
This same issue on IE, Opera and FF. On IE i see the error in JS:

Szczegóły błędu na stronie sieci Web

Agent użytkownika: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.0; Trident/4.0; SLCC1; .NET CLR 2.0.50727; Media Center PC 5.0; .NET CLR 3.5.30729; .NET CLR 3.0.30729)
Sygnatura czasowa: Thu, 29 Oct 2009 08:01:34 UTC


Wiadomość: Oczekiwano identyfikatora
Wiersz: 50
Znak: 10
Kod: 0
Identyfikator URI: http://192.168.25.3/sugarcrm/index.p...dvanced_search


Wiadomość: Oczekiwano identyfikatora
Wiersz: 67
Znak: 21
Kod: 0
Identyfikator URI: http://192.168.25.3/sugarcrm/index.p...dvanced_search


Wiadomość: Oczekiwano identyfikatora
Wiersz: 68
Znak: 51
Kod: 0
Identyfikator URI: http://192.168.25.3/sugarcrm/index.p...dvanced_search


Wiadomość: Oczekiwano identyfikatora
Wiersz: 102807428
Znak: 24
Kod: 0
Identyfikator URI: http://192.168.25.3/sugarcrm/index.p...dvanced_search

In module "Meetings" anything i try to click on Advanced search - nothing appears...
In att the movie in swf.

[mikesolomon]

I am having a problem with Enhanced Search 'Send All' search in custom modules

If I do a search in Contacts and then do a send all search against Accounts it works perfectly and the final sql statement is

SELECT contacts.id,
       CONCAT(IFNULL(contacts.first_name, ''), ' ', IFNULL(contacts.last_name,
        '')) as name,
       contacts.first_name,
       contacts.last_name,
       contacts.salutation,
       accounts.name account_name,
       jtl0.account_id account_id,
       contacts.title,
       contacts.phone_work,
       jt1.user_name assigned_user_name,
       jt1.created_by assigned_user_name_owner,
       'Users'       assigned_user_name_mod,
       contacts.status,
       contacts.assigned_user_id
FROM contacts
     LEFT JOIN accounts_contacts jtl0 ON contacts.id = jtl0.contact_id AND
      jtl0.deleted = 0
     LEFT JOIN accounts accounts ON accounts.id = jtl0.account_id AND
      accounts.deleted = 0 AND accounts.deleted = 0
     LEFT JOIN users jt1 ON jt1.id = contacts.assigned_user_id AND jt1.deleted =
      0 AND jt1.deleted = 0
where ((accounts.name IN (SELECT name FROM accounts accounts_sq_1 LEFT JOIN
 users jt0 ON jt0.id = accounts_sq_1.assigned_user_id AND jt0.deleted = 0 AND
  jt0.deleted = 0 where (accounts_sq_1.name like '%bad%') AND
   accounts_sq_1.deleted = 0))) AND
      contacts.deleted = 0
ORDER BY name ASC

But if I do the same thing in a custom module that has a relationship to accounts I get no records returned and the sql statement is

SELECT zz_css_job.id,
       zz_css_job.jobno,
       zz_css_job.name,
       zz_css_so.name zz_css_so_name,
       zz_css_so.assigned_user_id zz_css_so_name_owner,
       'zz_css_so'       zz_css_so_name_mod,
       zz_css_job.zz_css_so_id,
       accounts.name account_name,
       accounts.assigned_user_id account_name_owner,
       'Accounts'       account_name_mod,
       zz_css_job.account_id,
       jt2.name zz_css_type_name,
       zz_css_job.status,
       zz_css_job.value,
       zz_css_job.assigned_user_id
FROM zz_css_job
     LEFT JOIN zz_css_so zz_css_so ON zz_css_so.id = zz_css_job.zz_css_so_id AND
      zz_css_so.deleted = 0 AND zz_css_so.deleted = 0
     LEFT JOIN accounts accounts ON accounts.id = zz_css_job.account_id AND
      accounts.deleted = 0 AND accounts.deleted = 0
     LEFT JOIN zz_css_type jt2 ON zz_css_job.zz_css_type_id = jt2.id AND
      jt2.deleted = 0
where ((accounts.name IN (SELECT accounts_sq_1.id, accounts_sq_1.name,
 accounts_sq_1.billing_address_street, accounts_sq_1.billing_address_city,
  accounts_sq_1.billing_address_state, accounts_sq_1.billing_address_postalcode,
   accounts_sq_1.billing_address_country, accounts_sq_1.phone_office,
    accounts_sq_1.shipping_address_street, accounts_sq_1.shipping_address_city,
     accounts_sq_1.shipping_address_state,
      accounts_sq_1.shipping_address_postalcode,
       accounts_sq_1.shipping_address_country, jt0.user_name assigned_user_name,
        jt0.created_by assigned_user_name_owner, 'Users' assigned_user_name_mod,
         accounts_sq_1.assigned_user_id FROM accounts accounts_sq_1 LEFT JOIN
          users jt0 ON jt0.id = accounts_sq_1.assigned_user_id AND jt0.deleted =
           0 AND jt0.deleted = 0 where (accounts_sq_1.name like '%bad%') AND
            accounts_sq_1.deleted = 0))) AND
      zz_css_job.deleted = 0
ORDER BY zz_css_job.jobno ASC

Any ideas why this is happening?

If I click on the Query Edit button and change the Query to

SELECT
	accounts.name 
FROM
	accounts 
	LEFT JOIN users jt0 ON jt0.id= accounts.assigned_user_id 
	AND jt0.deleted=0 
	AND jt0.deleted=0 
where
	(accounts.name like '%bad%') 
	AND accounts.deleted=0 
ORDER BY
	accounts.name asc

it then works

I have the same issue with all my custom modules that have a relationship to accounts

[kenshiro]

I have installed the newest version of ES on sugar 5.2.0i CE. I have Mysql database.
After installing tab basic search wont work correctly.
When I click on Assigned to: the popup list shows up, but I cannot chose anything - when I click on any person I still have a blank field. This same happens when I click on the Team:.
When I click on Related to than nothing appears... After uninstalling is all just fine.
This same issue on IE, Opera and FF. On IE i see the error in JS:


In module "Meetings" anything i try to click on Advanced search - nothing appears...
In att the movie in swf.

Enhanced Search 3.0.6 should work with Sugar CE 5.2.0i.

This problem might be related to some fields you have added to the Basic Search Layout that make the js crash.
For instance I've seen something like a Flex Relate field even tough it's no more supported in 520i .
Not having your application at hand, I can suggest you two tests to perform and see if the problem persists.
You can try to remove the "Related to" and the "Team" fields from the Basic Search Layout of the Calls Module, and then try to see if "Assigned to" gives the same problem.
You can either try to see if the "Account Name" related field of the Contacts Basic Search gives the same problem.