Edgewall Software
Modify

Opened 13 years ago

Last modified 6 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:
Release Notes:
API Changes:

Description

This enables rudimentary project management

Attachments (0)

Change History (8)

comment:1 Changed 13 years ago by anonymous

Type: defectenhancement

comment:2 Changed 13 years ago by Christopher Lenz

Milestone: 0.9
Priority: highnormal

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

comment:3 Changed 13 years ago by anonymous

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 Changed 13 years ago by Emmanuel Blot

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

comment:5 Changed 13 years ago by anonymous

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 Changed 11 years ago by Christian Boos

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 Changed 8 years ago by Remy Blank

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

comment:8 in reply to:  3 Changed 6 years ago by Peter Suter

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.
as The resolution will be set.
The owner will be changed from (none) to anonymous.

Add Comment


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