[Koha] SQL report: Digests in message preferences
liz at catalyst.net.nz
Thu Apr 2 10:15:35 NZDT 2015
(General reminder to add things like this to the wiki)
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
>> 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
>>> Thank you!
>>> Chad Roseburg
>>> Automation Dept.
>>> North Central Regional Library
>>> Koha mailing list http://koha-community.org
>>> Koha at lists.katipo.co.nz
Level 6, Catalyst House,
150 Willis Street, Wellington.
P.O Box 11053, Manners Street,
GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7
More information about the Koha