SF.net SVN: ledger-smb:[5417] trunk/sql/modules/OrderEntry.sql

[..hidden..]

Revision: 5417
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=5417&view=rev
Author:   einhverfr
Date:     2012-12-26 01:47:54 +0000 (Wed, 26 Dec 2012)
Log Message:
-----------
fixing open/closed handling for order search

Modified Paths:
--------------
    trunk/sql/modules/OrderEntry.sql

Modified: trunk/sql/modules/OrderEntry.sql
===================================================================
--- trunk/sql/modules/OrderEntry.sql	2012-12-26 01:43:26 UTC (rev 5416)
+++ trunk/sql/modules/OrderEntry.sql	2012-12-26 01:47:54 UTC (rev 5417)
@@ -70,8 +70,8 @@
              AND (in_ponumber IS NULL OR o.ponumber ILIKE in_ponumber || '%')
             AND (in_ordnumber IS NULL 
                      OR o.ordnumber ILIKE in_ordnumber || '%')
-             AND (in_open is true or o.closed is not true)
-             AND (in_closed is true or o.closed is not false)
+             AND (in_open is true or o.closed is false)
+             AND (in_closed is true or o.closed is true)
              AND (in_shipvia IS NULL 
                       OR o.shipvia @@ plainto_tsquery(in_shipvia))
              AND (in_description IS NULL AND in_shippable IS NULL OR

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