Skip to main content
ExLibris

Knowledge Assistant

BETA
 
Aleph

 

Ex Libris Knowledge Center
  1. Search site
    Go back to previous article
    1. Sign in
      • Sign in
      • Forgot password
  1. Home
  2. Aleph
  3. Knowledge Articles
  4. Finding loans with improbable/incorrect due dates

Finding loans with improbable/incorrect due dates

  1. Last updated
  2. Save as PDF
  3. Share
    1. Share
    2. Tweet
    3. Share
  1. Description
  2. Resolution
  • Product: Aleph
  • Product Version: 20, 21, 22, 23
  • Relevant for Installation Type: Dedicated-Direct, Direct, Local

 

Description

How can we find loans with improbable/incorrect due dates?

Resolution

The following SQL can be used for for analyzing loan dates and due dates:

> s+ xxx50
xxx50@ALEPH20> select /*+ DYNAMIC_SAMPLING(2) ALL_ROWS */ z36_loan_date, z36_original_due_date, z36_due_date, count(*) from z36 where z36_loan_date > '20161124' and z36_due_date > '20161220' group by z36_loan_date, z36_due_date, z36_original_due_date having count(*) > 1 order by z36_loan_date, z36_due_date, z36_original_due_date; 

A difference between the z36_original_due_date and the (current) z36_due_date indicates that either the item was renewed or the due date was changed manually.

 

 


  • Article last edited: DD-Mmm-YYYY
View article in the Exlibris Knowledge Center
  1. Back to top
    • Finding duplicate Authority records
    • Finding the most checked-out item
  • Was this article helpful?

Recommended articles

  1. Language
    English
    Product
    Aleph
  2. Tags
    1. SQL
    2. z36
    3. z36_due_date
  1. © Copyright 2025 Ex Libris Knowledge Center
  2. Powered by CXone Expert ®
  • Term of Use
  • Privacy Policy
  • Contact Us
2025 Ex Libris. All rights reserved