SQL for New Items added in the last 30 days?
I'm trying to cobble together some SQL that will give me a list o any new items added to stock in the last 30 days. I usually run report a in Decisions which does this, well kind of. It uses query filters to specify only 'operators' that process new stock, another filter to specify the month edited, and another to specify a fund code - current financial year filter is also applied - This reports back item barcode, sequence, author, title and year of publication. Ok, so I've got as far as isql -Usa -P, can anyone help? I'm trying to do this so that I can build the output into an RSS feed to alert borrowers when new stock is added. I've had a look at Tim Hodson's post here http://www.talis.com/tdn/node/1759. This has been really useful, but I can't manipulate his code to get the required data. Any help would be very much appreciated.



I have created an rss feed
I have created an rss feed of sorts for new items using Tim's code. if you want to have a look let me know (i.gray@gre.ac.uk).