SF.net SVN: ledger-smb:[6325] trunk/sql/modules/Report.sql

[..hidden..]

Revision: 6325
          http://sourceforge.net/p/ledger-smb/code/6325
Author:   tshvr
Date:     2013-12-30 15:59:27 +0000 (Mon, 30 Dec 2013)
Log Message:
-----------
ilike does not work here?

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

Modified: trunk/sql/modules/Report.sql
===================================================================
--- trunk/sql/modules/Report.sql	2013-12-28 05:39:38 UTC (rev 6324)
+++ trunk/sql/modules/Report.sql	2013-12-30 15:59:27 UTC (rev 6325)
@@ -510,7 +510,8 @@
        EXISTS (select * from acc_trans 
                where trans_id = a.id AND chart_id = in_account_id))
        AND (in_entity_name IS NULL 
-           OR eeca.name ilike in_entity_name || '%')
+--           OR eeca.name ilike in_entity_name || '%')
+           OR eeca.name @@ plainto_tsquery(in_entity_name))
        AND (in_meta_number IS NULL OR eca.meta_number ilike in_meta_number)
        AND (in_employee_id = ee.entity_id OR in_employee_id IS NULL)
        AND (in_manager_id = mee.id OR in_manager_id IS NULL)

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


------------------------------------------------------------------------------
Rapidly troubleshoot problems before they affect your business. Most IT 
organizations don't have a clear picture of how application performance 
affects their revenue. With AppDynamics, you get 100% visibility into your 
Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro!
http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-commits mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-commits