Enhanced Search

This plugin is an incredible improvement to the SugarCRM™ search functionality.

Enhanced Search 3.1.07released: 13/02/2013

view changelog

New amazing search capabilities with dispage Enhanced Search:

Arbitrarily complex search queries composed through Additional Search Fields panel even using related modules.
Full logic operator and nested condition support.
Live ajax-loaded operators for each specific search field type.
SQL query editor tool.
Full support to save all the kinds of search.

what's new in 3.1 ?

SugarCRM 6 Compatibility
Intuitive Search Options
Custom Query Parameter Interface
Enhanced search options in Basic Search Panel
Public Saved Search
Search for deleted records
Chinese language support

Perform and Save a Complex Search
Expand the Addictional Search Fields* section in the Advanced Search panel to add more conditions to the search. Use the icons on the left of each condition row to add a new one ([+]) or remove it ([-]).
	SEARCH USING MORE CONDITIONS Search all the accounts created before March 31 2010, OR having an opportunities assigned to Sarah... AND ...a case number less or equal to ten. Then click Search button.
	SAVE THE SEARCH Assign a name to the search and save it to perform this search again at will and/or modify it.
	EDIT THE SQL QUERY Optionally, check Force to Replace Last Query and click Switch to Custom Query Mode button to edit the SQL query just performed.

Perform and Save a Complex Search

Expand the Addictional Search Fields* section in the Advanced Search panel to add more conditions to the search. Use the icons on the left of each condition row to add a new one ([+]) or remove it ([-]).

SEARCH USING MORE CONDITIONS

Search all the accounts created before March 31 2010,

having an opportunities assigned to Sarah...

AND

...a case number less or equal to ten.

Then click Search button.

SAVE THE SEARCH

Assign a name to the search and save it to perform this search again at will and/or modify it.

EDIT THE SQL QUERY

Optionally, check Force to Replace Last Query and click Switch to Custom Query Mode button to edit the SQL query just performed.