Share

OpenBiblio

The forum address has changed, you have been automatically redirected. Please update any bookmarks to use the new URL.

Subscribe

How many items checked out last month?

You are viewing a single message from this topic. View all messages.

  1. 2009-06-26 10:52:23 UTC
    There is a history of all items that were checked out in biblio_hist_dm. You can make other report file in /reports/defs (.rpt extension) with your criteria using sql.
    I made something like that for me time ago. Perhaps it can help you .

    .title checkouthistory
    .category Circulation
    .column bibid hidden
    .column status_begin_dt hidden
    .column barcode_nmbr sort=barcode_nmbr
    .column title sort=title func=biblio_link
    .column author sort=author
    .column checkoutCount sort=checkoutCount
    .parameters
    . date date_begin title="From (mm/dd/yy)"
    . date date_end title="To (mm/dd/yy)"
    . string barcode title="Report by copy"
    . order_by
    . item barcode_nmbr
    . item title
    . item author
    . item checkoutCount type=numeric
    . end order_by
    .end parameters
    .sql
    select b.bibid, c.barcode_nmbr, b.title, b.author,
    h.status_begin_dt ,
    count(h.status_begin_dt) checkoutCount
    from biblio_status_hist h, biblio_copy c, biblio b
    where h.bibid = c.bibid
    and h.copyid = c.copyid
    and h.bibid = b.bibid
    and h.status_cd = 'out'

    . if_set date_begin
    and h.status_begin_dt >= %date_begin%
    . end if_set
    . if_set date_end
    and h.status_begin_dt <= %date_end%
    . end if_set

    group by b.title, b.author
    . if_set barcode
    ,c.barcode_nmbr
    . end if_set
    . order_by_expr
    .end sql
< Previous | 1 | Next >

Add a Reply

You can use Markdown syntax in your reply.

Preview

Monitor this

Log in to monitor this topic. Not registered? Create an account to receive email updates when replies are posted to this topic. If you do not log in or register, your reply will be added anonymously.