Hello, Raymund!
In a recent exchange, on 24 Mch. 2022 at 08:00 [JST], I read the
following from you through the Koha Discussion Group.
We did exactly the same thing. We decided to wipe all fines (not cocts of
> replacements) accrued since 14th December 2019. We had PTFS Europe (our
> support company) do this. They ran this little SQL:
>
>
SELECT accountlines_id, date, accounttype, payment_type, amountoutstanding
> FROM accountlines
> WHERE date > '2019-12-14'
> AND accounttype IN ('F','FU')
> AND amountoutstanding > 0
>
> The support analyst said: "This finds 5129 bills. If you are happy for
> these to be deleted, let me know".
>
> I did, and they were gone in an instant.
>
I'm curious: You didn't have to make a SQL statement like this:
UPDATE accountlines
> SET amountoutstanding = 0
> WHERE date > '2019-12-14' AND accounttype IN ('F', 'FU') AND
> amountoutstanding > 0;
>
Does the Koha report processor accept UPDATE clauses or do you know?
Of course, if you want for posterity a report of forgiven fines before
they are forgiven, you probably would want run the SELECT SQL statement
above.
--
よろしくお願いします。
-- Charles.
Charles Kelley, MLS
PSC 704 Box 1029
APO AP 96338
Charles Kelley
Tsukimino 1-Chome 5-2
Tsukimino Gaadenia #210
Yamato-shi, Kanagawa-ken
〒242-0002 JAPAN
+1-301-741-7122 [US cell]
+81-80-4356-2178 [JPN cell]
mnogoja...@aol.com [h]
cmkelley...@gmail.com [p]
linkedin.com/in/cmkelleymls <http://www.linkedin.com/in/cmkelleymls>
Meeting Your Information Needs. Virtually.
_______________________________________________
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
