Edgewall Software
Modify

Opened 11 years ago

Closed 5 years ago

#9982 closed defect (worksforme)

No link to save custom queries

Reported by: trac@… Owned by:
Priority: normal Milestone:
Component: report system Version: 0.12-stable
Severity: normal Keywords: refactoring
Cc: Branch:
Release Notes:
API Changes:
Internal Changes:

Description

According to [TracQuery] one should be able to save Queries by clicking the "Save Query" button, however there is no such button or link that I can find. Do I need to enable that feature somewhere? Or was it left out in 0.12

Thanks

Attachments (0)

Change History (15)

comment:1 by Remy Blank, 11 years ago

Resolution: worksforme
Status: newclosed

You need the REPORT_CREATE permission to save queries, as they are saved as reports.

comment:2 by Christian Boos, 11 years ago

(see also #9617)

comment:3 by tom@…, 11 years ago

Thanks! Did not know I needed to add REPORT_CREATE on top of TRAC_ADMIN.

comment:4 by Christian Boos, 11 years ago

Really? If you have the TRAC_ADMIN permission, you should also have every other permissions. We could verify, but please first double check.

comment:5 by tom@…, 11 years ago

I am doing everything as anonymous, with TRAC_ADMIN and the save query was not there. I had to add REPORT_CREATE to anonymous to get it to work.

comment:6 by trac@…, 11 years ago

Also, after adding REPORT_CREATE I do get the Save Query button, but when I click that, I get the error message:

Error: Not Found No handler matched request to /report

comment:7 by Christian Boos, 11 years ago

Ah, well, then it's something different: you simply disabled the trac.ticket.report.* modules. Check your TracIni#components-section.

Last edited 11 years ago by Christian Boos (previous) (diff)

comment:8 by trac@…, 11 years ago

Well the [TracReports] page does say to:

[components] trac.ticket.report.* = disabled in order to remove the report completely, and use the TracQuery system

in reply to:  8 comment:9 by trac@…, 11 years ago

Replying to trac@…:

Well the [TracReports] page does say to:

[components] trac.ticket.report.* = disabled in order to remove the report completely, and use the TracQuery system

I did try trac.ticket.report.ReportModule = disabled with the same result.

comment:10 by Christian Boos, 11 years ago

Resolution: worksforme
Status: closedreopened

But you'd have to enable it instead… You can't save a query if the reports module is disabled, as those queries are saved in the form of a report. Not perfect, we know.

One possible improvement would be to add a setting for disabling the creation and editing of SQL reports, which are the ones with the drawbacks mentioned in the TracReports page. The list of reports, the wiki syntax and the possibility to saves and edit the non-SQL queries would continue to work.

comment:11 by Remy Blank, 11 years ago

(Mid-air collision)

I know it's an implementation detail, and users shouldn't have to know that, but saved queries are stored as reports, so if you disable reports, you can't have saved queries.

You should re-activate ticket reports, and if you want your users to go to the query page when clicking on "View Tickets", use the [mainnav] section to re-route the link (see TracInterfaceCustomization).

comment:12 by trac@…, 11 years ago

Thanks that got it working!

in reply to:  10 comment:13 by Christian Boos, 11 years ago

Keywords: refactoring added
Milestone: next-major-0.1X

Keeping on the radar for the refactoring implied by comment:10.

I think we can make a generic trac.report module, with the usual api/model/web_ui files. The details of handling and rendering legacy SQL reports could stay in source:trunk/trac/ticket/report.py and source:trunk/trac/ticket/templates/

That way, it will be easy to disable trac.ticket.report.* and still have the report list of saved custom queries.

comment:14 by Ryan J Ollos, 7 years ago

Status: reopenednew

comment:15 by Ryan J Ollos, 5 years ago

Milestone: next-major-releases
Resolution: worksforme
Status: newclosed

This ticket was largely a support issue, so I've created #12786 which clearly describes the proposed enhancement.

Modify Ticket

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

Add Comment


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