= SQL Table in Wiki Page = == Description == This is a simple macro that enables you to place tables resulting from SQL queries into a wiki page. 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. == Bugs/Feature Requests == Existing bugs and feature requests for WikiTableMacro are [report:9?COMPONENT=WikiTableMacro here]. If you have any issues, create a [http://trac-hacks.org/newticket?component=WikiTableMacro&owner=optilude new ticket]. == Download == Download the zipped source from [download:wikitablemacro here]. == Source == You can check out WikiTableMacro from [http://trac-hacks.org/svn/wikitablemacro here] using Subversion, or [source:wikitablemacro browse the source] with Trac. == Example == Use the !SQLTable macro: {{{ {{{ #!SQLTable SELECT count(id) as 'Number of Tickets' FROM ticket }}} }}} The result will be a table. == Recent Changes == [[ChangeLog(wikitablemacro, 3)]] == Author/Contributors == '''Author:''' [wiki:optilude] [[BR]] '''Contributors:'''