The following will show the last 30 changed biblio records and is ready if you wish to add more conditions on other related tables. It can also be used as a coverflow datasource. SELECT b.biblionumber, i.Barcode, SUBSTRING_INDEX(m.isbn, ' ', 1) AS isbn, b.title, c.imagenumber AS localcover FROM items i LEFT JOIN biblioitems m USING (biblioitemnumber) LEFT JOIN biblio b ON (i.biblionumber=b.biblionumber) LEFT JOIN cover_images c ON (i.biblionumber=c.biblionumber) LEFT JOIN biblio_metadata mt on mt.biblionumber = b.biblionumber GROUP BY biblionumber LIMIT 30 order by b.timestamp desc Kind regards, Manos Petridis Στις Τρί 18 Ιαν 2022 στις 12:08 π.μ., ο/η Charles Kelley < cmkelleymls@gmail.com> έγραψε:
Hi, all!
Is it possible to get a SQL report of recently edited records? I looked on the Koha wiki, but I didn't see one.
Thanks, all!
--
よろしくお願いします。
-- 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]
mnogojazyk@aol.com [h] cmkelleymls@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