Reply To: Limit smart playlists ?


@rpedde wrote:

Or maybe your nightly cron job would do

delete from playlist items where playlistid=154; insert into playlistitems ...

Ooh. Except I just noticed a full rescan deletes those. I’ll fix that for next nightly.

Ok, so it’s a semi-static playlist… then it’s no big difference than making a m3u-list…

What I was wishing for was a non-cron fully “automated” way to create sql queries.

Is it hard to implement some way where you could add the option to create a sql-query in the playlists-table ?

Something like

sqlite> insert into playlists (title,type,items,db_timestamp,idx,query) values ('Recent Adds',99,100,0,0, 'select xyz from abc');