[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Koha-devel] Last Acquired RSS
From: |
Owen Leonard |
Subject: |
[Koha-devel] Last Acquired RSS |
Date: |
Fri Oct 21 12:07:26 2005 |
User-agent: |
Mutt/1.4.1i |
We'd like to offer RSS feeds for newly acquired items, but we haven't
managed to figure out how to do it well. The current configuration for the
last Acquired feed doesn't work well at all. It uses this query:
select biblio.title as title, biblio.author as author, biblio.biblionumber
as bibid from biblio, biblioitems, items where biblioitems.biblionumber =
items.biblionumber and biblio.biblionumber = items.biblionumber and
items.dateaccessioned is not NULL order by items.dateaccessioned desc
This doesn't work well for a couple of reasons:
1. It returns duplicate results
2. It returns results for items which have been recently added to old biblios
I'm wondering whether a simply search by biblionumber isn't going to return
better results? At least it would get me only new biblios, rather than new
items.
What do others think? Is anyone using Koha's RSS?
-- Owen
- [Koha-devel] Last Acquired RSS,
Owen Leonard <=