<!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 8483 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 4<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. Re: Staff interface redesign is ready to be tested (Cab Vinton)<br> 2. Re: How can I improve this report? (Tomas Cohen Arazi)<br><br><br>----------------------------------------------------------------------<br><br>Message: 1<br>Date: Sat, 2 Jul 2022 08:06:33 -0400<br>From: Cab Vinton <bibliwho@gmail.com><br>To: koha-devel <koha-devel@lists.koha-community.org><br>Subject: Re: [Koha-devel] Staff interface redesign is ready to be<br> tested<br>Message-ID:<br> <CABW43UTnQ2tszfG4zEuZhn1jpsR7AKJd9mt7J8iA6PuZdSf7nQ@mail.gmail.com><br>Content-Type: text/plain; charset="UTF-8"<br><br>There was also a demo install on the BibLibre website a few months back.<br><br>Perhaps it's still current & someone from the redesign team can share<br>the credentials?<br><br>All best,<br><br>Cab Vinton, Director<br>Plaistow Public Library<br>Plaistow, NH<br><br><br>------------------------------<br><br>Message: 2<br>Date: Sat, 2 Jul 2022 11:03:44 -0300<br>From: Tomas Cohen Arazi <tomascohen@gmail.com><br>To: Doug Kingston <dpk@randomnotes.org><br>Cc: koha-devel <koha-devel@lists.koha-community.org><br>Subject: Re: [Koha-devel] How can I improve this report?<br>Message-ID:<br> <CABZfb=UCdFcAEcUxAXAtgGxKin0x4KgfjzKz_+d5J38VxkDEFA@mail.gmail.com><br>Content-Type: text/plain; charset="utf-8"<br><br>I think you can improve it by doing a LEFT JOIN between the two tables<br>instead of the IN comparison.<br><br>That way you will find those without matching authorities when they<br>auth_header counterpart is NULL.<br><br>If you want to go precise, you should also add 100$9 vs authid to the game.<br><br>Good luck!<br><br>El sáb, 2 jul 2022 10:51, Doug Kingston <dpk@randomnotes.org> escribió:<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<br>> through every authority record for every biblio (O(Nbibs * Mauths), which<br>> is pretty bad). I suspect we can do better by trolling Auths once to<br>> create a set and then compare Bib authors against it. How can we do this?<br>><br>> -Doug-<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>-------------- next part --------------<br>An HTML attachment was scrubbed...<br>URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20220702/4a61f388/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 4<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>