From b9b3e7f24e082392e525a5095ebf5e638d8334b6 Mon Sep 17 00:00:00 2001 From: miker Date: Mon, 7 Apr 2008 14:57:20 +0000 Subject: [PATCH 1/1] add "first word" support -- use for callnumber prefix git-svn-id: svn://svn.open-ils.org/ILS/trunk@9245 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/002.functions.config.sql | 4 ++++ Open-ILS/web/reports/oils_rpt_tforms.js | 5 +++++ Open-ILS/web/reports/xul/transforms.js | 5 +++++ 3 files changed, 14 insertions(+) diff --git a/Open-ILS/src/sql/Pg/002.functions.config.sql b/Open-ILS/src/sql/Pg/002.functions.config.sql index d13a4f56e7..bb327c9477 100644 --- 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 3a901ea460..38781f85d3 100644 --- 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 e08e3cbf09..b81b684b40 100644 --- 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 ], -- 2.43.2