I wanted to double-check: given DSpace 4.0 with PostgreSQL, should this not give me the number of Items submitted in the year 2014?
SELECT COUNT(*) FROM metadatavalue
WHERE metadata_field_id =
(SELECT metadata_field_id FROM metadatafieldregistry
WHERE metadata_schema_id = 1
AND element = 'date'
AND qualifier = 'accessioned')
AND to_date(text_value,'YYYY-MM-DD') >= '2014-01-01'
AND to_date(text_value,'YYYY-MM-DD') < '2015-01-01';
--
Mark H. Wood
Lead Technology Analyst
University Library
Indiana University - Purdue University Indianapolis
755 W. Michigan Street
Indianapolis, IN 46202
317-274-0749
www.ulib.iupui.edu
signature.asc
Description: Digital signature
------------------------------------------------------------------------------ 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
