SF.net SVN: ledger-smb:[6348] trunk/sql/modules/Templates.sql

[..hidden..]

Revision: 6348
          http://sourceforge.net/p/ledger-smb/code/6348
Author:   einhverfr
Date:     2014-01-02 14:56:17 +0000 (Thu, 02 Jan 2014)
Log Message:
-----------
Adding template listing function

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

Modified: trunk/sql/modules/Templates.sql
===================================================================
--- trunk/sql/modules/Templates.sql	2014-01-02 13:24:32 UTC (rev 6347)
+++ trunk/sql/modules/Templates.sql	2014-01-02 14:56:17 UTC (rev 6348)
@@ -15,6 +15,14 @@
 SELECT * FROM template WHERE id = $1;
 $$;
 
+CREATE OR REPLACE FUNCTION template__list(in_language_code varchar(6))
+RETURNS SETOF template language sql as $$
+
+SELECT * FROM template WHERE language_code IS NOT DISTINCT FROM $1
+ORDER BY template_name, format;
+
+$$;
+
 CREATE OR REPLACE FUNCTION template__save(
 in_template_name text, in_language_code varchar(6), in_template text
 in_format text

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