[Koha] SQL report: Digests in message preferences

Jonathan Druart jonathan.druart at biblibre.com
Wed Apr 1 21:31:01 NZDT 2015

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;


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

More information about the Koha mailing list