[Dspace-tech] Total item count? (DSpace 1.7.2, XMLUI)
I'm running DSpace 1.7.2 with XMLUI and need to count the total number of Items in the repository. I know JSPUI can (optionally) display community/collection counts, but is there an easy way to retrieve this number in XMLUI? I don't need to make the count a regular part of the interface, just to check the number periodically for our internal activity report. Thanks -- Nicholas Webb Digital Archivist Icahn School of Medicine at Mount Sinai Box 1102 - One Gustave L. Levy Place New York, NY 10029-6574 (o) 212-241-7239 (f) 212-241-7864 (e) nicholas.w...@mssm.edu -- Introducing Performance Central, a new site from SourceForge and AppDynamics. Performance Central is your source for news, insights, analysis and resources for efficient Application Performance Management. Visit us today! http://pubads.g.doubleclick.net/gampad/clk?id=48897511iu=/4140/ostg.clktrk ___ 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
Re: [Dspace-tech] Total item count? (DSpace 1.7.2, XMLUI)
Hi Nicholas, two ways: 1) using SQL (this is for Postgres): SELECT count(1) FROM item WHERE in_archive = 't'; 2) using Solr (run this from the DSpace machine or check [1] how to enable remote access to Solr): curl http://localhost:8080/solr/search/select/?q=*:*rows=0; In the output, the numFound attribute contains the number of items. [1] https://wiki.duraspace.org/display/DSPACE/Solr Regards, ~~helix84 Compulsory reading: DSpace Mailing List Etiquette https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette -- Introducing Performance Central, a new site from SourceForge and AppDynamics. Performance Central is your source for news, insights, analysis and resources for efficient Application Performance Management. Visit us today! http://pubads.g.doubleclick.net/gampad/clk?id=48897511iu=/4140/ostg.clktrk ___ 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
Re: [Dspace-tech] Total item count? (DSpace 1.7.2, XMLUI)
The correct Solr query to get the correct result count (same as using SQL) should be: curl http://localhost:8080/solr/search/select/?q=withdrawn:falserows=0; You can also display this number in your theme this way: xsl:variable name=total select=document('http://localhost:8080/solr/search/select/?q=dc.format:text+AND+withdrawn:falserows=0')/i18n:textxmlui.myrepo.count.total/i18n:textxsl:value-of select=$total/response/result[@numFound]/@numFound/ Regards, ~~helix84 Compulsory reading: DSpace Mailing List Etiquette https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette -- Introducing Performance Central, a new site from SourceForge and AppDynamics. Performance Central is your source for news, insights, analysis and resources for efficient Application Performance Management. Visit us today! http://pubads.g.doubleclick.net/gampad/clk?id=48897511iu=/4140/ostg.clktrk___ 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