Re: [Koha] SQL report: Digests in message preferences

(General reminder to add things like this to the wiki) Cheers, Liz :) On 02/04/15 05:37, Chad Roseburg wrote: > Thanks Jonathan! Exactly what I was looking for. > > On Wed, Apr 1, 2015 at 1:31 AM, Jonathan Druart < > jonathan.dru...@biblibre.com> wrote: > >> Hello Chad, >> >> It's stored in the b

Re: [Koha] SQL report: Digests in message preferences

Thanks Jonathan! Exactly what I was looking for. On Wed, Apr 1, 2015 at 1:31 AM, Jonathan Druart < jonathan.dru...@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

Re: [Koha] SQL report: Digests in message preferences

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 : > Does anyo

[Koha] SQL report: Digests in message preferences

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 __