[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

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

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