SF.net SVN: ledger-smb:[6764] branches/1.3/sql/modules/Employee.sql

[..hidden..]

Revision: 6764
          http://sourceforge.net/p/ledger-smb/code/6764
Author:   einhverfr
Date:     2014-02-05 12:59:43 +0000 (Wed, 05 Feb 2014)
Log Message:
-----------
Fixing 1.3-only bug 980, join projection on employee search

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

Modified: branches/1.3/sql/modules/Employee.sql
===================================================================
--- branches/1.3/sql/modules/Employee.sql	2014-02-05 12:22:36 UTC (rev 6763)
+++ branches/1.3/sql/modules/Employee.sql	2014-02-05 12:59:43 UTC (rev 6764)
@@ -138,7 +138,7 @@
      JOIN entity e ON p.entity_id = e.id
      JOIN entity_employee ee on (ee.entity_id = p.entity_id)
 LEFT JOIN salutation s on (p.salutation_id = s.id)
-LEFT JOIN person mp ON ee.manager_id = p.entity_id
+LEFT JOIN person mp ON ee.manager_id = mp.entity_id
     WHERE ($7 is null or p.entity_id in (select ref_key from entity_note
                                           WHERE note ilike '%' || $7 || '%'))
           and ($1 is null or $1 = ee.employeenumber)

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


------------------------------------------------------------------------------
Managing the Performance of Cloud-Based Applications
Take advantage of what the Cloud has to offer - Avoid Common Pitfalls.
Read the Whitepaper.
http://pubads.g.doubleclick.net/gampad/clk?id=121051231&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-commits mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-commits