Hello Steven,
As a start here is a query that will identify empty collections:
select collection_id, name from collection where collection_id not in
(select distinct collection_id from collection2item);
To my knowledge that should work on 1.4.2's database (was on 1.4.2 recently
enough).
Best regards,
Joseph
Joseph Greene
Research Repository Librarian
James Joyce Library
University College Dublin
(353 0)1 716 7398
joseph.gre...@ucd.ie
http://researchrepository.ucd.ie
Message: 2
Date: Fri, 30 Jan 2015 09:26:41 +0000 (GMT)
From: Steven Hayles <s...@leicester.ac.uk>
Subject: [Dspace-tech] Best approach to bulk delete empty collections
(DSpace 4.2)
To: dspace-tech@lists.sourceforge.net
Message-ID: <pine.lnx.4.64.1501300917030.2...@rootmail.cc.le.ac.uk>
Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed
Hi
We have a DSpace 4.2 instance with many empty collections. What's the best
approach to finding and deleting them?
Thanks
Steven Hayles
Systems Analyst
IT Services, University of Leicester,
Propsect House, 94 Regent Rd, Leicester, LE1 7DA, UK
T: +44 (0)116 229 7950
E: s...@le.ac.uk
The Queen's Anniversary Prizes 1994, 2002 & 2013 THE Awards Winners
2007-2013
Elite without being elitist
Follow us on Twitter http://twitter.com/uniofleicester or visit our Facebook
page https://facebook.com/UniofLeicester
------------------------------------------------------------------------------
Dive into the World of Parallel Programming. The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net/
_______________________________________________
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
