It has just occurred to me while looking at the long list building in the Latest Additions
news item that I might be able to add a query function to the web page to show all new additions within a certain time span.
The SAM database songlist
table maintains a date_added
Using the SQL query:
SELECT * FROM samdb.songlist s WHERE (songtype = 'S') ORDER BY date_added DESC
shows me all of the recent additions by date from the most recent. I can sort (collate) this alphabetically, by artist and then by album to build Jim's list programatically.
Question to all of you, should I?
If yes, should I allow a time span option
such as the following to look back:
Any other suggestions for adjunct features, bells, whistles, etc., if this function is added?
BTW, for Cozy
: If you're reading this, I found your show uploads are flagged 'S' when I did the SQL query. This means they will show up as tracks that can be requested. If you could, please try to insure that they are set 'C'. Because Jim's library adds go into a different folder on a completely different drive, I can program around this 'S'/'C' omission/oversight in a new additions
feature but SAM will continue to list your tracks for request if they are set to 'S'. There's also another thing you should do with SAM when you take down your shows. I'll take this up in the staff
Watcher of the moon, watcher of all.
Mopper of the moon, mopper of all.
-- Aural Moon's Janitorial Services
and Restroom Supplies, and Techno-patsy --
Cogito ergo iMac.