Is it possible to get a count of the number of items archived in a
particular month?
I've been using the following:
SELECT COUNT(*) FROM item WHERE last_modified >= '2013-04-01 00:00:00' AND
last_modified < '2013-05-01 00:00:00' AND owning_collection = 22;
... but I don't think this is giving me what I need. Presumably
'last_modified' gets updated whenever anything happens to an item. Where
does the issue date of the record live?
Sean
--
------------------------------------------------------------------------------
Introducing AppDynamics Lite, a free troubleshooting tool for Java/.NET
Get 100% visibility into your production application - at no cost.
Code-level diagnostics for performance bottlenecks with <2% overhead
Download for free and get started troubleshooting in minutes.
http://p.sf.net/sfu/appdyn_d2d_ap1
_______________________________________________
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
