Hi,
it is very helpfully - thanks:) Best regards,
Karol
niedziela, 24 stycznia 2021 o 10:58:02 UTC+1 Jose Miguel Santana napisał(a):
> Hi,
>
> We extract that data directly from the PostgreSQL database, using this SQL
> query:
>
> select split_part(split_part(met1.text_value,'(',2),')',1) as user,
> split_part(split_part(met1.text_value,') on ',2),'-',1)as year,
> count(*) as Publications
> from metadatavalue met1
> where text_value like 'Submitted by%'
> and met1.metadata_field_id=(select metadata_field_id from
> metadatafieldregistry m
> where element='description' and qualifier='provenance' and
> metadata_schema_id=1)
> and text_value not like 'null'
> group by split_part(split_part(met1.text_value,'(',2),')',1),
> split_part(split_part(met1.text_value,') on ',2),'-',1)
> order by year desc
>
> You can automate the recovery of that data using a script. We use the open
> source version of Metabase (https://www.metabase.com/) to query the
> DSpace PostgreSQL database, extract the data and display it graphically or
> as tables.
>
>
> El sábado, 23 de enero de 2021 a las 17:13:42 UTC, [email protected]
> escribió:
>
>> Hi,
>>
>> how can i check how many items was submited by specific user in spefic
>> year? I found dc.description.provenance, where is stored data about user
>> and year when item was submited, but i don't know how can I automating it?
>>
>> Karol
>>
>
--
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 Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/dspace-community/a663184a-c057-4e6d-93ca-be6c17ae2319n%40googlegroups.com.
