Accidentally Delete a Report? These steps will show you how to recover it

Action logs are your friend

In this Koha tutorial we will walk you through recovering a deleted report. Reports in Koha are a way to gather data. Reports are used to generate statistics, member lists, shelving lists, or any list of data in your database.

First, make sure your system preference to log report changes is turned on. Actions within the Koha system are tracked in log files. Your system preferences can be changed to prevent the logging of different actions. Go to Administration › System preferences › Logs. The ReportsLog must be set to log to track when reports are added, deleted or changed. These logs can be viewed using the Log Viewer Tool.

Next, go to Tools › Log viewer. Select the Reports log, and optionally, depending on how active report usage is in your library, the Delete action. You can add additional parameters like the report ID for the object (if known) or enter a date range if needed to limit results.

The results will appear in the info column where the SQL information is intact:

From there, you can copy the SQL query into a fresh report.

Like all logs, it won't work if you don't have it turned on, so it's better to make sure it's on before you need it rather than finding out it wasn't enabled. In general, it's always good to check periodically on what logs you have enabled, since new logs are developed and added to Koha as the product grows.

• Related Articles

• Creating and Running Reports

  Koha uses SQL (Structured Query Language) for reports. Basically, you are asking, via SQL, to select certain information from specific fields, where the information matches specified criteria. Of course, libraries who are comfortable with SQL can ...

• Koha Item Status Reports

  In another article, there was a discussion of a variety of item statuses and how their behavior can be customized in Koha. That article covered everything that is a “status” in Koha: Withdrawn, Lost, Damaged, Restricted, and Not For Loan. However, ...

• Using Mana to Import Reports into Koha

  The Koha community shares reports through Mana-kb. The setup is the same as for Serials and adds a Mana link in the Reports Module. Using Mana in the Reports Module When creating a SQL report, there is a an option in the dropdown - “New SQL from ...

• Koha Glossary of Terms

  Find the basics of Koha's vocabulary here This glossary is in alphabetical order. Use control+F to quickly search this page for specific terms. Authority Record: allows your library to control and search fields in your MARC records such as subject ...

• Logs in Koha

  <br> Logs? What are those? Koha has the ability to log actions within your system. These logs are broken out into modules and libraries can pick and choose which logs are stored and for how long. Actions within the Koha ...