Package version/links:
pmwiki-2.2.5
Skin - pmwiki
txtdb-2.2.0-alpha-6-20100212
Txtdb - Sql query using txtdb directives
- Data source in Csv in wikipage and PmWiki simple table
- Output as 'Table/Wikitable'
- Output behaviour - 'Transpose'
Table(From Csv) - Output(Table,Sortable)
(:txtdbSet id1 'Cookbook.Txtdb-sample1' birt:)
(:txtdbQuery id1 "SELECT Name,LastName,FirstName,phone FROM Customers WHERE
FirstName LIKE 'A%' ":)
(:txtdbDraw id1 table sortable id=id100:)
(:sortable:)
|
| Name | LastName | FirstName | phone |
|---|
| Feuer Online Stores, Inc | Feuer | Austin | 0342-555176 |
| Kremlin Collectables, Co. | Semenov | Alexander | +7 812 293 0521 |
|
Table(From PmWiki Simple Table) - Output(Table,Sortable)
(:txtdbSet id1 'Cookbook.Txtdb-sample3' mydb2:)
(:txtdbQuery id1 "SELECT * FROM GreekAlphabet LIMIT 5":)
(:txtdbDraw id1 table sortable id=id101:)
(:sortable:)
|
| col1 | col2 | col3 | col4 | col5 |
|---|
| alpha | beta | gamma | delta | epsilon |
| zeta | eta | theta | iota | kappa |
| lamda | mu | nu | xi | omikron |
| pi | rho | sigma | tau | upsilon |
| phi | chi | psi | omega | |
|
Table(From PmWiki Simple Table) - Output(WikiTable,Transpose and Sortable)
Recalling same id txtDraw
(:txtdbDraw id1 wikitable 'transpose,sortable' id=id102:)
(:sortable:)
|
| col1 | alpha | zeta | lamda | pi | phi |
| col2 | beta | eta | mu | rho | chi |
| col3 | gamma | theta | nu | sigma | psi |
| col4 | delta | iota | xi | tau | omega |
| col5 | epsilon | kappa | omikron | upsilon | |
|