| 1 | = Wiki table = |
| 2 | |
| 3 | == Description == |
| 4 | |
| 5 | This is a simple macro that enables you to place tables resulting from SQL queries into a wiki page. |
| 6 | |
| 7 | It is similar to, but simpler than, SqlQueryMacro. The main differences are that it has fewer dependencies and always queries the Trac database, rather than letting you set up a separate data connection. |
| 8 | |
| 9 | == Bugs/Feature Requests == |
| 10 | |
| 11 | Existing bugs and feature requests for WikiTableMacro are |
| 12 | [report:9?COMPONENT=WikiTableMacro here]. |
| 13 | |
| 14 | If you have any issues, create a |
| 15 | [http://trac-hacks.org/newticket?component=WikiTableMacro&owner=optilude new ticket]. |
| 16 | |
| 17 | == Download == |
| 18 | |
| 19 | Download the zipped source from [download:wikitablemacro here]. |
| 20 | |
| 21 | == Source == |
| 22 | |
| 23 | You can check out WikiTableMacro from [http://trac-hacks.org/svn/wikitablemacro here] using Subversion, or [source:wikitablemacro browse the source] with Trac. |
| 24 | |
| 25 | == Example == |
| 26 | |
| 27 | Use the !SQLTable macro: |
| 28 | |
| 29 | {{{ |
| 30 | {{{ |
| 31 | #!SQLTable |
| 32 | SELECT count(id) as 'Number of Tickets' |
| 33 | FROM ticket |
| 34 | }}} |
| 35 | }}} |
| 36 | |
| 37 | The result will be a table. |
| 38 | |
| 39 | == Recent Changes == |
| 40 | |
| 41 | [[ChangeLog(wikitablemacro, 3)]] |
| 42 | |
| 43 | == Author/Contributors == |
| 44 | |
| 45 | '''Author:''' [wiki:optilude] [[BR]] |
| 46 | '''Contributors:''' |