Version 7 (modified by 14 years ago) (diff) | ,
---|
SQL Table in Wiki Page
Notice: This plugin is unmaintained and available for adoption.
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 here.
If you have any issues, create a new ticket.
Download
Download the zipped source from [download:wikitablemacro here].
Source
You can check out WikiTableMacro from here using Subversion, or 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.
Use the SQLScalar macro:
{{{ #!SQLScalar SELECT count(id) as 'Number of Tickets' FROM ticket }}}
The result will be a single number.
Recent Changes
- 18622 by jun66j5 on 2024-02-26 11:46:22
-
WikiTableMacro 0.3dev: fix compatible with Python 3
- 18458 by rjollos on 2021-12-14 15:55:25
-
WikiTableMacro 0.3dev: Make exception handling Py3 compatible
Refs #14101.
- 16994 by rjollos on 2017-11-20 00:43:24
-
WikiTableMacro 0.3: Release version 0.3
Fixes #13336.
(more)