by Kelly McElligott on Jun 15, 2020
Report Changes
In 19.11, the database structure changed in the Accountlines table. Due to this, some of the library's existing reports will need to be changed.
If you are a ByWater partner, you probably saw the SQL on the main page of your Staff Interface which you could run and find out what reports will need to be edited. This is further discussed here:
Watch out for 19.11 News on your Staff Client!
Andrew joined Jessie and Kelly to talk about the changes in 19.11 and how a library can edit a report with the new schema changes. Andrew shared the blog post he wrote earlier about the change here:
The Accountlines Table in 19.11
Monday Minutes
Before Report
SELECT a.date, a.accounttype, p.surname, p.firstname, p.borrowernumber, FORMAT(abs(sum(a.amount)),2) AS 'Total Collected', a.manager_id as 'staff borrowernumber'
FROM accountlines a
LEFT JOIN borrowers p using (borrowernumber)
WHERE a.accounttype IN ('C','PAY','W','PAY02') AND
a.date BETWEEN <> AND <> group by a.accountlines_id
Revised Report
SELECT a.date, a.credit_type_code, a.status, p.surname, p.firstname, p.borrowernumber, FORMAT(abs(sum(a.amount)),2) AS 'Total Collected',a.payment_type, a.manager_id as 'staff borrowernumber'
FROM accountlines a
LEFT JOIN borrowers p using (borrowernumber)
WHERE a.credit_type_code is not null AND
a.date BETWEEN <> AND <> group by a.accountlines_id
Need more help?
If you are not able to edit your reports- please send us a ticket and we can assist!
Read more by Kelly McElligott