Index: openacs-4/packages/acs-templating/tcl/widget-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-templating/tcl/Attic/widget-procs-oracle.xql,v
diff -u -N
--- openacs-4/packages/acs-templating/tcl/widget-procs-oracle.xql	11 Dec 2003 21:39:57 -0000	1.4
+++ /dev/null	1 Jan 1970 00:00:00 -0000
@@ -1,34 +0,0 @@
-<?xml version="1.0"?>
-<queryset>
-
-<rdbms><type>oracle</type><version>8.1.6</version></rdbms>
-
-<fullquery name="template::data::transform::party_search.search_persons">      
-      <querytext>
-        select (first_names || ' ' || last_name) as name, pe.person_id from persons pe, parties pa 
-        where pe.person_id=pa.party_id and (
-          lower(pe.first_names || ' ' || pe.last_name) like '%' || lower(:search_string) || '%'
-          or lower(pa.email) like '%' || lower(:search_string) || '%'
-	)
-        order by lower(first_names || ' ' || last_name)
-      </querytext>
-</fullquery>
-
-<fullquery name="template::data::transform::party_search.search_groups_relsegs">
-      <querytext>
-        (
-        select g1.group_name as party_name, g1.group_id as party_id from groups g1
-        where lower(g1.group_name) like '%' || lower(:search_string) || '%'
-        )
-        union
-        (
-        select g2.group_name || ' : ' || s2.segment_name as party_name, s2.segment_id as party_id
-        from rel_segments s2, groups g2  
-        where s2.group_id=g2.group_id and
-        lower(g2.group_name || ' : ' || s2.segment_name) like '%' || lower(:search_string) || '%'
-        )
-        order by party_name
-      </querytext>
-</fullquery>
-
-</queryset>
Index: openacs-4/packages/acs-templating/tcl/widget-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-templating/tcl/Attic/widget-procs-postgresql.xql,v
diff -u -N
--- openacs-4/packages/acs-templating/tcl/widget-procs-postgresql.xql	11 Dec 2003 21:39:57 -0000	1.3
+++ /dev/null	1 Jan 1970 00:00:00 -0000
@@ -1,32 +0,0 @@
-<?xml version="1.0"?>
-<queryset>
-<rdbms><type>postgresql</type><version>7.1</version></rdbms>
-
-<fullquery name="template::data::transform::party_search.search_persons">      
-      <querytext>
-        select (first_names || ' ' || last_name) as name, pe.person_id from persons pe 
-        join parties pa on pe.person_id=pa.party_id
-        where lower(pe.first_names || ' ' || pe.last_name) like '%' || lower(:search_string) || '%'
-        or lower(pa.email) like '%' || lower(:search_string) || '%'
-        order by lower(first_names || ' ' || last_name)
-      </querytext>
-</fullquery>
-
-<fullquery name="template::data::transform::party_search.search_groups_relsegs">
-      <querytext>
-        (
-        select g1.group_name as party_name, g1.group_id as party_id from groups g1
-        where lower(g1.group_name) like '%' || lower(:search_string) || '%'
-        )
-        union
-        (
-        select g2.group_name || ' : ' || s2.segment_name as party_name, s2.segment_id as party_id
-        from rel_segments s2
-        join groups g2 on s2.group_id=g2.group_id
-        where lower(g2.group_name || ' : ' || s2.segment_name) like '%' || lower(:search_string) || '%'
-        )
-        order by party_name
-      </querytext>
-</fullquery>
-
-</queryset>
Index: openacs-4/packages/acs-templating/tcl/widget-procs.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-templating/tcl/widget-procs.xql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/acs-templating/tcl/widget-procs.xql	29 May 2018 09:18:38 -0000	1.1
@@ -0,0 +1,31 @@
+<?xml version="1.0"?>
+<queryset>
+
+<fullquery name="template::data::transform::party_search.search_persons">      
+      <querytext>
+        select (first_names || ' ' || last_name) as name, pe.person_id from persons pe 
+        join parties pa on pe.person_id=pa.party_id
+        where lower(pe.first_names || ' ' || pe.last_name) like '%' || lower(:search_string) || '%'
+        or lower(pa.email) like '%' || lower(:search_string) || '%'
+        order by lower(first_names || ' ' || last_name)
+      </querytext>
+</fullquery>
+
+<fullquery name="template::data::transform::party_search.search_groups_relsegs">
+      <querytext>
+        (
+        select g1.group_name as party_name, g1.group_id as party_id from groups g1
+        where lower(g1.group_name) like '%' || lower(:search_string) || '%'
+        )
+        union
+        (
+        select g2.group_name || ' : ' || s2.segment_name as party_name, s2.segment_id as party_id
+        from rel_segments s2
+        join groups g2 on s2.group_id=g2.group_id
+        where lower(g2.group_name || ' : ' || s2.segment_name) like '%' || lower(:search_string) || '%'
+        )
+        order by party_name
+      </querytext>
+</fullquery>
+
+</queryset>