A new request with request id 8483 has been created by koha-devel-request@lists.koha-community.org. Short info on the request is :
Title : Koha-devel Digest, Vol 200, Issue 4
Category :
Description : Send Koha-devel mailing list submissions to
koha-devel@lists.koha-community.org
To subscribe or unsubscribe via the World Wide Web, visit
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
or, via email, send a message with subject or body 'help' to
koha-devel-request@lists.koha-community.org
You can reach the person managing the list at
koha-devel-owner@lists.koha-community.org
When replying, please edit your Subject line so it is more specific
than "Re: Contents of Koha-devel digest..."
Today's Topics:
1. Re: Staff interface redesign is ready to be tested (Cab Vinton)
2. Re: How can I improve this report? (Tomas Cohen Arazi)
----------------------------------------------------------------------
Message: 1
Date: Sat, 2 Jul 2022 08:06:33 -0400
From: Cab Vinton <bibliwho@gmail.com>
To: koha-devel <koha-devel@lists.koha-community.org>
Subject: Re: [Koha-devel] Staff interface redesign is ready to be
tested
Message-ID:
<CABW43UTnQ2tszfG4zEuZhn1jpsR7AKJd9mt7J8iA6PuZdSf7nQ@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
There was also a demo install on the BibLibre website a few months back.
Perhaps it's still current & someone from the redesign team can share
the credentials?
All best,
Cab Vinton, Director
Plaistow Public Library
Plaistow, NH
------------------------------
Message: 2
Date: Sat, 2 Jul 2022 11:03:44 -0300
From: Tomas Cohen Arazi <tomascohen@gmail.com>
To: Doug Kingston <dpk@randomnotes.org>
Cc: koha-devel <koha-devel@lists.koha-community.org>
Subject: Re: [Koha-devel] How can I improve this report?
Message-ID:
<CABZfb=UCdFcAEcUxAXAtgGxKin0x4KgfjzKz_+d5J38VxkDEFA@mail.gmail.com>
Content-Type: text/plain; charset="utf-8"
I think you can improve it by doing a LEFT JOIN between the two tables
instead of the IN comparison.
That way you will find those without matching authorities when they
auth_header counterpart is NULL.
If you want to go precise, you should also add 100$9 vs authid to the game.
Good luck!
El sáb, 2 jul 2022 10:51, Doug Kingston <dpk@randomnotes.org> escribió:
> Report: Authors not in Authorities
>
> SELECT DISTINCT(author) AS heading FROM biblio WHERE author NOT IN (SELECT
> ExtractValue(marcxml,'//datafield[@tag="100"]/subfield[@code="a"]') AS
> heading FROM auth_header WHERE authtypecode='PERSO_NAME')ORDER BY heading
>
> I am not a SQL expert, but I believe this is doing an unkeyed troll
> through every authority record for every biblio (O(Nbibs * Mauths), which
> is pretty bad). I suspect we can do better by trolling Auths once to
> create a set and then compare Bib authors against it. How can we do this?
>
> -Doug-
> _______________________________________________
> Koha-devel mailing list
> Koha-devel@lists.koha-community.org
> https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
> website : https://www.koha-community.org/
> git : https://git.koha-community.org/
> bugs : https://bugs.koha-community.org/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20220702/4a61f388/attachment-0001.htm>
------------------------------
Subject: Digest Footer
_______________________________________________
Koha-devel mailing list
Koha-devel@lists.koha-community.org
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
website : https://www.koha-community.org/
git : https://git.koha-community.org/
bugs : https://bugs.koha-community.org/
------------------------------
End of Koha-devel Digest, Vol 200, Issue 4
******************************************
NOTE: You are receiving this mail because, the Requester/Technician wanted you to get notified on this request creation.