Reply To: Limit smart playlists ?

#7920
riro
Participant

@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');