<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html><head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body>A new request with request id 8790 has been created by koha-devel-request@lists.koha-community.org. Short info on the request is : <br><br>Title : Koha-devel Digest, Vol 200, Issue 3<br>Category : <br>Description : <div>Send Koha-devel mailing list submissions to<br> koha-devel@lists.koha-community.org<br><br>To subscribe or unsubscribe via the World Wide Web, visit<br> https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel<br>or, via email, send a message with subject or body 'help' to<br> koha-devel-request@lists.koha-community.org<br><br>You can reach the person managing the list at<br> koha-devel-owner@lists.koha-community.org<br><br>When replying, please edit your Subject line so it is more specific<br>than "Re: Contents of Koha-devel digest..."<br><br><br>Today's Topics:<br><br> 1. Staff interface redesign is ready to be tested (Julian Maurice)<br> 2. Re: Staff interface redesign is ready to be tested<br> (Hugo Agud Andreu)<br> 3. How can I improve this report? (Doug Kingston)<br><br><br>----------------------------------------------------------------------<br><br>Message: 1<br>Date: Fri, 1 Jul 2022 15:12:25 +0200<br>From: Julian Maurice <julian.maurice@biblibre.com><br>To: koha-devel <koha-devel@lists.koha-community.org><br>Subject: [Koha-devel] Staff interface redesign is ready to be tested<br>Message-ID: <aac4e723-7fac-b02d-dba7-89b720eaedf3@biblibre.com><br>Content-Type: text/plain; charset=UTF-8; format=flowed<br><br>Hi all,<br><br>After 5 months of work, the new staff interface is finally there!<br><br>As it changes a lot of pages, we will need a lot of eyes to hunt down <br>bugs. So if you want to help, you can go to bug 30952 right now and <br>start testing!<br><br>https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30952<br><br>-- <br>Julian Maurice<br>BibLibre<br><br><br>------------------------------<br><br>Message: 2<br>Date: Fri, 1 Jul 2022 13:39:30 +0000<br>From: Hugo Agud Andreu <hagud@orex.es><br>To: Julian Maurice <julian.maurice@biblibre.com>, koha-devel<br> <koha-devel@lists.koha-community.org><br>Subject: Re: [Koha-devel] Staff interface redesign is ready to be<br> tested<br>Message-ID:<br> <PAXPR05MB9050E267BDBCD7550B78FDBCBDBD9@PAXPR05MB9050.eurprd05.prod.outlook.com><br> <br>Content-Type: text/plain; charset="utf-8"<br><br>Perhaps it is a good idea set up a fixed sandbox as the erm bug?<br><br><br><br>Obtener Outlook para iOS<https://aka.ms/o0ukef><br>________________________________<br>De: Koha-devel <koha-devel-bounces@lists.koha-community.org> en nombre de Julian Maurice <julian.maurice@biblibre.com><br>Enviado: Friday, July 1, 2022 3:12:25 PM<br>Para: koha-devel <koha-devel@lists.koha-community.org><br>Asunto: [Koha-devel] Staff interface redesign is ready to be tested<br><br>Hi all,<br><br>After 5 months of work, the new staff interface is finally there!<br><br>As it changes a lot of pages, we will need a lot of eyes to hunt down<br>bugs. So if you want to help, you can go to bug 30952 right now and<br>start testing!<br><br>https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30952<br><br>--<br>Julian Maurice<br>BibLibre<br>_______________________________________________<br>Koha-devel mailing list<br>Koha-devel@lists.koha-community.org<br>https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel<br>website : https://www.koha-community.org/<br>git : https://git.koha-community.org/<br>bugs : https://bugs.koha-community.org/<br>-------------- next part --------------<br>An HTML attachment was scrubbed...<br>URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20220701/3dbd530b/attachment-0001.htm><br><br>------------------------------<br><br>Message: 3<br>Date: Fri, 1 Jul 2022 12:39:14 -0700<br>From: Doug Kingston <dpk@randomnotes.org><br>To: koha-devel <koha-devel@lists.koha-community.org><br>Subject: [Koha-devel] How can I improve this report?<br>Message-ID:<br> <CAGPaoUs_u349c21obVJNAwNX7+E3rB9b8DFRTHmog+pmKOaNig@mail.gmail.com><br>Content-Type: text/plain; charset="utf-8"<br><br>Report: Authors not in Authorities<br><br>SELECT DISTINCT(author) AS heading FROM biblio WHERE author NOT IN (SELECT<br>ExtractValue(marcxml,'//datafield[@tag="100"]/subfield[@code="a"]') AS<br>heading FROM auth_header WHERE authtypecode='PERSO_NAME')ORDER BY heading<br><br>I am not a SQL expert, but I believe this is doing an unkeyed troll through<br>every authority record for every biblio (O(Nbibs * Mauths), which is pretty<br>bad). I suspect we can do better by trolling Auths once to create a set<br>and then compare Bib authors against it. How can we do this?<br><br>-Doug-<br>-------------- next part --------------<br>An HTML attachment was scrubbed...<br>URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20220701/a529efa1/attachment-0001.htm><br><br>------------------------------<br><br>Subject: Digest Footer<br><br>_______________________________________________<br>Koha-devel mailing list<br>Koha-devel@lists.koha-community.org<br>https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel<br>website : https://www.koha-community.org/<br>git : https://git.koha-community.org/<br>bugs : https://bugs.koha-community.org/<br><br><br>------------------------------<br><br>End of Koha-devel Digest, Vol 200, Issue 3<br>******************************************<br></div><br><br>NOTE: You are receiving this mail because, the Requester/Technician wanted you to get notified on this request creation.<br></body></html>