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.