Hi, all -- Did some more testing & it appears that Item Type information is not available when holds are placed for the Next Available item. Can't think of an easy work-around as it's entirely possible to have items attached to the same bib with different item types. Cheers, Cab Vinton Plaistow Public Library On Tue, Mar 27, 2018 at 12:30 PM, Cab Vinton <bibliwho@gmail.com> wrote:
Hi, All --
I'm trying to create a report that will give me hold counts broken down by bib record and the patron's branch.
I believe what I have is pretty close, but some of the output omits the item type information.
This is what I have:
SELECT count(borrowers.branchcode) AS Holds, borrowers.branchcode, biblio.title, biblio.biblionumber, biblio.datecreated, items.itype FROM reserves LEFT JOIN borrowers USING (borrowernumber) LEFT JOIN biblio USING (biblionumber) LEFT JOIN items USING (itemnumber) GROUP BY biblio.biblionumber, borrowers.branchcode ORDER BY count(borrowers.branchcode) DESC, biblio.title
And some sample output:
Holdsbranchcodetitlebiblionumberdatecreateditype 6KIMBALLLilac girls :1420692016-04-19BOOK 6KIMBALLThe woman in the window :1581622018-01-03NEWBOOK 6KIMBALLVictoria. The complete second season /1585952018-01-30NEWMOVIE 4SANDOWNAccidental heroes :1571562017-10-28 4PLAISTOWFall from grace :1560952017-09-12 4KIMBALLThe great alone /1560892017-09-12 3SANDOWNI've got my eyes on you :1571502017-10-28 3PLAISTOWLilac girls :1420692016-04-19 3SANDOWNSweet vengeance /1571522017-10-28NEWBOOK
Can anyone provide a fix?
Many thanks in advance,
Cab Vinton Plaistow Public Library