add "first word" support -- use for callnumber prefix

git-svn-id: svn://svn.open-ils.org/ILS/trunk@9245 dcc99617-32d9-48b4-a31d-7c20da2025e4

diff --git a/Open-ILS/src/sql/Pg/002.functions.config.sql b/Open-ILS/src/sql/Pg/002.functions.config.sql
index d13a4f5..bb327c9 100644 (file)
--- a/Open-ILS/src/sql/Pg/002.functions.config.sql
+++ b/Open-ILS/src/sql/Pg/002.functions.config.sql
@@ -85,5 +85,9 @@ CREATE OR REPLACE FUNCTION oils_i18n_gettext( TEXT ) RETURNS TEXT AS $$
     SELECT $1;
 $$ LANGUAGE SQL;
 
+CREATE OR REPLACE FUNCTION public.first_word ( TEXT ) RETURNS TEXT AS $$
+        SELECT SUBSTRING( $1 FROM $_$^\S+$_$);
+$$ LANGUAGE SQL;
+
 COMMIT;
 

diff --git a/Open-ILS/web/reports/oils_rpt_tforms.js b/Open-ILS/web/reports/oils_rpt_tforms.js
index 3a901ea..38781f8 100644 (file)
--- a/Open-ILS/web/reports/oils_rpt_tforms.js
+++ b/Open-ILS/web/reports/oils_rpt_tforms.js
@@ -56,6 +56,11 @@ var OILS_RPT_TRANSFORMS = {
                label : 'First 5 characters (for US ZIP code)'
        },
 
+       first_word : {
+               datatype : [OILS_RPT_DTYPE_STRING, 'text'],
+               label : 'First contiguous non-space string'
+       },
+
        /* timestamp transforms ----------------------- */
        dow : {
                datatype : OILS_RPT_DTYPE_TIMESTAMP,

diff --git a/Open-ILS/web/reports/xul/transforms.js b/Open-ILS/web/reports/xul/transforms.js
index e08e3cb..b81b684 100644 (file)
--- a/Open-ILS/web/reports/xul/transforms.js
+++ b/Open-ILS/web/reports/xul/transforms.js
@@ -93,6 +93,11 @@ var OILS_RPT_TRANSFORMS = {
                label : 'First 5 characters (for US ZIP code)'
        },
 
+        first_word : {
+                datatype : [OILS_RPT_DTYPE_STRING, 'text'],
+                label : 'First contiguous non-space string'
+        },
+
        /* timestamp transforms ----------------------- */
        dow : {
                datatype : [ OILS_RPT_DTYPE_TIMESTAMP ],