Mercurial > p > roundup > code
comparison doc/customizing.txt @ 3718:0d561b24ceff
support sqlite3
| author | Richard Jones <richard@users.sourceforge.net> |
|---|---|
| date | Wed, 04 Oct 2006 01:12:00 +0000 |
| parents | 5770f1802cd0 |
| children | c07ae92cebbc |
comparison
equal
deleted
inserted
replaced
| 3717:5770f1802cd0 | 3718:0d561b24ceff |
|---|---|
| 1 =================== | 1 =================== |
| 2 Customising Roundup | 2 Customising Roundup |
| 3 =================== | 3 =================== |
| 4 | 4 |
| 5 :Version: $Revision: 1.208 $ | 5 :Version: $Revision: 1.209 $ |
| 6 | 6 |
| 7 .. This document borrows from the ZopeBook section on ZPT. The original is at: | 7 .. This document borrows from the ZopeBook section on ZPT. The original is at: |
| 8 http://www.zope.org/Documentation/Books/ZopeBook/current/ZPT.stx | 8 http://www.zope.org/Documentation/Books/ZopeBook/current/ZPT.stx |
| 9 | 9 |
| 10 .. contents:: | 10 .. contents:: |
| 1867 "filterspec" is ``{propname: value(s)}``. "sort" and | 1867 "filterspec" is ``{propname: value(s)}``. "sort" and |
| 1868 "group" are an optionally empty list ``[(dir, prop)]`` | 1868 "group" are an optionally empty list ``[(dir, prop)]`` |
| 1869 where dir is '+', '-' or None | 1869 where dir is '+', '-' or None |
| 1870 and prop is a prop name or None. | 1870 and prop is a prop name or None. |
| 1871 | 1871 |
| 1872 eg. ``issue.filter(filterspec={"priority": "1"}, | 1872 The propname in filterspec and prop in a sort/group spec |
| 1873 sort=[('activity', '+')])`` | 1873 may be transitive, i.e., it may contain properties of |
| 1874 the form link.link.link.name. | |
| 1875 | |
| 1876 eg. All issues with a priority of "1" with messages added in | |
| 1877 the last week, sorted by activity date: | |
| 1878 ``issue.filter(filterspec={"priority": "1", | |
| 1879 'messages.creation' : '.-1w;'}, sort=[('activity', '+')])`` | |
| 1874 | 1880 |
| 1875 filter_sql **Only in SQL backends** | 1881 filter_sql **Only in SQL backends** |
| 1876 | 1882 |
| 1877 Lists the items that match the SQL provided. The SQL is a | 1883 Lists the items that match the SQL provided. The SQL is a |
| 1878 complete "select" statement. | 1884 complete "select" statement. |
| 2197 show a convenience access to columns - request/show/colname will | 2203 show a convenience access to columns - request/show/colname will |
| 2198 be true if the columns should be displayed, false otherwise | 2204 be true if the columns should be displayed, false otherwise |
| 2199 sort index sort columns [(direction, column name)] | 2205 sort index sort columns [(direction, column name)] |
| 2200 group index grouping properties [(direction, column name)] | 2206 group index grouping properties [(direction, column name)] |
| 2201 filter properties to filter the index on | 2207 filter properties to filter the index on |
| 2202 filterspec values to filter the index on | 2208 filterspec values to filter the index on (property=value, eg |
| 2209 ``priority=1`` or ``messages.author=42`` | |
| 2203 search_text text to perform a full-text search on for an index | 2210 search_text text to perform a full-text search on for an index |
| 2204 =========== ============================================================ | 2211 =========== ============================================================ |
| 2205 | 2212 |
| 2206 There are several methods available on the request variable: | 2213 There are several methods available on the request variable: |
| 2207 | 2214 |