Modify

Opened 6 years ago

Closed 6 years ago

Last modified 6 years ago

#4003 closed defect (invalid)

Can't get HoursInPlaceEditor to work

Reported by: anonymous Owned by: 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 (0)

Change History (3)

comment:1 Changed 6 years ago 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.

comment:2 Changed 6 years ago by hoessler

  • Resolution set to invalid
  • Status changed from new to closed

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.

comment:3 Changed 6 years ago by JasonWinnebeck

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

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