Hi Sean, where i can find owningColl number for collections and Communities?: /solr/statistics/select?q=type:0+*owningColl:9* +isBot:false+time:[2017-06-01T00:00:00Z+TO+2017-07-01T00:00:00Z]&fq=-(bundleName:[*+TO+*]-bundleName:ORIGINAL)&indent=on&rows=0 Thanks,
Karol czwartek, 20 stycznia 2022 o 07:56:55 UTC+1 [email protected] napisał(a): > Hi Bravismore > > I can tell you what I do, though I'm no expert in this. Also, this is on > DSpace 6.3. > > 1. Items added last month & 2. Items added in a given year (between given > dates) > Query the postgres db directly using psql: > SELECT cm.community_id, substring(mv.text_value,1,7) AS year_month, > count(*) AS num_items_added > FROM metadatavalue mv, item it, collection co, community cm, > community2collection c2c > WHERE mv.dspace_object_id = it.uuid > AND it.owning_collection = co.uuid > AND co.uuid = c2c.collection_id > AND c2c.community_id = cm.uuid > AND mv.metadata_field_id = 11 > AND it.in_archive AND text_value >= '2019-09' > AND text_value < '2019-10' GROUP BY 1, 2 ORDER BY 1; > > 3. Total Items in repository > I add up the item totals for each community displayed in the UI. You'll > need this in your config file: webui.strengths.show = true > > 4. Item views in the past month & 5. Item views in a given year (between > given dates) > This is a useful post on using solr: > https://groups.google.com/g/dspace-tech/c/wudFqZMSF-Y > and these are the solr queries that I use: > - downloads: > > /solr/statistics/select?q=type:0+owningColl:9+isBot:false+time:[2017-06-01T00:00:00Z+TO+2017-07-01T00:00:00Z]&fq=-(bundleName:[*+TO+*]-bundleName:ORIGINAL)&indent=on&rows=0 > - visits: > > /solr/statistics/select?q=type:2+owningColl:9+isBot:false+time:[2017-06-01T00:00:00Z+TO+2017-07-01T00:00:00Z]&indent=on&rows=0 > > 6. Total item views > I've never considered this, but I should think a variation on the SQL > above should work. > > Sean > > Dspace repository reports >> <http://groups.google.com/group/dspace-community/t/1ac6ed809a4dea63?utm_source=digest&utm_medium=email> >> >> Bravismore Mumanyi <[email protected]>: Jan 19 02:51PM +0200 >> > >> Dear Dspace User Community >> >> Any pointers on how we can generate the reports below. >> >> > 1. Items added last month >> 2. Items added in a given year (between given dates) >> 3. Total Items in repository >> 4. Item views in the past month >> 5. Item views in a given year (between given dates) >> 6. Total item views >> > >> >> Are these SQL queries, solr-based queries? If anyone is willing to share >> the procedure followed. >> >> Your guidance would be appreciated >> >> Regards >> > Back to top <#m_-603217683983670590_m_2141145938362024295_digest_top> >> You received this digest because you're subscribed to updates for this >> group. You can change your settings on the group membership page >> <https://groups.google.com/forum/?utm_source=digest&utm_medium=email#!forum/dspace-community/join> >> . >> To unsubscribe from this group and stop receiving emails from it send an >> email to [email protected]. >> > -- All messages to this mailing list should adhere to the Code of Conduct: https://www.lyrasis.org/about/Pages/Code-of-Conduct.aspx --- 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/67c369fe-ef9a-46fa-b307-8e2b320b86c5n%40googlegroups.com.
