Hallo Stefanie,
you may query the database.
Here is a query which will give you all the bitstreams of the items
which are in_archive are not of internal format. Derived bitstreams like
extracted text, thumbnail and licenses are excluded:
select bf.mimetype, count (b.bitstream_format_id) as Anzahl,
bf.bitstream_format_id from bitstreamformatregistry bf , bitstream b
where b.bitstream_format_id=bf.bitstream_format_id and bf.internal=false
and b.bitstream_id in (select bitstream_id from bundle2bitstream where
bundle2bitstream.bundle_id in (select resource_id from metadatavalue
where text_value='ORIGINAL' and metadata_field_id=64 and
resource_type_id=1 and resource_id in (select bundle_id from item2bundle
where item_id in (select item_id from item where in_archive=true and
owning_collection in (select collection_id from community2collection
where community_id=YOUR_COMMUNITY_ID))))) group by bf.mimetype,
bf.bitstream_format_id order by bf.mimetype;
Replace the YOUR_COMMUNITY_ID with the real one.
You'll get something like:
mimetype | anzahl | bitstream_format_id
-------------------------------+--------+---------------------
application/pdf | 50 | 3
application/postscript | 2 | 24
application/vnd.ms-powerpoint | 4 | 8
video/quicktime | 1 | 25
(4 rows)
Hoffe das hilft
Claudia Jürgen
Am 11.04.2017 um 10:14 schrieb Stefanie Behnke:
Dear all,
what is the easiest way to get the number of all bitstreams in a community? The
number of items in one community is 4460, and I now want to know how many
bitstreams are there, if possible, ordered by mimetype.
Thanking you in advance
Stefanie
--
Claudia Juergen
Eldorado
Technische Universität Dortmund
Universitätsbibliothek
Vogelpothsweg 76
44227 Dortmund
Tel.: +49 231-755 40 43
Fax: +49 231-755 40 32
[email protected]
www.ub.tu-dortmund.de
Wichtiger Hinweis: Die Information in dieser E-Mail ist vertraulich. Sie ist
ausschließlich für den Adressaten bestimmt. Sollten Sie nicht der für diese
E-Mail bestimmte Adressat sein, unterrichten Sie bitte den Absender und
vernichten Sie diese Mail. Vielen Dank.
Unbeschadet der Korrespondenz per E-Mail, sind unsere Erklärungen
ausschließlich final rechtsverbindlich, wenn sie in herkömmlicher Schriftform
(mit eigenhändiger Unterschrift) oder durch Übermittlung eines solchen
Schriftstücks per Telefax erfolgen.
Important note: The information included in this e-mail is confidential. It is
solely intended for the recipient. If you are not the intended recipient of
this e-mail please contact the sender and delete this message. Thank you.
Without prejudice of e-mail correspondence, our statements are only legally
binding when they are made in the conventional written form (with personal
signature) or when such documents are sent by fax.
--
You received this message because you are subscribed to the Google Groups "DSpace
Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/dspace-community.
For more options, visit https://groups.google.com/d/optout.
