No more limits on Sugar searches with Enhanced Search 3.0 !

[kenshiro]

Enhanced Search 3.0 has been released : searches in Sugar have never been so easy.

Many useful tools enhance Search capabilities up to the SQL query ones.

Among them :

RELATED MODULE SEARCH BY EDITABLE SUBQUERIES





When a related search field Popup window is open from the Advanced Search page, a New "Send All" Button appears at the top of the Record List.
The Records in the Popup window can be filtered using the standard SugarCRM search, then all the result records (even the ones not appearing in
the page) can be sent, on a query format, to the Advanced Search page by clicking the "Send All" Button.
The Relate Search field aspect in the Advanced Search page changes after receiving the query : it turns from a text field into the "Custom Query" label
and an Edit Icon appears on the right of the search field.

In the Enhanced Search FULL version, a choice among different Subquery Operators is also available:

• "<field> IN <query>" (default)
• "EXISTS <query>"
• "<query>"

By clicking the Edit Icon THE USER CAN VIEW / EDIT THE SUBQUERY IN A POPUP WINDOW.


GLOBAL QUERY EDIT (FULL version)





Clicking the "Switch to Custom Query Mode" Button at the top of the Advanced Search page, the Advanced Search Screen changes from the Classic Mode to the Custom Query Mode.
A tool to view/edit the main search query is available in this Mode, and the query viewing/editing is aided by

• SQL syntax highlight
• Query indentation
• Search/replace text capability
• Undo/Redo history navigation

.. and more

Please read carefully the README file for more details.

[karkula]

Thank you for making this module available. Is there, or will there be an upgrade-safe way to disable the "switch to custom query mode" in the CE demo version? Thanks again.

[kenshiro]

Thank you for making this module available. Is there, or will there be an upgrade-safe way to disable the "switch to custom query mode" in the CE demo version? Thanks again.

Sorry, I haven't understood exactly what you mean. Do you want the "switch to custom query mode" button (with the warning "Feature available in the FULL version only") not to appear in the Advanced Search Page of the DEMO version ?
Is this for appearance reasons ?