How to fulfill request for statistics?

[Carolyn Sullivan]

So I recently received a request for these statistics from one of the managers at my institution.  For our Theses Collection, they would like me to find:

- # of submissions per year/ per day and week (on average) from 2021-2023
- # of processed items per year from 2021-2023 (the reason why I asked is that some students may choose a different collection so it would be different from the # of submissions)

My question:

(1) Solr statistics only tracks views and downloads, correct?  So I wouldn't be able to find this information through that interface?

(2) Where would I find this information then?  I don't see the submission date preserved ANYWHERE in the metadata of accepted items.  Does this information even EXIST?

Thanks,

Carolyn.

[C S]

Additional question:  I also noticed that the documentation states that workflow statistics used to be available in versions up to 6.x (not quite the same thing as submissions, but oh well), but that it isn't available under 7.x +.  I tried querying http://localhost:1234/solr/statistics/select?facet=true&fq=owningColl%3Ab464ca75-3f7c-44b8-98e4-86090ce290c6&fq=statistics_type%3Aworkflow&indent=true&q.op=OR&q=*%3A*&wt=json under the statistics core anyways and got results though?  So is the workflow statistics described here a different core than what I expected? https://wiki.lyrasis.org/display/DSDOC7x/SOLR+Statistics#SOLRStatistics-WorkflowEventStatistics

--
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 Technical Support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dspace-tech...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/dspace-tech/0176407a-9843-42a1-a824-083d802a1b8an%40googlegroups.com.

[DSpace Technical Support]

Hi Carolyn,

I don't believe Workflow Event statistics are fully functional in DSpace 7.x.  I'd *love* them to be functional, but we've yet to find a volunteer to tackle those tickets: https://github.com/DSpace/DSpace/issues/2851 and https://github.com/DSpace/dspace-angular/issues/785

With regards to how to gather this data in the meantime, you might consider using SQL queries against the database by using the "dc.date.accessioned" metadata field (the date that the Item was added to the system via the Submission process).  I don't have any "pre-baked" SQL queries to find how many submissions occurred during a specific date range, but it's possible someone else on this list has done this sort of statistical gathering at the database level before.   It should be possible.

Hopefully that provides a few possible hints for next steps.

Tim