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 [email protected] -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Cindy Murdock Ames Sent: Friday, August 26, 2011 10:57 AM To: [email protected] 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 [email protected] 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/ _______________________________________________ Koha-devel mailing list [email protected] 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/
