Thank you very much, it worked. On Thursday, August 29, 2024 at 2:16:52 AM UTC+3 Fitchett, Deborah wrote:
> You could query the database if you’re up for some fun with SQL and > regular expressions. > > > > We do queries like: > > select count(*) from item,metadatavalue where item.owning_collection = > 'ec3f9cb5-3508-469a-ad29-77f0d15374f8' and item.uuid = > metadatavalue.dspace_object_id and metadata_field_id = 11 and text_value > like '2023%'; > > to get the number of items added to a given collection in a given year > (based on the dc.date.accessioned). > > > > The dc.description.provenance should have a “Submitted by Joe Bloggs ( > [email protected]) on 2024-08-28T02:16:25Z [etc etc]” line so breaking > this out into the information you want should be doable, albeit a bit > fiddly. > > > > Deborah > > > > *From:* [email protected] <[email protected]> *On Behalf > Of *Sylvester Chikoti > *Sent:* Wednesday, August 28, 2024 7:22 PM > *To:* DSpace Technical Support <[email protected]> > *Subject:* [dspace-tech] Tracking Data entry logs > > > > You don't often get email from [email protected]. Learn why this is > important <https://aka.ms/LearnAboutSenderIdentification> > > > > *Caution:* This email originated from outside our organisation. Do not > click links or open attachments unless you recognize the sender and know > the content is safe. > > > > Hi all, I am struggling to know how may items have been submitted into > dspace and by who for a certain period of time. How can i achieve this in > dspace 7.6? > > > > Thanks > > -- > 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 [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/dspace-tech/2e4e3c3a-cc8d-4d31-8a52-c8f9c49c7e47n%40googlegroups.com > > <https://groups.google.com/d/msgid/dspace-tech/2e4e3c3a-cc8d-4d31-8a52-c8f9c49c7e47n%40googlegroups.com?utm_medium=email&utm_source=footer> > . > > ------------------------------ > > "The contents of this e-mail (including any attachments) may be > confidential and/or subject to copyright. Any unauthorised use, > distribution, or copying of the contents is expressly prohibited. If you > have received this e-mail in error, please advise the sender by return > e-mail or telephone and then delete this e-mail together with all > attachments from your system." > -- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-tech/a7f3384f-1faf-4496-8e76-039c961a381an%40googlegroups.com.
