Modify

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

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

{{{
#!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 .
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'.
Author


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

 
Note: See TracTickets for help on using tickets.