[Koha] ISBN report

[Nicolas Legrand]

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 at 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 at bulac.fr>
> wrote:
>
> > something like this?
> >
> > SELECT DISTINCT isbn FROM biblioitems ;
> >
> > cheers,
> >
> >
> > 2014-02-25 8:23 GMT+01:00 Kerrie Stevens <KStevens at 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 at 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 at 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