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

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

(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

[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