On 7 March 2016 at 13:35, Hilton Gibson <hilton.gib...@gmail.com> wrote:
> DSpace 5.4, XMLUI > > Is it possible to extract the total number of items submitted per month > per annum for the entire repository? I collect SQL queries here: > http://wiki.lib.sun.ac.za/index.php/SUNScholar/SQL_Tips > > But the one I have does not work with DSpace 5.4. > Does anyone have an updated version that works with DSpace 5.4? > Hi Hilton This is what I'm using: SELECT cm.community_id, co.collection_id, substring(mv.text_value,1,7) AS year_month, count(*) AS num_items_added FROM metadatavalue mv, item it, collection co, community cm, community2collection c2c WHERE mv.resource_id = it.item_id AND it.owning_collection = co.collection_id AND co.collection_id = c2c.collection_id AND c2c.community_id = cm.community_id AND mv.metadata_field_id = 11 AND it.in_archive AND text_value >= '2016-02' AND text_value < '2016-03' GROUP BY 1, 2, 3 ORDER BY 2; Not quite what you're after as I have to run that for each month. Sean -- -- You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group. To unsubscribe from this group and stop receiving emails from it, send an email to dspace-tech+unsubscr...@googlegroups.com. To post to this group, send email to dspace-tech@googlegroups.com. Visit this group at https://groups.google.com/group/dspace-tech. For more options, visit https://groups.google.com/d/optout.