Perhaps something like: SELECT br.branchname, b.title, b.author, it.description, i.itemcallnumber, i.barcode, c.description, p.surname, p.firstname FROM issues iss CROSS JOIN branches br USING (branchcode) CROSS JOIN items i USING (itemnumber) CROSS JOIN biblio b USING (biblionumber) CROSS JOIN itemtypes it ON i.itype = it.itemtype CROSS JOIN borrowers p USING (borrowernumber) CROSS JOIN categories c USING (categorycode) ORDER BY iss.branchcode;
On Thu, 2010-03-25 at 01:20 -0400, Claude Belizaire wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Hello all, > > Can someone help me? I need the SQL query that would generate a report > listing checked-out items by location. > > Cheers, > Claude > > > Le 2010-03-25 01:02, Claude Belizaire a écrit : > > Thanks for the quick reply, I have looked at the link you sent. It > > has lots of custom queries but I would need more time then I have > > to complete the reports. > > > > I was able to generate a report from on of the koha demo but I > > would really appreciate tips help building those custom reports. > > > > I would be happy to make a donation through paypal in exchange for > > some help. :-) > > > > Cheers, Claude > > > > Le 2010-03-25 00:44, Nicole Engard a écrit : > >> Some of these types of reports can be found on the wiki: > >> http://wiki.koha.org/doku.php?id=sql_library > > > >> You can also request new reports on that page. > > > >> Thanks Nicole C. Engard > > > >> On Wed, Mar 24, 2010 at 11:49 PM, Claude Belizaire > >> <claude.beliza...@sys-tech.net> wrote: Hello all, > > > >> I am building custom reports in Koha and I am having some > >> troubles getting the right results when creating custom > >> definitions. > > > >> 1. Acquisitions by status (ordered, received, processed, new > >> releases) > > > >> 2. A detailled budget report > > > >> 3. Circulation by patron categories. > > > >> 4. Checked-out items by location. > > > >> Can anyone help me? > > > >> Regards, Claude > >>> > > _______________________________________________ Koha-devel mailing > > list Koha-devel@lists.koha.org > > http://lists.koha.org/mailman/listinfo/koha-devel > >>> > > > > _______________________________________________ > Koha-devel mailing list > Koha-devel@lists.koha.org > http://lists.koha.org/mailman/listinfo/koha-devel > > - -- > *Claude Bélizaire* > Chef d`équipe Web > > claude.beliza...@sys-tech.net <mailto:claude.beliza...@sys-tech.net> > 418 520-0739 poste 140 > 514 907-0036 / 1-877-969-8324 > > *SYS-TECH / Technologies de l'information libres* > 6700 BOUL PIERRE-BERTRAND BUREAU 209 > QUÉBEC QC G2J 0B4 > http://www.sys-tech.net > > /Membre supporteur de l'Association TYPO3 <http://typo3.org>/ > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.10 (MingW32) > Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ > > iQEcBAEBAgAGBQJLqvK7AAoJEDbGJ8QX4NMpfVEH/26ew/FaBHS1IN6UnKMTC4rN > wy13drkkvd21esxhhg0HYg0C5pio/qgVIzxOBv9cbKolRj02Wwg1thVIycJMtvdO > gm0R5Bzxr2lC1O42qiCOxAIlkOuV8Ss/0qSq/BktsebClsKSWPgFOZoIUUNk4I/n > xVjPWUiboRkvGLv/B/vGftIEVBRMHchw/rlIMdgOaCARPpSv3jOoC59QLPJljuaR > rCjMMtdiCU7SbBGGZkN3bQVMsCrnidBRmqODECrafIqT0C4iQF4OtuG+8DUKE9zD > s1wTS0JHE7RtOJwORGsw5KLCMAPK8D2RCG0QvzbWFJCliBUrHqpal1GI6SWDoHs= > =8NkZ > -----END PGP SIGNATURE----- > > _______________________________________________ > Koha-devel mailing list > Koha-devel@lists.koha.org > http://lists.koha.org/mailman/listinfo/koha-devel -- Michael Hafen Systems Analyst and Programmer Washington County School District Utah, USA for Koha checkout http://development.washk12.org/gitweb/ or git://development.washk12.org/koha _______________________________________________ Koha-devel mailing list Koha-devel@lists.koha.org http://lists.koha.org/mailman/listinfo/koha-devel
