Modify

Opened 7 years ago

Closed 7 years ago

Last modified 7 years ago

#1913 closed defect (fixed)

0.11 workflow compatibility

Reported by: bewst Owned by: bobbysmith007
Priority: high Component: TimingAndEstimationPlugin
Severity: critical Keywords:
Cc: aqualx@… Trac Release: 0.11

Description

In the reports I see conditions like

   t.status IN ($NEW, $ASSIGNED, $REOPENED, $CLOSED)

but for 0.11 all reports with

    status IN ('new', 'assigned', 'reopened', 'closed )

got upgraded to

    status <> 'closed'

If you don't make a corresponding change, tickets disappear from reports when their status becomes 'accepted', and presumably the new workflow means tickets can go through any number of other states. I think this fact leads naturally to reconsidering the appropriateness of the status checkboxes in the query UI.

Attachments (0)

Change History (9)

comment:1 Changed 7 years ago by bobbysmith007

Yeah. I will look at making this database driven in the future so that it will work. Might be tough, but I will see what I can do.

In the mean time, check out the /query interface, to see if you can accomplish what you need.

Russ

comment:2 Changed 7 years ago by aqualx@…

  • Cc aqualx@… added

comment:3 Changed 7 years ago by bewst

What /query interface?

comment:4 follow-up: Changed 7 years ago by bobbysmith007

type /query after your main url , or click the "Custom Query" button on the "View Tickets" screen.

hth,
Russ

comment:5 in reply to: ↑ 4 Changed 7 years ago by anonymous

Replying to bobbysmith007:

type /query after your main url , or click the "Custom Query" button on the "View Tickets" screen.

You can't use the query interface to get almost any of the useful reports. For one thing it queries by ticket, not by ticket change. For another thing there's no way to get e.g., the total hours worked by an individual. For another, there's no filtering by billing period.

But that should be obvious to the person who created the TimingAndEstimationPlugin (you had to build some pretty complex SQL queries), so I'm wondering if somehow I'm missing something.

comment:6 Changed 7 years ago by bobbysmith007

Yeah, It certainly doesnt fix everything (or even much of anything), but its is the best I can do until I can figure out someway to make this work. Last I worked on it, I could not come up with an elegant solution to this. Still thinking about it, but with no answer.

Sorry I cant be of more use,
Russ

comment:7 Changed 7 years ago by bobbysmith007

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

(In [2774]) closes #1913

After much waiting and thinking, I came to the conclusion that the best way to handle the dynamic statuses was to rebuild the reports each time they change. To that end I have added code to check to see if the statuses have changed and then update the reports with the new statuses every time they change (requiring a trac-admin upgrade). Rendering out the statuses and the linkifying javascript were changed to be compatible with this.

comment:8 Changed 7 years ago by bobbysmith007

(In [2775]) re #1913
bumped version number to 0.5.0

comment:9 Changed 7 years ago by bobbysmith007

(In [2776]) re #1913

refactored reportmanager a bit more in response to feed back from Colin Guthrie

bumped version number to 0.5.1

Add Comment

Modify Ticket

Action
as 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.