Modify

Opened 6 years ago

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

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

  • Cc elecnix added

comment:2 Changed 5 years ago by rjollos

  • Owner changed from optilude to rjollos

Changing ticket owner as maintainership will soon be transferred.

comment:3 Changed 5 years ago by rjollos

  • Resolution set to worksforme
  • Status changed from new to 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
}}}

Add Comment

Modify Ticket

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


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

 
Note: See TracTickets for help on using tickets.