[Koha-devel] Last Acquired RSS
Chris Cormack
chris at katipo.co.nz
Fri Oct 21 13:00:49 CEST 2005
Owen Leonard wrote:
> 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.
>
Ata marie,
Hmm its a tricky one owen, there is no date_created field on the like on
the biblio table. So you cant do a date range search, but certainly, as
the biblionumber increments upwards all the time, you could grab the
last 10 biblionumbers, those would be the last 10 biblios added.
Something like
SELECT title,author,biblionumber FROM biblio ORDER BY biblionumber DESC
LIMIT 10;
Chris
--
Chris Cormack Katipo Communications
Programmer www.katipo.co.nz
027 4500 789
More information about the Koha-devel
mailing list