[Koha] SQL report: Digests in message preferences

Chad Roseburg croseburg at ncrl.org
Thu Apr 2 05:37:37 NZDT 2015


Thanks Jonathan! Exactly what I was looking for.

On Wed, Apr 1, 2015 at 1:31 AM, Jonathan Druart <
jonathan.druart at biblibre.com> wrote:

> Hello Chad,
>
> It's stored in the borrower_message_preferences.wants_digest column.
> So the following query should return what you want:
> > select distinct borrowernumber from borrower_message_preferences where
> wants_digest=1;
>
> Regards,
> Jonathan
>
> 2015-04-01 1:11 GMT+02:00 Chad Roseburg <croseburg at ncrl.org>:
> > Does anyone have a report showing barcodes of patrons who do not have the
> > "Digests only?" option enabled.
> >
> > I see the transport types but am not sure how the digest option is
> stored.
> >
> > Thank you!
> >
> > --
> > Chad Roseburg
> > Automation Dept.
> > North Central Regional Library
> > _______________________________________________
> > Koha mailing list  http://koha-community.org
> > Koha at lists.katipo.co.nz
> > http://lists.katipo.co.nz/mailman/listinfo/koha
>



-- 
Chad Roseburg
Automation Dept.
North Central Regional Library


More information about the Koha mailing list