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.belizaire@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.belizaire@sys-tech.net <mailto:claude.belizaire@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