SF.net SVN: ledger-smb:[5796] branches/1.3/sql/modules/Company.sql

[..hidden..]

Revision: 5796
          http://sourceforge.net/p/ledger-smb/code/5796
Author:   einhverfr
Date:     2013-05-16 07:52:20 +0000 (Thu, 16 May 2013)
Log Message:
-----------
Committing fix for bug 808 to 1.3, having the contact box on the company search map to the description field for the company contact

Modified Paths:
--------------
    branches/1.3/sql/modules/Company.sql

Modified: branches/1.3/sql/modules/Company.sql
===================================================================
--- branches/1.3/sql/modules/Company.sql	2013-05-16 07:47:33 UTC (rev 5795)
+++ branches/1.3/sql/modules/Company.sql	2013-05-16 07:52:20 UTC (rev 5796)
@@ -278,6 +278,16 @@
 				OR (ec.enddate IS NULL))
 	 		AND (ec.meta_number = in_meta_number
 			     OR in_meta_number IS NULL)
+                        AND (in_contact IS NULL 
+                             OR c.id IN (select company_id 
+                                           FROM company_to_contact 
+                                          WHERE description 
+                                                @@ plainto_tsquery(in_contact))
+                             OR ec.id IN (SELECT credit_id
+                                            FROM eca_to_contact
+                                           WHERE description
+                                                 @@ plainto_tsquery(in_contact))
+                       )
                ORDER BY legal_name
 	LOOP
 		RETURN NEXT out_row;

This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.