Re: [dspace-tech] Re: Query for harvested items

[José Geraldo]

Hi,

You can use the tables harvested_collection and harvested_item, group by
the column last_harvested.

https://wiki.duraspace.org/display/DSDOC6x/Storage+Layer?preview=/68069687/78157937/dspace6.png


Em seg, 23 de set de 2019 às 20:56, euler  escreveu:

> Need help anyone? I'm pretty sure I'm not the only who would like to know
> this kind of statistics and I'm also sure that a lot of repositories out
> there that have some of their contents harvested from other OAI content
> providers.
>
> Thanks in advance.
>
> On Wednesday, September 18, 2019 at 3:48:14 PM UTC+8, euler wrote:
>>
>> Hi Everyone,
>>
>> I am working on a repository (DSpace 6.3) that harvests from 2 different
>> dspace repositories. I would like to ask if how can I query using either
>> solr or sql the number of harvested items for each oai provider. It would
>> also be nice if I can set the date range eg the number of items harvested
>> monthly from oai server1 from January 1, 2019 to August 31, 2019. By the
>> way, the harvesting server is only harvesting metadata and references to
>> bitstreams.
>>
>> Thanks in advance!
>>
>> euler
>>
> --
> All messages to this mailing list should adhere to the DuraSpace Code of
> Conduct: https://duraspace.org/about/policies/code-of-conduct/
> ---
> 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 view this discussion on the web visit
> https://groups.google.com/d/msgid/dspace-tech/e4f2cfc2-f82e-42cc-b227-74ce8c9d4334%40googlegroups.com
> 
> .
>


-- 
At.te,

José Geraldo

-- 
All messages to this mailing list should adhere to the DuraSpace Code of 
Conduct: https://duraspace.org/about/policies/code-of-conduct/
--- 
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 view this discussion on the web visit 
https://groups.google.com/d/msgid/dspace-tech/CANP4ikS5Tp5eWntNR6O6fnherqgtbj1iD0hmZqAbg7z4qPju8g%40mail.gmail.com.

[dspace-tech] Re: Query for harvested items

[euler]

Need help anyone? I'm pretty sure I'm not the only who would like to know 
this kind of statistics and I'm also sure that a lot of repositories out 
there that have some of their contents harvested from other OAI content 
providers.

Thanks in advance.

On Wednesday, September 18, 2019 at 3:48:14 PM UTC+8, euler wrote:
>
> Hi Everyone,
>
> I am working on a repository (DSpace 6.3) that harvests from 2 different 
> dspace repositories. I would like to ask if how can I query using either 
> solr or sql the number of harvested items for each oai provider. It would 
> also be nice if I can set the date range eg the number of items harvested 
> monthly from oai server1 from January 1, 2019 to August 31, 2019. By the 
> way, the harvesting server is only harvesting metadata and references to 
> bitstreams.
>
> Thanks in advance!
>
> euler
>

-- 
All messages to this mailing list should adhere to the DuraSpace Code of 
Conduct: https://duraspace.org/about/policies/code-of-conduct/
--- 
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 view this discussion on the web visit 
https://groups.google.com/d/msgid/dspace-tech/e4f2cfc2-f82e-42cc-b227-74ce8c9d4334%40googlegroups.com.