[Koha] koha reports

[Dennis Mapikure]

How do I configure report or to check records added by cataloguers or fines
collected by librarians
*Dennis Mapikure | Assistant Librarian - Library Systems*

*Great Zimbabwe University Library*
*P.O. Box 1235 Masvingo, Zimbabwe/ Off Old Great Zimbabwe Road*

*Mobile: +263-773040331/ 0788807131*

*Alternative Email: dmapik...@gmail.com *

*Website: www.gzu.ac.zw *
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Koha reports wiki

[Cab Vinton]

Hi, All --

Apologies for the cross-posting.

The clean up of the Reports wiki page appears to have got stalled out:
https://wiki.koha-community.org/wiki/SQL_Reports_Library

(Large no. of duplicate listings of reports for holds, patrons, &
circulation (HPC), which also appear on corresponding pages --
https://wiki.koha-community.org/wiki/SQL_Reports_Holds, etc.)

I've identified the reports on the main page that aren't cross-listed
(19 in total). I'd like to relocate these & then delete all the
listings under the HPC categories on the main page.

I suspect these pages see a lot of use, however, so I don't want to
barge in and inadvertently make things worse.

Anything I should be aware of before jumping in?

All best,

Cab Vinton, Director
Plaistow Public Library
Plaistow, NH
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] koha reports

[Michael Kuhn]

Hi Monisa

> help needed
> I need a complete patron list with item.barcodes (items still with 
that patron). this report should also include the patrons which don't 
have any item with them.
> what i made isSELECT 
borrowernumber,borrowers.cardnumber,borrowers.surname,borrowers.firstname,borrowers.address,borrowers.address2,borrowers.branchcode,borrowers.categorycode,borrowers.dateenrolled,borrowers.dateexpiry,borrowers.debarredcomment,borrowers.borrowernotes,items.barcodeFROM 
borrowers

> LEFT JOIN items
> but there is a syntax error, i don't know where?Monisa Aslam

There is no direct connection between tables "borrowers" and "items", 
but table "issues" contains both borrowernumber and itemnumber, so you 
will have to start with something like this:


SELECT borrowers.borrowernumber, items.itemnumber, items.barcode
FROM borrowers
LEFT JOIN issues ON borrowers.borrowernumber=issues.borrowernumber
LEFT JOIN items ON issues.itemnumber=items.itemnumber
ORDER BY borrowers.borrowernumber, items.itemnumber

It will give you a list like this:

+++--+
| borrowernumber | itemnumber | barcode |
+++--+
...
| 2122 | NULL | NULL |
| 2123 | NULL | NULL |
| 2124 | 1163 | 74042220 |
| 2124 | 5839 | 74112730 |
| 2124 | 14127 | 0826 |
| 2124 | 14156 | FERN0057 |
| 2124 | 14211 | FERN0060 |
| 2125 | NULL | NULL |
...

Also I advise to learn about the SQL syntax of JOIN since it doesn't 
work by just putting the name of a table after JOIN. For example here: 
http://www.w3schools.com/sql/sql_join.asp


Hope this helps.

Best wishes: Michael
--
Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis
Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz
T 0041 (0)61 261 55 61 · E m...@adminkuhn.ch · W www.adminkuhn.ch
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] koha reports

[Monisa Aslam]

help needed
I need a complete patron list with item.barcodes (items still with that 
patron). this report should also include the patrons which don't have any item 
with them.
what i made isSELECT  
borrowernumber,borrowers.cardnumber,borrowers.surname,borrowers.firstname,borrowers.address,borrowers.address2,borrowers.branchcode,borrowers.categorycode,borrowers.dateenrolled,borrowers.dateexpiry,borrowers.debarredcomment,borrowers.borrowernotes,items.barcodeFROM
 borrowers 
LEFT JOIN items
but there is a syntax error, i don't know where?Monisa Aslam

  
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] koha reports

[Arslan Farooq]

Hi,

This may help: http://wiki.koha-community.org/wiki/SQL_Reports_Library

Make the subject line of your emails more descriptive. See #3 here:
http://civility.missouri.edu/email-etiquette.php

We're not touchy about #9. But perhaps read that as well. Might help you
professionally.

Arslan

On Fri, Sep 26, 2014 at 12:17 PM, Monisa Aslam 
wrote:

> datewise list of checkin booksdatewise list of checkout books
> can anybody help??
> Monisa Aslam
>
>
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>



-- 
Electronic Resource Librarian
SZABIST Islamabad
www.szabist-isb.edu.pk
arslan.far...@szabist-isb.edu.pk
+92 514 863 363-65
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] koha reports

[Monisa Aslam]

datewise list of checkin booksdatewise list of checkout books
can anybody help??
Monisa Aslam

  
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Koha reports with Title and other title and statement of responsibility

[Indranil Das Gupta]

Hi Ashok,

On Tue, Nov 12, 2013 at 11:57 AM, Ashok Thomas wrote:

> Hello Koha Community,
>
> Please any one help me to create a report form koha with *Title, other
> title information and statement of responsibility .*
>

Have you tried out the Title/Sub-title List report by Katrin Fischer on the
wiki?

http://wiki.koha-community.org/wiki/SQL_Reports_Library#Title.2FSubtitle_List

It should fairly trivial to customize that report.

hope this helps
-idg


-- 
Indranil Das Gupta

Phone : +91-98300-20971
Blog: http://indradg.randomink.org/blog
IRC  : indradg on irc://irc.freenode.net
Twitter : indradg

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=-
Please exchange editable Office documents only in ODF Format. No other
format is acceptable. Support Open Standards.

For a free editor supporting ODF, please visit LibreOffice -
http://www.documentfoundation.org
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Koha reports with Title and other title and statement of responsibility

[Ashok Thomas]

Hello Koha Community,

Please any one help me to create a report form koha with *Title, other
title information and statement of responsibility .*

Thanking You.
Regards,

*Ashok Thomas*
Web site: http://ashokthomas.weebly.com
Blog: http://libscienceinformation.blogspot.in/
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Koha reports, include cataloguer

[Paul]

I am trying to "customize" some of our MySQL reports, to include the 
cataloguer who made the entry, with:


SELECT whatever FROM biblio
whatever FROM items
action_logs.user FROM action_logs
RIGHT JOIN biblioitems ON biblio.biblionumber = biblioitems.biblionumber
LEFT JOIN items ON biblio.biblionumber = items.biblionumber
WHERE whatever

but need a JOIN clause for action_logs  (could be RIGHT? timestamp? = 
?)  Without the third line the report is fully functional.


Could someone kindly assist?

Thanks and best regards,
Paul

___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha