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
it
-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 sen
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
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
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
wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Hello all,
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
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. Circul
