Modify

Opened 8 years ago

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

Cc: Nicolas Marchildon added; anonymous removed

comment:2 Changed 7 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 7 years ago by Ryan J Ollos

Resolution: worksforme
Status: newclosed

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
}}}

Modify Ticket

Action
as closed The owner will remain Ryan J Ollos.
The resolution will be deleted. Next status will be 'reopened'.

Add Comment


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

 
Note: See TracTickets for help on using tickets.