Hello Lewatle,
you may query the database, this is our query for accessioned (5.4) but should
work:
SELECT to_char(date_trunc('year', t1.ts), 'YYYY') AS year, count(*) FROM
(SELECT to_timestamp(text_value, 'YYYY-MM-DD') AS ts FROM metadatavalue WHERE
metadata_field_id = 12) t1 GROUP BY date_trunc('year', t1.ts) order by year;
Just replace the metadata_field_id with your correct id.
Hope this helps
Claudia Jürgen
Am 07.02.2018 um 14:49 schrieb Lewatle Johannes Phaladi:
Dear All,
I am using DSpace 6.2 on both xmlui and jspui interface, I would like to
know how can I see total number of items submitted in the year 2016 and
2017.
When I check *dc. date. accessioned metadata *field might assist, I am
using out of box DSpace interface which doesn't have *dc. date.
accessioned *under browse, how can I see number of items submitted as per
the year the item was submitted, using any method that will help.
Regards,
Lewatle
--
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
claudia.juer...@tu-dortmund.de<mailto:claudia.juer...@tu-dortmund.de>
www.ub.tu-dortmund.de<http://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
Technical Support" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to dspace-tech+unsubscr...@googlegroups.com.
To post to this group, send email to dspace-tech@googlegroups.com.
Visit this group at https://groups.google.com/group/dspace-tech.
For more options, visit https://groups.google.com/d/optout.
