You are here: Home » Topic » Smart Playlist Sorting

Smart Playlist Sorting

This topic contains 15 replies, has 11 voices, and was last updated by  Anonymous 8 years, 7 months ago.

Viewing 15 posts - 1 through 15 (of 16 total)
  • Author
    Posts
  • #366

    tri
    Participant

    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

    #5093

    Charly86
    Participant

    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

    #5094

    fizze
    Participant

    I third that.

    #5095

    mattb
    Participant

    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.

    #5096

    LovinFireFly
    Participant

    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.

    #5097

    fizze
    Participant

    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 😉

    #5098

    LovinFireFly
    Participant

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

    #5099

    fizze
    Participant

    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.

    #5100

    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/

    #5101

    Anonymous

    No plans to implement this, I take it?

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

    #5102

    fizze
    Participant

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

    #5103

    rpedde
    Participant

    @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.

    #5104

    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
    <

    #5105

    Alhifi
    Participant

    @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

    #5106

    mattb
    Participant

    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).

Viewing 15 posts - 1 through 15 (of 16 total)

The forum ‘Feature Requests’ is closed to new topics and replies.