[Koha] SQL report: Digests in message preferences

[Liz Rea]

(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.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
>
>

-- 
--
Liz Rea
Catalyst.Net Limited
Level 6, Catalyst House, 
150 Willis Street, Wellington.
P.O Box 11053, Manners Street, 
Wellington 6142

GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7