Bug 26107 - Add ability to delete saved SQL report results
Summary: Add ability to delete saved SQL report results
Status: RESOLVED MOVED
Alias: None
Product: Koha
Classification: Unclassified
Component: Reports (show other bugs)
Version: unspecified
Hardware: All All
: P5 - low enhancement (vote)
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-07-30 17:09 UTC by Liz Rea
Modified: 2023-09-16 17:01 UTC (History)
0 users

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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.