[Koha-devel] Notifications RFC

[Wagner, Jane]

You should be able to select for that based on the letter_code field,
assuming you're using different notice files for each level.  For example:

select * from message_queue where letter_code = 'ODUE3' order by
time_queued desc

should produce only third overdue messages.

Jane Wagner
Senior Project Manager
LibLime, a division of PTFS
Content Management and Library Solutions
6400 Goldsboro Road, Suite 200
Bethesda, MD  20817
(301) 654-8088 x 151
jwagner at liblime.com


-----Original Message-----
From: koha-devel-bounces at lists.koha-community.org
[mailto:koha-devel-bounces at lists.koha-community.org] On Behalf Of Cindy
Murdock Ames
Sent: Friday, August 26, 2011 10:57 AM
To: koha-devel at lists.koha-community.org
Subject: Re: [Koha-devel] Notifications RFC

Another thing that would be nice would be the ability to specify which
level of notices to produce (First, Second, Third, etc).  I was fiddling
around with notices yesterday, and if you produce an html file for them,
you can tell which is which because of the differences in the notices
template for each level.  But if you produce a csv file, you can't tell
which is which because it just outputs the data into the file.  We have
a library that wants to mail their overdue notices, and they're not
entirely happy with how the html output prints, and they could use the
csv file for mail merge in a word processor, but since it lumps all the
levels together, there's no way to tell which level they are.

Cheers,
Cindy

-- 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Cindy Murdock Ames
IT Services Director
Meadville Public Library    | CCFLS
http://meadvillelibrary.org | http://ccfls.org

_______________________________________________
Koha-devel mailing list
Koha-devel at lists.koha-community.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/