Changeset 878 for trunk/FormQueryPlugin/data/TWiki/FormQueryPlugin.txt
- Timestamp:
- 11/23/08 11:38:34 (4 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/FormQueryPlugin/data/TWiki/FormQueryPlugin.txt
r788 r878 2 2 ---+!! FormQueryPlugin 3 3 4 The FormQueryPlugin provides a query interface to the [[ TWiki:Plugins/DBCacheContrib][TWiki::Contrib::DBCacheContrib]] module, giving a way to present query results as formatted tables.5 6 When using the plugin each topic is treated as a container for data fields. These fields can be the fields in the form attached to the topic, or can be parsed out of the topic. The database is managed by the [[ TWiki:Plugins/DBCacheContrib][TWiki::Contrib::DBCacheContrib]] module, which must be installed for this plugin to work.4 The FormQueryPlugin provides a query interface to the [[Foswiki:Extensions/DBCacheContrib][TWiki::Contrib::DBCacheContrib]] module, giving a way to present query results as formatted tables. 5 6 When using the plugin each topic is treated as a container for data fields. These fields can be the fields in the form attached to the topic, or can be parsed out of the topic. The database is managed by the [[Foswiki:Extensions/DBCacheContrib][TWiki::Contrib::DBCacheContrib]] module, which must be installed for this plugin to work. 7 7 8 8 The tutorial section of this topic gives an introduction to formulating and formatting queries using this plugin, and is a good place to start. … … 339 339 1. Else supress the search hit 340 340 341 This requires the TWiki:Plugins.SpreadSheetPlugin. The following example shows all topics that are up to exactly one week old.341 This requires the Foswiki:Extensions.SpreadSheetPlugin. The following example shows all topics that are up to exactly one week old. 342 342 343 343 *Write this:* … … 431 431 Two special map entries are added to each table row, =topic= and the equivalent of the reverse relation described above, represented by =_up=. So if you load a table type "CookingTimes", each row will have =topic= set to the name of the topic it was loaded from and =_up= set to the map of that topic. This allows you to refer to the fields of the topic that contains a table even after the table has been extracted. 432 432 433 When a table contains calculations using TWiki:Plugins.SpreadSheetPlugin, these are applied before the map entries are created for this table. These calculations must not refer to data outside of the table.433 When a table contains calculations using Foswiki:Extensions.SpreadSheetPlugin, these are applied before the map entries are created for this table. These calculations must not refer to data outside of the table. 434 434 435 435 If there are multiple EDITTABLE calls with the same table type, all the table … … 460 460 </pre> 461 461 * You can set a global default for the =moan= parameter by setting the =FORMQUERYPLUGIN_MOAN variable in %USERSWEB%.SitePreferences, WebPreferences in individual webs, or in individual topics. 462 * FormQueryPlugin must appear in the Plugins evaluation order *before* TWiki:Plugins/SpreadSheetPlugin. You can ensure this by putting !FormQueryPlugin immediately after Default<nop>Plugin in the {PluginsOrder} list in =configure=.463 * Note: If you are using it, TWiki:Plugins/MacrosPlugin must appear in the Plugins evaluation order *before* FormQueryPlugin.462 * FormQueryPlugin must appear in the Plugins evaluation order *before* Foswiki:Extensions/SpreadSheetPlugin. You can ensure this by putting !FormQueryPlugin immediately after Default<nop>Plugin in the {PluginsOrder} list in =configure=. 463 * Note: If you are using it, Foswiki:Extensions/MacrosPlugin must appear in the Plugins evaluation order *before* FormQueryPlugin. 464 464 465 465 --- … … 471 471 | 21 May 2007 | Bugs:Item3969 - 8bit email fix (TWiki:Main.WillNorris) | 472 472 | 24 Apr 2007 (13527) | Merge !YetAnotherFormQueryPlugin back in. Fixed a lot. Prepared for use with TWiki 4.2. | 473 | 04 Sep 2006 | Expand calculations using TWiki:Plugins.FormQueryPlugin. |473 | 04 Sep 2006 | Expand calculations using Foswiki:Extensions.FormQueryPlugin. | 474 474 | 23 Jun 2006 | Ported to Dakar. | 475 | 9 Jul 2005 | Added support for tables defined using TWiki:Plugins/EditTablerowPlugin |475 | 9 Jul 2005 | Added support for tables defined using Foswiki:Extensions/EditTablerowPlugin | 476 476 | | Added support for searches over multiple webs | 477 477 | | Support !%MATCHCOUNT% | 478 | | Allow TWiki:Plugins/SpreadSheetPlugin computation to be applied to the result of a query |478 | | Allow Foswiki:Extensions/SpreadSheetPlugin computation to be applied to the result of a query | 479 479 | | Made "moan" a preference rather than a per call option | 480 480 | | Removed !%TOPICCREATOR% | 481 | | Removed !%ARITHMETIC% (as one can use the TWiki:Plugins/SpreadSheetPlugin) |481 | | Removed !%ARITHMETIC% (as one can use the Foswiki:Extensions/SpreadSheetPlugin) | 482 482 | | Removed the color map feature | 483 483 | | Extended !%FQPINFO% to support showing results of queries | … … 496 496 | 05 Feb 2004 | Bugfix version | 497 497 | 11 Jul 2003 | Initial version | 498 | TWiki Dependencies: | TWiki:Plugins.SpreadSheetPlugin |499 | Dependencies: | <table border=1><tr><th align="left">Name</th><th align="left">Version</th><th align="left">Description</th></tr><tr><td align="left">TWiki::Contrib::DBCacheContrib</td><td align="left">>=1.001</td><td align="left">Required. Download and install from the TWiki:Plugins/DBCacheContrib code library.</td></tr></tr><tr><td align="left">Time::ParseDate</td><td align="left">Required. Available from [[http://cpan.uwinnipeg.ca/dist/Time-modules][CPAN]].</td></tr><tr><td align="left">Storable</td><td align="left">>=2.07</td><td align="left">2.13 recommended; accelerates cache handling. Available from [[http://cpan.uwinnipeg.ca/dist/Storable][CPAN]]</td></tr><tr><td align="left">TWiki::Plugins::MacrosPlugin</td><td align="left">>=1.000</td><td align="left">Recommended; used for parameterised includes. Download from TWiki:Plugins/MacrosPlugin repository.</td></tr></table> |498 | TWiki Dependencies: | Foswiki:Extensions.SpreadSheetPlugin | 499 | Dependencies: | <table border=1><tr><th align="left">Name</th><th align="left">Version</th><th align="left">Description</th></tr><tr><td align="left">TWiki::Contrib::DBCacheContrib</td><td align="left">>=1.001</td><td align="left">Required. Download and install from the Foswiki:Extensions/DBCacheContrib code library.</td></tr></tr><tr><td align="left">Time::ParseDate</td><td align="left">Required. Available from [[http://cpan.uwinnipeg.ca/dist/Time-modules][CPAN]].</td></tr><tr><td align="left">Storable</td><td align="left">>=2.07</td><td align="left">2.13 recommended; accelerates cache handling. Available from [[http://cpan.uwinnipeg.ca/dist/Storable][CPAN]]</td></tr><tr><td align="left">TWiki::Plugins::MacrosPlugin</td><td align="left">>=1.000</td><td align="left">Recommended; used for parameterised includes. Download from Foswiki:Extensions/MacrosPlugin repository.</td></tr></table> | 500 500 | Perl Version: | 5.0 | 501 501 | Plugin Home: | http://foswiki.org/Extensions/%TOPIC% |
Note: See TracChangeset
for help on using the changeset viewer.
