how to change bakgrowand colour in Koha On 12/15/11, koha-request@lists.katipo.co.nz <koha-request@lists.katipo.co.nz> wrote:

Send Koha mailing list submissions to koha@lists.katipo.co.nz

To subscribe or unsubscribe via the World Wide Web, visit http://lists.katipo.co.nz/mailman/listinfo/koha or, via email, send a message with subject or body 'help' to koha-request@lists.katipo.co.nz

You can reach the person managing the list at koha-owner@lists.katipo.co.nz

When replying, please edit your Subject line so it is more specific than "Re: Contents of Koha digest..."

Today's Topics:

1. Re: how can i view all the contents of the libary, Please make it more clear (Stefano Bargioni) 2. Error in Guided Report (Vimal Kumar) 3. Update on link resolver + Koha? (Amy Schuler) 4. Re: Update on link resolver + Koha? (Owen Leonard) 5. Checkout fails (Perch) 6. Call for News for the December Newsletter (Daniel Grobani) 7. Equinox offering two scholarships for the 2012 Code4Lib conference (Galen Charlton)

----------------------------------------------------------------------

Message: 1 Date: Wed, 14 Dec 2011 09:22:00 +0100 From: Stefano Bargioni <bargioni@pusc.it> To: koha@lists.katipo.co.nz Subject: Re: [Koha] how can i view all the contents of the libary, Please make it more clear Message-ID: <21A847B4-4888-4A3C-AA50-E476933F623F@pusc.it> Content-Type: text/plain; charset=us-ascii

Maybe the select suggested in the wiki

SELECT items.price,items.replacementprice,biblio.title,biblio.author,items.itemcallnumber FROM items LEFT JOIN biblioitems ON (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio ON (biblioitems.biblionumber=biblio.biblionumber) WHERE items.homebranch=<<Home branch|branches>> ORDER BY items.itemcallnumber ASC

could be enhanced using the cn_sort field, that cointains the sort form of itemcallnumber, changing the ORDER BY clause into ORDER BY items.cn_sort ASC Stefano

...

There is a report for a complete shelf list on the wiki - http://wiki.koha-community.org/wiki/SQL_Reports_Library#Complete_Shelf_list

You should be able to use that as a starting place to get what you're looking for.

Liz Rea

------------------------------

Message: 2 Date: Wed, 14 Dec 2011 14:59:02 +0530 From: Vimal Kumar <vimal0212@gmail.com> To: Koha-List <koha@lists.katipo.co.nz> Subject: [Koha] Error in Guided Report Message-ID: <CAEaJrwUCEkcj4Mp3YYC_je_xWin8xDxu9zKLAFCmYgicjD=-pw@mail.gmail.com> Content-Type: text/plain; charset="utf-8"

Dear Friends,I got the following message when try to create report from

Reports > Guided Reports > Build New

in the second step "Pick a report Type", Tabular.

My koha version is 3.4.7

Software error:

Undefined subroutine &C4::Reports::Guided::themelanguage called at /usr/share/koha/lib/C4/Reports/Guided.pm line 714.

For help, please send mail to the webmaster (webmaster@comp), giving this error message and the time and date of the error.

-- Vimal Kumar V. Mahatma Gandhi University Library Kottayam, Kerala- 686 560 Web: www.vimalkumar.org Blog: http://linuxhalwa.blogspot.com --------------------------------------------------------------------------- "I forget what I was taught. I only remember what I have learnt" -Patrick White