How to search for opportunity amounts with <, > and = operator (SugarCRM 5.0.0i)

[kuske]

SugarCRM searches in opportunities for amounts with a standard search-like-clause.
So if you enter 100000 in the Advanced Search Amount field you will get a where clause

 opportunities.amount like '100000%'

If you want to search for 100000 exactly or for more or less than 100000 you can do this by a little patch in module /include/MVC/View/views/view-list.php.

Here clause manipulation can be added before the line

 
if (count($where_clauses) > 0 )$where = '('. implode(' ) AND ( ', $where_clauses) . ')';

E.g. you can add the following code for opportunities before the above printed line:

 
if ( $this->seed->module_dir == "Opportunities" ) 
{ 
foreach($where_clauses as $dakey => $dawert) 
{
	 if(substr($dawert,0,27)=="opportunities.amount like '") 
	 {
		 $datest= substr($dawert,27,1);
		 $daop = "%";
		 if ($datest == ">") $daop=">";
		 if ($datest == "<") $daop="<";
		 if ($datest == "=") $daop="=";
 
		 if ($daop != "%")
		 {
			// remove test-char
			$dawert = str_replace($daop,"",$dawert);
			// remove %
			$dawert = str_replace("%","",$dawert);
			// replace like by new operation
			$dawert = str_replace("like",$daop,$dawert);
			// replace original where clause
			$where_clauses[$dakey] = $dawert;
		 }
	 }
}
}

Now you can enter “100000” and the where clause will be

 opportunities.amount like '100000%'

If you enter “>100000” the where clause will be

 opportunities.amount > '100000'

The corresponding applies to “<1000000” and “=100000”.

[vishwasrao]

Hi kuske,
can we use enhanced search instead of changing code.

[kuske]

Yes you can...