Mercurial > p > roundup > code
comparison doc/customizing.txt @ 3688:722ab52d47fc
added filter_sql to SQL backends which takes an arbitrary SQL statement...
...and returns a list of item ids
| author | Richard Jones <richard@users.sourceforge.net> |
|---|---|
| date | Tue, 29 Aug 2006 04:32:49 +0000 |
| parents | d6aeef8a1910 |
| children | 790363e96852 |
comparison
equal
deleted
inserted
replaced
| 3687:ff9f4ca42454 | 3688:722ab52d47fc |
|---|---|
| 1 =================== | 1 =================== |
| 2 Customising Roundup | 2 Customising Roundup |
| 3 =================== | 3 =================== |
| 4 | 4 |
| 5 :Version: $Revision: 1.204 $ | 5 :Version: $Revision: 1.205 $ |
| 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:: |
| 1868 "group" are ``(dir, prop)`` where dir is '+', '-' or None | 1868 "group" are ``(dir, prop)`` where dir is '+', '-' or None |
| 1869 and prop is a prop name or None. | 1869 and prop is a prop name or None. |
| 1870 | 1870 |
| 1871 eg. ``issue.filter(filterspec={"priority": "1"}, | 1871 eg. ``issue.filter(filterspec={"priority": "1"}, |
| 1872 sort=('activity', '+'))`` | 1872 sort=('activity', '+'))`` |
| 1873 | |
| 1874 filter_sql **Only in SQL backends** | |
| 1875 | |
| 1876 Lists the items that match the SQL provided. The SQL is a | |
| 1877 complete "select" statement. | |
| 1878 | |
| 1879 The SQL select must include the item id as the first column. | |
| 1880 | |
| 1881 This function **does not** filter out retired items, add | |
| 1882 on a where clause "__retired__ <> 1" if you don't want | |
| 1883 retired nodes. | |
| 1873 | 1884 |
| 1874 classhelp display a link to a javascript popup containing this class' | 1885 classhelp display a link to a javascript popup containing this class' |
| 1875 "help" template. | 1886 "help" template. |
| 1876 | 1887 |
| 1877 This generates a link to a popup window which displays the | 1888 This generates a link to a popup window which displays the |