Bug 26107

Summary: Add ability to delete saved SQL report results
Product: Koha Reporter: Liz Rea <wizzyrea>
Component: ReportsAssignee: Bugs List <koha-bugs>
Status: RESOLVED MOVED QA Contact: Testopia <testopia>
Severity: enhancement    
Priority: P5 - low    
Version: unspecified   
Hardware: All   
OS: All   
See Also: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17350
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32311
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:

Description Liz Rea 2020-07-30 17:09:53 UTC
Currently we can generate report output to be presented in the Koha interface in a scheduled fashion, but we cannot delete any of the previous runs, either automatically via a scheduler or on the fly from the interface.

I propose we add two functions:

1. the ability to delete individual saved report results from the Koha interface (a link or a button near the run a user might like to delete)

2. the ability to have a flag for cleanup_database to remove saved report results older than a syspref'd number of days. Please, don't make it a number on the cron definition - we want libraries to be able to control it themselves from the interface.

This can potentially reduce the reliance on e-mail as a delivery mechanism for saved reports, which in certain circumstances can be less reliable than we'd hope.

Liz
Comment 1 Katrin Fischer 2023-09-16 17:01:38 UTC
(In reply to Liz Rea from comment #0)
> Currently we can generate report output to be presented in the Koha
> interface in a scheduled fashion, but we cannot delete any of the previous
> runs, either automatically via a scheduler or on the fly from the interface.
> 
> I propose we add two functions:
> 
> 1. the ability to delete individual saved report results from the Koha
> interface (a link or a button near the run a user might like to delete)

This is covered by this bug now:

Bug 32311 - Add option to delete saved reports results from staff interface


> 2. the ability to have a flag for cleanup_database to remove saved report
> results older than a syspref'd number of days. Please, don't make it a
> number on the cron definition - we want libraries to be able to control it
> themselves from the interface.

Solved: bug 17350

   --reports DAYS          Purge reports data saved more than DAYS days ago. The data is created by running runreport.pl with the --store-results option.