Opened 8 years ago

Closed 7 years ago

#4399 closed defect (worksforme)

README.txt has wrong example

Reported by: anonymous Owned by: rjollos
Priority: high Component: WikiTableMacro
Severity: normal Keywords:
Cc: elecnix 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 8 years ago by elecnix

  • Cc elecnix added; anonymous removed

comment:2 Changed 7 years ago by rjollos

  • Owner changed from optilude to rjollos

Changing ticket owner as maintainership will soon be transferred.

comment:3 Changed 7 years ago by rjollos

  • Resolution set to worksforme
  • Status changed from new to closed

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

Add Comment

Modify Ticket

as closed The owner will remain rjollos.
The resolution will be deleted. Next status will be 'reopened'.

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

Note: See TracTickets for help on using tickets.