I've searched through the reports site but can't find anything that sounds like it will do what I want. It's a simple report, but I just can't work it out... any help would be very much appreciated. I need a report to list every ISBN in my collection - a simple but very long results list. Does anyone have any suggestions of how to put it into SQL? Thank you for your help, Kerrie
something like this? SELECT DISTINCT isbn FROM biblioitems ; cheers, 2014-02-25 8:23 GMT+01:00 Kerrie Stevens <KStevens@harvest.edu.au>:
I've searched through the reports site but can't find anything that sounds like it will do what I want. It's a simple report, but I just can't work it out... any help would be very much appreciated. I need a report to list every ISBN in my collection - a simple but very long results list.
Does anyone have any suggestions of how to put it into SQL? Thank you for your help, Kerrie
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- *Nicolas Legrand* Administration technique et développements du système de gestion de la bibliothèque [image: Logo BULAC] Bibliothèque universitaire des langues et civilisations 65 rue des Grands Moulins F-75013 PARIS T +33 1 81 69 *18 22* www.bulac.fr
Could it be that the select against biblioitems miss multiple/alternative ISBN entries for a single item? Sent from my iPhone On 25 Φεβ 2014, at 2:40 μ.μ., Nicolas Legrand <nicolas.legrand@bulac.fr> wrote:
something like this?
SELECT DISTINCT isbn FROM biblioitems ;
cheers,
2014-02-25 8:23 GMT+01:00 Kerrie Stevens <KStevens@harvest.edu.au>:
I've searched through the reports site but can't find anything that sounds like it will do what I want. It's a simple report, but I just can't work it out... any help would be very much appreciated. I need a report to list every ISBN in my collection - a simple but very long results list.
Does anyone have any suggestions of how to put it into SQL? Thank you for your help, Kerrie
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
--
*Nicolas Legrand* Administration technique et développements du système de gestion de la bibliothèque
[image: Logo BULAC]
Bibliothèque universitaire des langues et civilisations
65 rue des Grands Moulins F-75013 PARIS T +33 1 81 69 *18 22* www.bulac.fr _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
It prints a value only once, if you want all values from all rows, remove the 'DISTINCT' from the request. 2014-02-26 0:54 GMT+01:00 Manos PETRIDIS <egpetridis@gmail.com>:
Could it be that the select against biblioitems miss multiple/alternative ISBN entries for a single item?
Sent from my iPhone
On 25 Φεβ 2014, at 2:40 μ.μ., Nicolas Legrand <nicolas.legrand@bulac.fr> wrote:
something like this?
SELECT DISTINCT isbn FROM biblioitems ;
cheers,
2014-02-25 8:23 GMT+01:00 Kerrie Stevens <KStevens@harvest.edu.au>:
I've searched through the reports site but can't find anything that sounds like it will do what I want. It's a simple report, but I just can't work it out... any help would be very much appreciated. I need a report to list every ISBN in my collection - a simple but very long results list.
Does anyone have any suggestions of how to put it into SQL? Thank you for your help, Kerrie
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
--
*Nicolas Legrand* Administration technique et développements du système de gestion de la bibliothèque
[image: Logo BULAC]
Bibliothèque universitaire des langues et civilisations
65 rue des Grands Moulins F-75013 PARIS T +33 1 81 69 *18 22* www.bulac.fr _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- *Nicolas Legrand* Administration technique et développements du système de gestion de la bibliothèque [image: Logo BULAC] Bibliothèque universitaire des langues et civilisations 65 rue des Grands Moulins F-75013 PARIS T +33 1 81 69 *18 22* www.bulac.fr
participants (3)
-
Kerrie Stevens -
Manos PETRIDIS -
Nicolas Legrand