Edgewall Software
Modify

Opened 14 years ago

Last modified 7 years ago

#1943 new enhancement

Add support for date calculations in ticket reports/querys

Reported by: anonymous Owned by:
Priority: normal Milestone: unscheduled
Component: report system Version: 0.8.4
Severity: normal Keywords: query datetime
Cc: Branch:
Release Notes:
API Changes:

Description

This enables rudimentary project management

Attachments (0)

Change History (8)

comment:1 by anonymous, 14 years ago

Type: defectenhancement

comment:2 by Christopher Lenz, 14 years ago

Milestone: 0.9
Priority: highnormal

Please be more specific. What kind of calculations do you have in mind?

comment:3 by anonymous, 14 years ago

Date calculations for reports might include the following:

  • All tickets with field1 before or after a given date
  • All tickets with field1 before/after field2 by a certain amount (in the same ticket)
  • All tickets with field1 before or after field2 from a particular ticket

Examples questions that could be answered through such reports:

  • Which tickets are not expected to be completed by a certain date?
  • Which tickets are expected to be completed more than a week after their targets?
  • Which tickets are expected to start before this ticket is expected to complete?

This assumes that a custom field has been defined for start, targeted, and expected dates.

comment:4 by Emmanuel Blot, 14 years ago

I think you can do this kind of requests with custom SQL requests, can't you ?

comment:5 by anonymous, 14 years ago

It would be pretty tough if the data isn't stored as a date. The custom request would have to validate the entry as a data/put it in canonical form & then do the computation.

It strikes me a very difficult to pull off without #1942, and your comment there suggests that #1942 may be a serious piece of work.

comment:6 by Christian Boos, 13 years ago

Keywords: query datetime added
Milestone: 0.12

#4594 was closed as duplicate.

See also #2288 which is more about adding time query capabilities to the custom query UI.

comment:7 by Remy Blank, 9 years ago

Milestone: next-major-0.1Xunscheduled
Owner: daniel removed

in reply to:  3 comment:8 by Peter Suter, 7 years ago

Replying to anonymous:

Date calculations for reports might include the following:

  • All tickets with field1 before or after a given date

Examples questions that could be answered through such reports:

  • Which tickets are not expected to be completed by a certain date?

This assumes that a custom field has been defined for start, targeted, and expected dates.

That part should be possible now with e.g. [[TicketQuery(expected_completion_date=in1month..)]] assuming a custom ticket

[ticket-custom]
expected_completion_date = time
expected_completion_date.format = relative

Modify Ticket

Change Properties
Set your email in Preferences
Action
as new The ticket will remain with no owner.
The ticket will be disowned. Next status will be 'new'.
as The resolution will be set. Next status will be 'closed'.
The owner will be changed from (none) to anonymous. Next status will be 'assigned'.

Add Comment


E-mail address and name can be saved in the Preferences .
 
Note: See TracTickets for help on using tickets.