Ticket #4003 (closed defect: invalid)

Opened 5 years ago

Last modified 4 years ago

Can't get HoursInPlaceEditor to work

Reported by: anonymous Assigned to: hoessler
Priority: normal Component: EstimationToolsPlugin
Severity: normal Keywords:
Cc: Trac Release: 0.11

Description

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.

Attachments

Change History

10/29/08 18:24:00 changed by 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.

10/29/08 21:18:38 changed by hoessler

  • status changed from new to closed.
  • resolution set to invalid.

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.

01/30/09 10:49:51 changed by JasonWinnebeck

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

Add/Change #4003 (Can't get HoursInPlaceEditor to work)




Change Properties
Action