[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[EP-tech] DB search for users who changed an eprint



Hi again,
A quick email to thank Matt Brady for his help pointing me in the right direction; all reports were provided successfully.

Karl.

On 15 Jan 2019, at 3:40 pm, Karl Goetz via Eprints-tech <eprints-tech at ecs.soton.ac.uk<mailto:eprints-tech at ecs.soton.ac.uk>> wrote:

Hi,
I have been asked to find out the staff who deposited (and or edited) a number of eprints last year. So far I haven?t been able to find a query to ask 'user who deposited a file??. I don't see a user specified in 'history', 'file' or 'documents' tables. 'history' has an 'actor' text field but it doesn't include the information i need. 'eprint' only includes the current revision.

Will I be able to query the information I need from within eprints DB or will I have to script up a query over the objects.xml files?

Thanks,
Karl.

--
Karl Goetz,  Senior Library Officer (Library Systems)
University of Tasmania, Private Bag 25, Hobart 7001
Available Tuesday, Wednesday, Thursday



University of Tasmania Electronic Communications Policy (December, 2014).
This email is confidential, and is for the intended recipient only. Access, disclosure, copying, distribution, or reliance on any of it by anyone outside the intended recipient organisation is prohibited and may be a criminal offence. Please delete if obtained in error and email confirmation to the sender. The views expressed in this email are not necessarily the views of the University of Tasmania, unless clearly intended otherwise.

*** Options: http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
*** Archive: https://emea01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.eprints.org%2Ftech.php%2F&amp;data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C904f44fa695a4be4a4b908d67b4041b1%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=o1YD%2FpqYFea79IfFWHcYLoBBA6Vk8mpM14zhh5j6hfU%3D&amp;reserved=0
*** EPrints community wiki: https://emea01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwiki.eprints.org%2F&amp;data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C904f44fa695a4be4a4b908d67b4041b1%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=8Gth1ZQ06siS5RmaHeEM72GgZlRW9ePRVVPCaYoCL0w%3D&amp;reserved=0
*** EPrints developers Forum: https://emea01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fforum.eprints.org%2F&amp;data=01%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C904f44fa695a4be4a4b908d67b4041b1%7C4a5378f929f44d3ebe89669d03ada9d8%7C1&amp;sdata=12Un%2FBcUkjXZEKmgOkSKJVCuLzslGfAxpwzvFgMdY9Y%3D&amp;reserved=0

--
Karl Goetz,  Senior Library Officer (Library Systems)
University of Tasmania, Private Bag 25, Hobart 7001
Available Tuesday, Wednesday, Thursday

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.ecs.soton.ac.uk/pipermail/eprints-tech/attachments/20190115/470e05b6/attachment-0001.html