Opened 9 years ago

Closed 8 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


If I follow the README.txt as well as the home page for this plugin, I would use it like:

        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 9 years ago by Nicolas Marchildon

Cc: Nicolas Marchildon added; anonymous removed

comment:2 Changed 8 years ago by Ryan J Ollos

Owner: changed from Martin Aspeli to Ryan J Ollos

Changing ticket owner as maintainership will soon be transferred.

comment:3 Changed 8 years ago by Ryan J Ollos

Resolution: worksforme
Status: newclosed

I'm using the following in 0.11.4

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):

    SELECT count(id) as 'Number of Tickets'
    FROM ticket

Modify Ticket

Change Properties
Set your email in Preferences
as closed The owner will remain Ryan J Ollos.
The resolution will be deleted.

Add Comment

E-mail address and name can be saved in the Preferences.

Note: See TracTickets for help on using tickets.