Can't get HoursInPlaceEditor to work

[anonymous]

I'm using trac 0.11. I've installed the requirement XmlRpcPlugin, and activated that component in my trac.ini.

The log file is not spitting out any errors for this. But when I run my custom query

SELECT p.value AS __color__,
   id AS ticket, summary, component, version, milestone, t.type AS type, 
   owner, status,
   time AS created,
   changetime AS _changetime, description AS _description,
   reporter AS _reporter,
   ifnull (tc.value,'') as Hrs
  FROM ticket t
  LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority'
  LEFT JOIN ticket_custom tc ON tc.ticket = t.id and tc.name = 'estimatedhours'
  WHERE status <> 'closed'
  ORDER BY CAST(p.value AS int), milestone, t.type, time

I can't seem to be able to edit the hours that come up in the query result page.

Any help would be appreciated. Thanks.

[anonymous]

Here's some more info I found out.

The HoursInPlaceEditor won't work when I make the adjustment to my sql query as suggested in the "Customising Queries" section, on the main page of this hack, to show remaining hours in my tickets.

However, if I try and make a "Custom Query" through the "Custom Query" link on the ticket page and add in "Hours Remaining" in my columns, then HoursInPlaceEditor works.

Is there any way of getting HoursInPlaceEditor to work when I make a custom sql query that joins estimation time table and the ticket table in the database? Or just to add the estimated hours in my normal ticket views with HoursInPlaceEditor working?

If this is only suppose to be working through the "Custom Query" link of the tickets, the main page needs to be adjusted to make that clear.

[Joachim Hoessler]

You're right, the HoursInPlaceEditor only works with "custom query", and wasn't designed to work with sql reports. The paragraph about "Customising Queries" has been added by someone else, and maybe wasn't that well placed. I hope its purpose is clearer now.

[Jason Winnebeck]

See #4549 for a feature enhancement with patch to fix this issue.