Printing Lists the “Old Way” in Koha 3.14 1

I’ve been teaching our partners all about Koha 3.14 and one of the great upgrades that comes with 3.14 is a new interface for lists in the staff client. I happen to love this new look and feel, but a few of our partners noted that the new printable version of the list is a bit long for their liking so in true Koha and open source fashion I was able to write them a report that would generate a list in the way they wanted to print it:

select concat(b.title, ' ', ExtractValue(bi.marcxml, '//datafield[@tag="245"]/subfield[@code="b"]')) as Title,, c.dateadded, GROUP_CONCAT(DISTINCT i.itemcallnumber SEPARATOR ' , ') AS 'Call Number(s)' 
from virtualshelves l 
left join virtualshelfcontents c using (shelfnumber) 
left join biblio b using (biblionumber) 
left join items i on (b.biblionumber=i.biblionumber) 
left join biblioitems bi on (b.biblionumber=bi.biblionumber) 
where l.shelfname like <<List name like (use % for wildcard)>> 
group by b.biblionumber
order by b.title asc

To print out the list just enter the list name exactly right when asked by Koha or enter it with % around it. So %research% will find any list with the word ‘Research’ in the list name.

Leave a comment

Your email address will not be published. Required fields are marked *

Are you human? * Time limit is exhausted. Please reload CAPTCHA.

One thought on “Printing Lists the “Old Way” in Koha 3.14