EPrints Technical Mailing List Archive

Message: #06279

< Previous (by date) | Next (by date) > | < Previous (in thread) | Next (in thread) > | Messages - Most Recent First | Threads - Most Recent First

Re: [EP-tech] Figuring out the highest EPrint ID?

Try the database:

mysql> SELECT MAX(eprintid) FROM eprint;

mysql> SELECT counter FROM counters WHERE counterid = 'eprintid';


There's probably a way to get this via an EPrints session too if you need that?






From: eprints-tech-bounces@ecs.soton.ac.uk [mailto:eprints-tech-bounces@ecs.soton.ac.uk] On Behalf Of Andrew Beeken
Sent: 15 February 2017 11:46
To: eprints-tech@ecs.soton.ac.uk
Subject: [EP-tech] Figuring out the highest EPrint ID?


Hello again!


New one here, related to a different project! So, I’m trying to find the HIGHEST EPrint ID that we have in our live system. I was doing this by taking the “Latest Additions” atom feed and looking at the topmost entry, however I have now realised this isn’t accurate as this could be representative of an item that has been sat in a work area for a number of weeks or even months. Is there an easy way, via endpoint or API access, that I could use to derive the highest number?



The University of Lincoln, located in the heart of the city of Lincoln, has established an international reputation based on high student satisfaction, excellent graduate employment and world-class research.

The information in this e-mail and any attachments may be confidential. If you have received this email in error please notify the sender immediately and remove it from your system. Do not disclose the contents to another person or take copies.

Email is not secure and may contain viruses. The University of Lincoln makes every effort to ensure email is sent without viruses, but cannot guarantee this and recommends recipients take appropriate precautions.

The University may monitor email traffic data and content in accordance with its policies and English law. Further information can be found at: http://www.lincoln.ac.uk/legal.