[Koha] Report help needed - filter by itemtype

[vishal patil]

hi,

For item pull down list try this:

Replace this: biblioitems.itemtype=‘BK’  with:

items.itype=<<Select Itemtype|itemtypes>>



On Mon, Jun 9, 2014 at 5:49 AM, Robin Sheat <robin at catalyst.net.nz> wrote:

> Elaine Bradtke schreef op vr 06-06-2014 om 21:42 [+0100]:
> > WHERE biblioitems.itemtype=‘BK’ AND datecreated
>
> You have smartquotes around the BK. You can't have smartquotes anywhere.
>
> --
> Robin Sheat
> Catalyst IT Ltd.
> ✆ +64 4 803 2204
> GPG: 5FA7 4B49 1E4D CAA4 4C38  8505 77F5 B724 F871 3BDF
>
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>



-- 


*Warm Regards,Vishal Patil*Software Engineer - Nucsoft Ltd.
phone: 022 32080161
www.osslabs.biz
www.nucsoft.com
vishal.patil at osslabs.biz
 <http://nucsoft.com/nucweb/images/OSS_labs.jpg>