On 16 May 2013 00:07, Thornton, Susan M. (LARC-B702)[LITES] <
[email protected]> wrote:
> SELECT ****
>
> cm.name AS community_name****
>
> , co.name AS collection_name ****
>
> , substring(mv.text_value,1,7) AS year_month ****
>
> , count(*) AS num_items_added ****
>
> FROM metadatavalue mv****
>
> , item it****
>
> , collection co****
>
> , community cm****
>
> , community2collection c2c****
>
> WHERE mv.item_id = it.item_id****
>
> AND it.owning_collection = co.collection_id****
>
> AND co.collection_id = c2c.collection_id****
>
> AND c2c.community_id = cm.community_id****
>
> AND mv.metadata_field_id = 11
> /* date.accessioned */****
>
> AND it.in_archive
> /* Make
> sure the Item has not been deleted or withdrawn */****
>
> AND text_value >= '2013-04' AND text_value < '2013-05' /*
> specify the starting date here in format yyyy-mm */****
>
> GROUP BY 1, 2, 3****
>
> ORDER BY 1, 2;
>
Perfect! Thank you, Sue!
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
