<html><head><base href="x-msg://158/"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><br><div><br></div><div><div><div>On Jun 2, 2011, at 8:45 AM, Peel Lisa wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div lang="FR-CH" link="blue" vlink="purple"><div class="WordSection1" style="page: WordSection1; "><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-size: 12pt; font-family: Arial, sans-serif; ">Hello<o:p></o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-size: 12pt; font-family: Arial, sans-serif; "><o:p> </o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 11pt; font-family: Calibri, sans-serif; "><span lang="EN-GB" style="font-size: 12pt; font-family: Arial, sans-serif; ">I need to create a list which will give me details of all the items at one library including the year of publication. Have tried adding publication year to the guided search but no data appears in the column.<o:p></o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 11pt; font-family: Calibri, sans-serif; "><span lang="EN-GB" style="font-size: 12pt; font-family: Arial, sans-serif; "><o:p> </o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 11pt; font-family: Calibri, sans-serif; "><span lang="EN-GB" style="font-size: 12pt; font-family: Arial, sans-serif; ">Apologies for making such a basic request but I have been asked for the report to be done urgently!<o:p></o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 11pt; font-family: Calibri, sans-serif; "><span lang="EN-GB" style="font-size: 12pt; font-family: Arial, sans-serif; "><o:p> </o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 11pt; font-family: Calibri, sans-serif; "><span lang="EN-GB" style="font-size: 12pt; font-family: Arial, sans-serif; ">Any help appreciated<o:p></o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 11pt; font-family: Calibri, sans-serif; "><span lang="EN-GB" style="font-size: 12pt; font-family: Arial, sans-serif; "><o:p> </o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 11pt; font-family: Calibri, sans-serif; "><span lang="EN-GB" style="font-size: 12pt; font-family: Arial, sans-serif; ">Regards<o:p></o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 11pt; font-family: Calibri, sans-serif; "><span lang="EN-GB" style="font-size: 12pt; font-family: Arial, sans-serif; "><o:p> </o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 11pt; font-family: Calibri, sans-serif; "><span lang="EN-GB" style="font-size: 12pt; font-family: Arial, sans-serif; ">Lisa<o:p></o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 11pt; font-family: Calibri, sans-serif; "><span lang="EN-GB" style="font-size: 12pt; font-family: Arial, sans-serif; "><o:p> </o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 18pt; font-size: 11pt; font-family: Calibri, sans-serif; line-height: 12pt; "><span style="font-size: 12pt; font-family: Arial, sans-serif; color: black; "><span><image001.jpg></span></span><b><span lang="EN-US" style="color: black; "><o:p></o:p></span></b></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 18pt; font-size: 11pt; font-family: Calibri, sans-serif; line-height: 12pt; "><b><span lang="EN-US" style="color: black; "><o:p> </o:p></span></b></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 18pt; font-size: 11pt; font-family: Calibri, sans-serif; line-height: 12pt; "><b><span lang="EN-US" style="color: black; "><o:p> </o:p></span></b></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 18pt; font-size: 11pt; font-family: Calibri, sans-serif; line-height: 12pt; "><b><span style="color: black; ">LISA PEEL, PGDip, MA.</span></b><b><span style="font-size: 12pt; font-family: 'Times New Roman', serif; color: black; "><o:p></o:p></span></b></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 18pt; font-size: 11pt; font-family: Calibri, sans-serif; line-height: 12pt; "><span style="color: black; ">Librarian</span><span style="color: black; "><o:p></o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 18pt; font-size: 11pt; font-family: Calibri, sans-serif; line-height: 12pt; "><span style="color: black; ">César Ritz Colleges Switzerland<o:p></o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 18pt; font-size: 11pt; font-family: Calibri, sans-serif; line-height: 12pt; "><span style="color: black; ">1897 Le Bouveret - Switzerland<o:p></o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 18pt; font-size: 11pt; font-family: Calibri, sans-serif; line-height: 12pt; "><span lang="EN-US" style="color: black; ">Tel: +41 24 482 82 82 Fax: +41 24 482 82 80<o:p></o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 18pt; font-size: 11pt; font-family: Calibri, sans-serif; line-height: 12pt; "><span lang="EN-US" style="color: black; ">E-mail:<span class="Apple-converted-space"> </span><b><a href="mailto:hortense.hofer@ritz.edu" style="color: blue; text-decoration: underline; "><span style="color: blue; ">lisa.peel@ritz.edu</span></a></b><o:p></o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 18pt; font-size: 11pt; font-family: Calibri, sans-serif; line-height: 12pt; "><span lang="EN-US" style="color: black; "><a href="http://www.ritz.edu/" style="color: blue; text-decoration: underline; "><span style="color: blue; ">http://www.ritz.edu</span></a><span class="Apple-converted-space"> </span>-<span class="Apple-converted-space"> </span><a href="http://www.culinaryarts.ch/" style="color: blue; text-decoration: underline; "><span style="color: blue; ">http://www.culinaryarts.ch</span></a><o:p></o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 11pt; font-family: Calibri, sans-serif; "><o:p> </o:p></div></div>_______________________________________________<br>Koha mailing list <a href="http://koha-community.org" style="color: blue; text-decoration: underline; ">http://koha-community.org</a><br><a href="mailto:Koha@lists.katipo.co.nz" style="color: blue; text-decoration: underline; ">Koha@lists.katipo.co.nz</a><br><a href="http://lists.katipo.co.nz/mailman/listinfo/koha" style="color: blue; text-decoration: underline; ">http://lists.katipo.co.nz/mailman/listinfo/koha</a><br></div></blockquote></div><div><br></div><div><br><div><br></div><div><div>SELECT items.itemcallnumber, items.barcode, biblio.author, biblio.title, biblioitems.publicationyear FROM items JOIN biblio USING (biblionumber) join biblioitems USING (biblionumber) WHERE items.homebranch='yourbranch' limit 150000 ORDER BY items.itemcallnumber asc</div></div><div><br></div><div>notes: </div><div>Paste this into the reports "Create from SQL" section, and run from there.</div><div>you'll want to put in your branch code for 'yourbranch'</div><div>Set the limit to something above the maximum number of records you expect.</div><div><br></div><div>Hope this helps!</div></div><div><br></div><br><div>
Liz Rea<br><a href="mailto:lrea@nekls.org">lrea@nekls.org</a><div><br></div><span><img height="80" width="312" id="bfec442c-f1ce-4eaa-91ff-3f0305c00026" apple-width="yes" apple-height="yes" src="cid:35CEBCBA-C54F-4235-A287-767DB4A9BDBF@lan.nekls.org"></span>
</div>
<br></div></body></html>