[interchange-cvs] interchange - racke modified WHATSNEW

[interchange-core@icdevgroup.org]

User:      racke
Date:      2002-10-14 22:04:57 GMT
Modified:  .        WHATSNEW
Log:
new next_sequential filter documented

Revision  Changes    Path
2.44      +36 -1     interchange/WHATSNEW


rev 2.44, prev_rev 2.43
Index: WHATSNEW
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
RCS file: /var/cvs/interchange/WHATSNEW,v
retrieving revision 2.43
retrieving revision 2.44
diff -u -r2.43 -r2.44
--- WHATSNEW	12 Oct 2002 22:34:37 -0000	2.43
+++ WHATSNEW	14 Oct 2002 22:04:57 -0000	2.44
@@ -5,7 +5,6 @@
=20
 --------------------------------------------------------------------------=
----
=20
-
 Interchange 4.9.3 not yet released.
=20
=20
@@ -157,6 +156,39 @@
   their site's interaction with the Interchange Payment system, without
   actually being connected to a real Payment Services Provider.=20
=20
+Filters
+-------
+
+* Add new filter, "next_sequential". Allows selection of a next-sequential
+  value based on a field (and qualified by a field).=20=20=20
+
+  [filter op=3D"next_sequential.survey_q.sort"][cgi sort][/filter]
+
+  will:=20=20=20
+
+    1. Return the existing value if present.
+    2. If existing value is blank, return max + 1 in the sort field,
+       i.e. equivalent to:=20
+
+	   SELECT sort FROM survey_q
+       ORDER BY sort DESC
+       LIMIT 1=20=20=20
+
+  If another argument of a field name is passed, i.e.=20
+
+    filter =3D> 'next_sequential.survey_q.sort.sel',=20=20=20
+
+  then you get:=20
+
+       SELECT sort FROM survey_q
+       WHERE sel =3D '[cgi sel]'
+       ORDER BY sort DESC
+       LIMIT 1=20=20=20
+
+  This allows a next-sequential numbering for things that need it.
+  Developed to support general-purpose survey UI for Ton's excellent
+  product rating system.
+
 Foundation
 ----------
=20
@@ -334,6 +366,9 @@
 * Add cheesy mail list manager, a common thing to ask. Supported by unsubs=
cribe
   function and a batch download mode for large mailings....probably should
   create some online help.
+
+* Ability to employ database entries in filters supported by profile=20
+  "process_filter" now.
=20
 * Many, many, minor bug fixes and improvements.
=20