Smart Playlist Sorting

[tri]

Since the soundbridge can’t sort playlists (like iTunes does) smart playlists in mt-daapd are almost completely useless without possibility to add optional “ORDER BY” definitions to the playlist. In most cases “ORDER BY artist,album,disc_no,track_no” would do the trick.

–Rinne

[Charly86]

Sure, I’d like this feature also, some of my smartplaylist returns 50/60 songs and i’d like to have them sorted by artist or title

of course is sqlite knows the clause ORDER BY 🙂

thanks

[fizze]

I third that.

[mattb]

Me too. Especially if it included order by random.
Maybe even just a primitive passthrough for powers users who can write queries would be fantastic.

[LovinFireFly]

Absolutely, a random option would be great.

I’ve been using WMP11 and it has a “Random” tag you can add to the playlist’s XML and thus the songs are randomized. I know I can hit the shuffle button on my Soundbridge, but I’m lazy and would like it to auto-magically randomize.

[fizze]

ok, seen that comment somwhere else already.
Now that is something thats not difficult in a real DB.
but I am unsure of GDBs assets when it comes to order by random stuff 😉

[LovinFireFly]

Okay, I’ll show my newbieness. What’s GDB?

[fizze]

GDB is a small and verfy lightweight albeit fast database-like framework (hope I didnt hurt anyones feeling, putting it like that ;))

mt-daapds used to rely on gdb, back in the day. sqlite and stuff is nice, but it is in fact slower on embedded devices compared to sqlite.
So on the slug, gdb is a goodie.
On a PC you dont care, so it’s sqlite, prolly.

[Anonymous]

You might be interested to know that I’ve developed a technique to overcome the limitation of not being able to sort playlists, by creating a static playlist directly from the database.

More details here: http://www.andrewferrier.com/blog/2008/01/05/more-flexible-firefly-smart-playlists-with-perl-sqlite3-and-m3u/

[Anonymous]

No plans to implement this, I take it?

Shame, I’d like to create playlists like “most played” and “most recent”.

[fizze]

Ah, sweet. 8)
I have to check this out once I have some spare time on my hands.

[rpedde]

@Strawp wrote:

No plans to implement this, I take it?

Shame, I’d like to create playlists like “most played” and “most recent”.

I expect it will be in there shortly after next nightly.

[Anonymous]

diff db-sql.c db-sql.c.orig
1195,1198c1195
<
< strcat(query_rest, " order by artist, year, album, track");
<
< } else {
—
> } else {
1297,1298d1293
< if(!browse)
< strcat(query_rest, " order by artist, year, album, track");
1334d1328
< strcat(query_rest, " order by artist, year, album, track");
1385d1378
<

[Anonymous]

@rpedde wrote:

@Strawp wrote:

No plans to implement this, I take it?

Shame, I’d like to create playlists like “most played” and “most recent”.

I expect it will be in there shortly after next nightly.

I also like a feature to sort the playlists like “order by album, track” … is it still a request or included in which nightly release?

Bye
Alhifi

[mattb]

I’d also love to see this as well as being able to limit results, like how you can say SELECT TOP 100 in T-SQL. The combo of limiting with sorting (with random) could be very powerful!
Since I have moved to a NAS, it’s a lot slower for my big smart playlists to load (~12000 songs fit the criteria).

[Author]

Posts