How long will fines that were paid be retrievable by a query?
Applies to
- Wise Manager
Answer
The transactions are retained, but two years after the date on which the fines were paid, they are moved to the archive table (fin_posten_archief). If you're writing a SQL query to find paid items with a paid date older than two years, you will need to look in the fin_posten_archief table instead.
For example, if it's March 2026 and you want to run a report that shows transactions paid in March 2023, you will use the following query:
SELECT
instantie_id AS Library_ID,
adm_kode AS Booking_Code,
adm_vest AS Branch_ID,
adm_oms AS Description,
adm_ekode AS Journal_Code,
adm_bedrag AS Amount_Cents
FROM fin_posten_archief
WHERE adm_edatum >= '2023-01-01 00:00:00'
AND adm_edatum <= '2023-02-28 23:59:59'
AND adm_status = '*'
LIMIT 9999;
Page ID
7483