Edgewall Software
Modify

Ticket #497 (closed defect: fixed)

Opened 8 years ago

Last modified 5 years ago

SQL Query view of report doesn't work when the query contains dynamic variables

Reported by: cmlenz Owned by: cmlenz
Priority: normal Milestone: 0.7.1
Component: report system Version: 0.7
Severity: normal Keywords:
Cc:
Release Notes:
API Changes:

Description

When the "SQL Query" view of a report that contains dynamic variable is requested, Trac fails the the error message "Report failed: Dynamic variable '$BLA' not defined."

For example: http://projects.edgewall.com/trac/report/14?format=sql

Attachments

Change History

comment:1 Changed 8 years ago by cmlenz

  • Owner changed from daniel to cmlenz
  • Status changed from new to assigned

comment:2 Changed 8 years ago by cmlenz

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

Fixed in [704] (trunk) and [705] (0.7-stable).

comment:3 in reply to: ↑ description Changed 6 years ago by anonymous

Replying to cmlenz:

When the "SQL Query" view of a report that contains dynamic variable is requested, Trac fails the the error message "Report failed: Dynamic variable '$BLA' not defined."

For example: http://projects.edgewall.com/trac/report/14?format=sql

comment:4 Changed 6 years ago by anonymous

  • Resolution fixed deleted
  • Status changed from closed to reopened

comment:5 Changed 6 years ago by mgood

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

If you're going to reopen a ticket please explain why. This problem noted in this ticket was fixed and still works as expected.

comment:6 follow-up: Changed 5 years ago by anonymous

  • Resolution fixed deleted
  • Status changed from closed to reopened

does not work, even just now.
just click on http://trac.edgewall.org/report/14 to see.

comment:7 in reply to: ↑ 6 Changed 5 years ago by mgood

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

Replying to anonymous:

does not work, even just now.
just click on http://trac.edgewall.org/report/14 to see.

That is expected for viewing the report itself. This ticket is about clicking on the "SQL Query" link at the bottom of the report page (sorry, you can't view that on this site without a login).

View

Add a comment

Modify Ticket

Change Properties
<Author field>
Action
as closed
The resolution will be deleted. Next status will be 'reopened'
to The owner will be changed from cmlenz. Next status will be 'closed'
Author


E-mail address and user name can be saved in the Preferences.

 
Note: See TracTickets for help on using tickets.