Hi Euler,
try this query. I haven't tested it much, but it should give you the idea
how this works in DSpace 5. This reminds me we should also update the
ER-diagram in documentation.
SELECT count(1)FROM bundle2bitstreamINNER JOIN metadatavalue
ON bitstream_id = resource_id
WHERE resource_type_id=1
AND metadata_field_id=(SELECT metadata_field_id FROM
metadatafieldregistry WHERE metadata_schema_id=(SELECT
metadata_schema_id FROM metadataschemaregistry WHERE short_id='dc')
AND element='title' AND qualifier IS NULL)
AND text_value='ORIGINAL'
Regards,
~~helix84
Compulsory reading: DSpace Mailing List Etiquette
https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
------------------------------------------------------------------------------
New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
GigeNET is offering a free month of service with a new server in Ashburn.
Choose from 2 high performing configs, both with 100TB of bandwidth.
Higher redundancy.Lower latency.Increased capacity.Completely compliant.
http://p.sf.net/sfu/gigenet
_______________________________________________
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
