Edgewall Software
Modify ↓

Opened 19 years ago

Closed 19 years ago

Last modified 19 years ago

#3194 closed defect (duplicate)

"All Tickets By Milestone (Including closed)" report execution fails on PostgreSQL

Reported by: kbogdanov@… Owned by: daniel
Priority: normal Milestone:
Component: report system Version: devel
Severity: normal Keywords:
Cc: Branch:
Release Notes:
API Changes:
Internal Changes:

Description

It fails with the following error message: 

'Report execution failed: ERROR: column "modified" does not exist'

The problem is in the 'ORDER BY' statement. I temporary fixed it: 

-  ORDER BY (milestone IS NULL), milestone DESC, (status = 'closed'), 
-        (CASE status WHEN 'closed' THEN modified ELSE (-1)*p.value END) DESC
+  ORDER BY (milestone IS NULL), milestone DESC, (status = 'closed'), changetime DESC

but I'm not sure if it's correct.

Attachments (0)

Change History (2)

comment:1 by Jonas Borgström, 19 years ago

Resolution: → duplicate
Status: new → closed

A duplicate of #2123.

comment:2 by Christian Boos, 19 years ago

Milestone: 0.10

Modify Ticket

Change Properties
Set your email in Preferences
Action
as closed The owner will remain daniel.
The resolution will be deleted. Next status will be 'reopened'.
to The owner will be changed from daniel to the specified user.

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