Re: [Dspace-tech] Total item count? (DSpace 1.7.2, XMLUI)

2013-08-27 Thread helix84 
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)

2013-08-27 Thread helix84 
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