[Koha] SQL Report - Authorities. List duplicate values based on 010$a

[David Nind]

Hi Craig.

I'm not that great at reports, but you might be able to find something in
the SQL reports library that could help:
https://wiki.koha-community.org/wiki/SQL_Reports_Library


David Nind | david.nind at gmail.com
PO Box 12367, Thorndon, Wellington, New Zealand 6144
m. +64 21 0537 847


On Sun, 12 May 2019 at 05:46, Craig Butosi <cbutosi at gmail.com> wrote:

> Hi all,
>
> Koha 18.11 on Ubunti 16.04
>
> May I request help for an SQL report that does the following, please:
>
> Identify and list by authid and main heading all authority records that
> have a tag 010$a with duplicate values?
>
> I am attempting to located all authority records that can be merged (or
> de-duped via merge).
>
> Many thanks!
>
> Craig Butosi, MA, MLIS, B Mus (Hons)
> Library: library.craigbutosi.ca
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>