search

CARLI / web-reports

Web Reports Web Based Reporting Tool
2 stars 0 forks source link

Newly Entered Reports #67

Closed csaundrs closed 8 years ago

csaundrs commented 8 years ago

These reports were added to web-reports-devel: (They probably need to pass muster as far as being tested and results verified, but then can be moved to production if they do)

Local Catalog Maintenance -> Item Records -> Barcodes -> Items with no active barcode Local Catalog Maintenance -> Item Records -> General -> Item records containing double quote Universal Borrowing -> List patrons with materials charged from other I-Share libraries Universal Borrowing -> UB Call Slip Processing Statistics by Date Range

patrickzurek commented 8 years ago

I was working on some other stuff on the server so likely when you tried to run these Chris they wouldn't have worked. I restarted Apache and "Items with no active barcode" and "List patrons with materials charged from other I-Share libraries" run.

There's errors with "Item records containing double quote" and "UB Call Slip Processing Statistics by Date Range." I'm looking at the SQL to see if I can correct them.

patrickzurek commented 8 years ago

I fixed Item records containing double quote by escaping the % symbol with another % symbol like so: '%%\"%%'.

UB Call Slip Processing Statistics by Date Range wasn't working because it didn't have a date formatting function in it. I added to_date(param,'MM-DD-YYYY') where it was required.

All four should be working now. Jessica, can you test that they're returning accurate results?

gibsonjc commented 8 years ago

Pat, please push these four to prod at your convenience. I tested them against Access and got the same results, and cleaned up the text fields.

Local Catalog Maintenance -> Item Records -> Barcodes -> Items with no active barcode Local Catalog Maintenance -> Item Records -> General -> Item records containing double quote Universal Borrowing -> List patrons with materials charged from other I-Share libraries Universal Borrowing -> UB Call Slip Processing Statistics by Date Range

patrickzurek commented 8 years ago

These reports are on production now.