Opened 6 years ago

Closed 4 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 6 years ago by elecnix

  • Cc elecnix added

comment:2 Changed 4 years ago by rjollos

  • Owner changed from optilude to rjollos

Changing ticket owner as maintainership will soon be transferred.

comment:3 Changed 4 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 .
as The resolution will be set. Next status will be 'closed'.
to The owner will be changed from rjollos. Next status will be 'closed'.
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.