[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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



Revision: 4549
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=4549&view=rev
Author:   ehuelsmann
Date:     2012-03-24 10:27:56 +0000 (Sat, 24 Mar 2012)
Log Message:
-----------
Correct company__search() to make in_contact_info truely optional.

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

Modified: branches/1.3/sql/modules/Company.sql
===================================================================
--- branches/1.3/sql/modules/Company.sql	2012-03-24 10:04:00 UTC (rev 4548)
+++ branches/1.3/sql/modules/Company.sql	2012-03-24 10:27:56 UTC (rev 4549)
@@ -238,7 +238,8 @@
 		WHERE coalesce(ec.entity_class,e.entity_class) = in_account_class
 			AND (c.id IN (select company_id FROM company_to_contact
 				WHERE contact ILIKE ALL(t_contact_info))
-				OR '' ILIKE ALL(t_contact_info))
+				OR '' ILIKE ALL(t_contact_info)
+				OR t_contact_info IS NULL)
 			
 			AND (c.legal_name ilike '%' || in_legal_name || '%'
 				OR in_legal_name IS NULL)

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