Modify ↓
Opened 17 years ago
Closed 16 years ago
#4399 closed defect (worksforme)
README.txt has wrong example
| Reported by: | anonymous | Owned by: | Ryan J Ollos |
|---|---|---|---|
| Priority: | high | Component: | WikiTableMacro |
| Severity: | normal | Keywords: | |
| Cc: | Nicolas Marchildon | Trac Release: | 0.11 |
Description
If I follow the README.txt as well as the home page for this plugin, I would use it like:
{{{
#!SQLTable
SELECT count(id) as 'Number of Tickets'
FROM ticket
}}}
However, it does not work on Trac 0.11.1. I had to use:
[[SQLTable(SELECT count(id) as 'Number of Tickets' FROM ticket)]]
Please update the documentation.
Attachments (0)
Change History (3)
comment:1 Changed 17 years ago by
| Cc: | Nicolas Marchildon added; anonymous removed |
|---|
comment:2 Changed 16 years ago by
| Owner: | changed from Martin Aspeli to Ryan J Ollos |
|---|
comment:3 Changed 16 years ago by
| Resolution: | → worksforme |
|---|---|
| Status: | new → closed |
I'm using the following in 0.11.4
{{{
#!SQLTable
SELECT name FROM enum WHERE type = 'priority'
}}}
I tried your example as well and it worked fine. I'm not sure why it wouldn't work for you. If you wish to follow-up we can discussed further.
The only thing I can say is that you can't indent the following, like shown above (though I'm guessing that is just how you added to this ticket):
{{{
#!SQLTable
SELECT count(id) as 'Number of Tickets'
FROM ticket
}}}
Note: See
TracTickets for help on using
tickets.



Changing ticket owner as maintainership will soon be transferred.