You will have to join the Item table to the metadatavalue table where
metadata_field_id = 99 (where 99 = date.accessioned). Do your date
specification on date.accessioned since that's the date/timestamp the Item was
added to the repository.
Good luck,
Sue
------------------------------------------------------------------------
Sue Thornton
Office: (757) 224-4130
Mobile: (757) 506-9903
[email protected]<mailto:[email protected]>
From: Sean Carte [mailto:[email protected]]
Sent: Monday, May 06, 2013 5:57 AM
To: dspace-tech
Subject: [Dspace-tech] Number of items archived each month
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
--
------------------------------------------------------------------------------
AlienVault Unified Security Management (USM) platform delivers complete
security visibility with the essential security capabilities. Easily and
efficiently configure, manage, and operate all of your security controls
from a single console and one unified framework. Download a free trial.
http://p.sf.net/sfu/alienvault_d2d
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
