[Koha] Koha 16.05 - SQL Report on Koha Control Numbers - Finding blank 001s

Paul A paul.a at navalmarinearchive.com
Thu Feb 9 05:54:17 NZDT 2017

On 2/8/2017 11:13 AM, Craig Butosi wrote:
> Hi all,
> Koha 16.05 o Ubuntu 14.04 LTS
> Package install
> Would a kind soul help me with a basic SQL report which compiles a list of all bibliographic records that have a blank 001, but which have a biblionumber? Columns selected for the report = biblionumber, title, author.
> I have tried a number of queries but can't seem to get the syntax correct.

We have one that just gives you "clickable links" to allow editing the 

SELECT GROUP_CONCAT('<a target="_blank" href=\"/
AS BibNums,
EXTRACTVALUE(marcxml,'//controlfield[@tag="001"]') AS Id FROM biblioitems
GROUP BY Id HAVING count(Id) = 0;

Best -- Paul

More information about the Koha mailing list