FacebookTwitterLinkedIn
Login / Register

Login / Register

IUG FORUM

Stay always connected!

Discussions tagged SQL

New Member

Automating searches to find course reserve materials?

At the beginning of each semester, we get a list of required texts from the bookstore. Currently, the circulation staff manually searches each title to see if we own it so it can be put on course reserve. I have been asked to automate a comparison of...
New Member

SQL to find permissions associated with item record change

Is there a way via SQL or any other way to see whose permissions are associated with changing an item record? For example, we would like to get a list of items where the status was changed in a particular time period. ajtaylor@scgov.net...
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