Login / Register

Login / Register


Stay always connected!

Discussions tagged SQL

Expert Member

Ideas for 2018 Hackathon

If you have an idea for hackathon 2018 please reply to this post with your idea. if you don't have an idea to share but saw an idea submitted by someone else that you like, please vote for it by clicking the Thumb up button. by next year we wil...
New Member

stats of checkouts from holds

Hi all, Is it possible to find out if a circulation (checkout) has come from a filled hold? I don't see anything obvious in the circ_trans table. We want to try and find out how many circs come from holds for a specific portion of our patrons. ...
No Ranking

SQL for multiple copies

Hello! I was wondering if anyone out there has a SQL query to identify when a branch has multiple copies of a title based on location code. For instance, we'd like to know when we have 2 or more copies of any adult non-fiction title at one partic...
No Ranking

Teleforms Crashed. How do we find patrons?

How can I create list or use an SQL to retrieve patrons that should have been notified by teleforms between two dates?...
  • Page :
  • 1