Re: [dspace-tech] find number of items submitted in year 2016

2018-02-07 Thread Terry Brady 
If you have the DSpace 6 REST API enabled, you can run a report to retrieve
this information.

Here is an example on demo.dspace.org pulling items from 2016, 2017, and
2018.

https://demo.dspace.org/rest/static/reports/query.html?query_field[]=dc.date.accessioned_op[]=matches_val[]=%5E201%5B678%5D.*[]==100=0=parentCollection%2Cmetadata=none_fields[]=dc.date.accessioned

On Wed, Feb 7, 2018 at 5:49 AM, Lewatle Johannes Phaladi  wrote:

> 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
>
> --
> 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.
>



-- 
Terry Brady
Applications Programmer Analyst
Georgetown University Library Information Technology
https://github.com/terrywbrady/info
425-298-5498 (Seattle, WA)

-- 
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.

Re: [dspace-tech] find number of items submitted in year 2016

2018-02-07 Thread Claudia Jürgen 

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), '') AS year, count(*) FROM 
(SELECT to_timestamp(text_value, '-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
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.

[dspace-tech] find number of items submitted in year 2016

2018-02-07 Thread 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  

-- 
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.