[Koha] SQL report: Digests in message preferences

[Jonathan Druart]

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