[Music] [solved] Music "sort by" AlbumArtist (1 Viewer)

ajs

Development Group
  • Team MediaPortal
  • February 29, 2008
    12,453
    7,150
    Kyiv
    Ukraine Ukraine
    Country flag
    Artists contains Artist picture... Folder.jpg used in shared view not in DB view.

    --
    WBR, ajs :):whistle::coffee:
     

    ajs

    Development Group
  • Team MediaPortal
  • February 29, 2008
    12,453
    7,150
    Kyiv
    Ukraine Ukraine
    Country flag
    What view settings yuo have? I still dont understand you problem :(

    --
    WBR, ajs :):whistle::coffee:
     

    sleepycol

    Portal Pro
    June 2, 2006
    536
    39
    United Kingdom United Kingdom
    Country flag
    Don't name Album like Disc1 Disc2 etc... Make name - Album and in disc MP3 tag set 1 2 ...

    --
    WBR, ajs :):whistle::coffee:
    That will only solve the disc 1 and disc 2 sort order. However all the various artist albums are in random order. eg now 22 is after now 80 etc and in the screenshots provided on previous posts you can see Euphoria listed before Clubland,which is incorrect
     
    Last edited:

    ajs

    Development Group
  • Team MediaPortal
  • February 29, 2008
    12,453
    7,150
    Kyiv
    Ukraine Ukraine
    Country flag
    Ok! Let's try to figure it out. :)

    Let's start with your music view settings.
    When you go to Music window you see:
    1. All Albums for All Artists and for All Album Artists in Artist order (Which is inconvenient but also does not make sense).
    How to sort Album by Artist in this situation: Album - Alambra, Artist - Wagner and Album - Wing, Artist - Andrew? Wing then Alambra? Or better, as usual, by name, Alambra then Wing ...
    2. Then you see all the discs for the selected album.
    3. Then you see all the songs for the selected album and for the selected disc.
    And when i try you view setting i have:
    upload_2020-1-5_10-41-58.png
    And as I understand it, what are you talking about the problem of sorting albums as in the screenshot?

    I make this Test music view:
    upload_2020-1-5_10-18-10.png
    And get:
    upload_2020-1-5_10-25-53.png

    When i switch Sort order by Artist i get:
    upload_2020-1-5_10-27-40.png
    And as I understand it, what are you talking about the problem of sorting albums as in the screenshot?

    Then i make this view:
    upload_2020-1-5_10-18-43.png
    And get:
    upload_2020-1-5_10-31-9.png upload_2020-1-5_10-31-24.png upload_2020-1-5_10-31-36.png

    But the best for me (like cd bookshelf) this View:
    upload_2020-1-5_10-19-37.png

    PS:
    If I understand the problem correctly, then I'll see where this sorting occurs, because At this stage, the following query works:
    SQL:
    select * from tracks  group by strAlbum, strAlbumArtist  order by strAlbum asc
    And result:
    Code:
    idTrack    strPath    strArtist    strAlbumArtist    strAlbum    strGenre    strComposer    strConductor    strTitle    iTrack    iNumTracks    iDuration    iYear    iTimesPlayed    iRating    iFavorite    iResumeAt    iDisc    iNumDisc    strLyrics    strComment    strFileType    strFullCodec    strBitRateMode    iBPM    iBitRate    iChannels    iSampleRate    dateLastPlayed    dateAdded
    36975    \MP3\Metallica\1988 - ... And Justice For All\01 - Blackened.mp3    | Metallica |    | Metallica |     ... And Justice For All    | Metal |    | James Hetfield | Jason Newsted | Lars Ulrich |         Blackened    1    9    403    1988    0    0    0    0    0    0            mp3    MPEG Version 1 Audio, Layer 3    CBR    0    320    2    44100    0001-01-01 00:00:00.000    2014-12-29 22:10:20.000
    10616    \Loseless\Metallica\1988 - ...And Justice for All\01 - Blackened.flac    | Metallica |    | Metallica |     ...And Justice for All (Loseless)    | Metal |    |  |         Blackened    1    0    401    1988    0    0    0    0    0    0        UICY-94665
Brought to you by gubarenko.me    flac    Flac Audio        0    989    2    44100    0001-01-01 00:00:00.000    2014-06-25 00:49:30.000
    33634    \MP3\Bi-2\2010 - ...I korabl' plyvet\0101 - I korabl' plyvet.mp3    | Би-2 |    | Би-2 |     ...И корабль плывет.    | Rock |    | Лёва Би-2 | Шура Би-2 |         И корабль плывет    1    21    231    2010    0    0    0    0    1    2            mp3    MPEG Version 1 Audio, Layer 3    CBR    0    320    2    44100    0001-01-01 00:00:00.000    2014-12-29 21:59:35.000
    40477    \MP3\The Rolling Stones\1964 - 12 X 5\01 - Around and Around.mp3    | The Rolling Stones |    | The Rolling Stones |     12 X 5    | Rock |    |  |         Around and Around    1    8    185    1964    0    0    0    0    0    0            mp3    MPEG Version 1 Audio, Layer 3    CBR    0    128    2    44100    0001-01-01 00:00:00.000    2014-12-29 22:29:55.000
    23771    \Loseless\The Beatles\1973 - 1962-1966\The Beatles - Red Album  1962-1966 (CD 1).cue.fake.track.01.flac    | The Beatles |    | The Beatles |     1962-1966    | Rock |    |  |         Love Me Do    1    13    140    1973    1    0    0    0    1    0            flac    Flac Audio    CBR    0    800    2    44100    2015-06-29 16:20:50.000    1601-01-01 02:00:00.000
    23797    \Loseless\The Beatles\1973 - 1967-1970\The Beatles - Blue Album  1967-1970 (CD 1).cue.fake.track.01.flac    | The Beatles |    | The Beatles |     1967-1970    | Rock |    |  |         Strawberry Fields Forever    1    14    248    1973    0    0    0    0    1    0            flac    Flac Audio    CBR    0    846    2    44100    0001-01-01 00:00:00.000    1601-01-01 02:00:00.000
    34572    \MP3\Europe\1999 - 1982–2000\01 - In The Future To Come.mp3    | Europe |    | Europe |     1982 - 2000    | Hard Rock |    |  |         In The Future To Come    1    18    301    1999    0    0    0    0    0    0            mp3    MPEG Version 1 Audio, Layer 3    CBR    0    320    2    44100    0001-01-01 00:00:00.000    2014-12-29 22:02:21.000
    34555    \MP3\Europe\1993 - 1982-1992\01 - In The Future To Come.mp3    | Europe |    | Europe |     1982-1992    | Hard Rock |    | Joey Tempest |         In The Future To Come    1    17    301    1993    0    0    0    0    0    0            mp3    MPEG Version 1 Audio, Layer 3    CBR    0    320    2    44100    0001-01-01 00:00:00.000    2014-12-29 22:02:17.000
    24187    \MP3\Adriano Celentano\2005 - 20 Greatest Hits\01 - Una Rosa Pericolosa.mp3    | Adriano Celentano |    | Adriano Celentano |     20 Greatest Hits    | Pop |    |  |         Una Rosa Pericolosa    1    20    276    2005    1    0    0    0    0    0        ExactAudioCopy v0.99pb5    mp3    MPEG Version 1 Audio, Layer 3    CBR    0    320    2    44100    2017-01-17 23:01:23.000    2017-01-24 22:35:00.000
    ...
    I think sorting happens later, at the display stage in GUI. :):whistle::coffee:
     
    Last edited:

    sleepycol

    Portal Pro
    June 2, 2006
    536
    39
    United Kingdom United Kingdom
    Country flag
    Ok! Let's try to figure it out. :)

    Let's start with your music view settings.
    When you go to Music window you see:
    1. All Albums for All Artists and for All Album Artists in Artist order (Which is inconvenient but also does not make sense).
    How to sort Album by Artist in this situation: Album - Alambra, Artist - Wagner and Album - Wing, Artist - Andrew? Wing then Alambra? Or better, as usual, by name, Alambra then Wing ...
    2. Then you see all the discs for the selected album.
    3. Then you see all the songs for the selected album and for the selected disc.
    And when i try you view setting i have:
    View attachment 203454
    And as I understand it, what are you talking about the problem of sorting albums as in the screenshot?

    I make this Test music view:
    View attachment 203445
    And get:
    View attachment 203448 View attachment 203449

    When i switch Sort order by Artist i get:
    View attachment 203450
    And as I understand it, what are you talking about the problem of sorting albums as in the screenshot?

    Then i make this view:
    View attachment 203446
    And get:
    View attachment 203451 View attachment 203452 View attachment 203453

    But the best for me (like cd bookshelf) this View:
    View attachment 203447

    PS:
    If I understand the problem correctly, then I'll see where this sorting occurs, because At this stage, the following query works:
    SQL:
    select * from tracks  group by strAlbum, strAlbumArtist  order by strAlbum asc
    And result:
    Code:
    idTrack    strPath    strArtist    strAlbumArtist    strAlbum    strGenre    strComposer    strConductor    strTitle    iTrack    iNumTracks    iDuration    iYear    iTimesPlayed    iRating    iFavorite    iResumeAt    iDisc    iNumDisc    strLyrics    strComment    strFileType    strFullCodec    strBitRateMode    iBPM    iBitRate    iChannels    iSampleRate    dateLastPlayed    dateAdded
    36975    \MP3\Metallica\1988 - ... And Justice For All\01 - Blackened.mp3    | Metallica |    | Metallica |     ... And Justice For All    | Metal |    | James Hetfield | Jason Newsted | Lars Ulrich |         Blackened    1    9    403    1988    0    0    0    0    0    0            mp3    MPEG Version 1 Audio, Layer 3    CBR    0    320    2    44100    0001-01-01 00:00:00.000    2014-12-29 22:10:20.000
    10616    \Loseless\Metallica\1988 - ...And Justice for All\01 - Blackened.flac    | Metallica |    | Metallica |     ...And Justice for All (Loseless)    | Metal |    |  |         Blackened    1    0    401    1988    0    0    0    0    0    0        UICY-94665
Brought to you by gubarenko.me    flac    Flac Audio        0    989    2    44100    0001-01-01 00:00:00.000    2014-06-25 00:49:30.000
    33634    \MP3\Bi-2\2010 - ...I korabl' plyvet\0101 - I korabl' plyvet.mp3    | Би-2 |    | Би-2 |     ...И корабль плывет.    | Rock |    | Лёва Би-2 | Шура Би-2 |         И корабль плывет    1    21    231    2010    0    0    0    0    1    2            mp3    MPEG Version 1 Audio, Layer 3    CBR    0    320    2    44100    0001-01-01 00:00:00.000    2014-12-29 21:59:35.000
    40477    \MP3\The Rolling Stones\1964 - 12 X 5\01 - Around and Around.mp3    | The Rolling Stones |    | The Rolling Stones |     12 X 5    | Rock |    |  |         Around and Around    1    8    185    1964    0    0    0    0    0    0            mp3    MPEG Version 1 Audio, Layer 3    CBR    0    128    2    44100    0001-01-01 00:00:00.000    2014-12-29 22:29:55.000
    23771    \Loseless\The Beatles\1973 - 1962-1966\The Beatles - Red Album  1962-1966 (CD 1).cue.fake.track.01.flac    | The Beatles |    | The Beatles |     1962-1966    | Rock |    |  |         Love Me Do    1    13    140    1973    1    0    0    0    1    0            flac    Flac Audio    CBR    0    800    2    44100    2015-06-29 16:20:50.000    1601-01-01 02:00:00.000
    23797    \Loseless\The Beatles\1973 - 1967-1970\The Beatles - Blue Album  1967-1970 (CD 1).cue.fake.track.01.flac    | The Beatles |    | The Beatles |     1967-1970    | Rock |    |  |         Strawberry Fields Forever    1    14    248    1973    0    0    0    0    1    0            flac    Flac Audio    CBR    0    846    2    44100    0001-01-01 00:00:00.000    1601-01-01 02:00:00.000
    34572    \MP3\Europe\1999 - 1982–2000\01 - In The Future To Come.mp3    | Europe |    | Europe |     1982 - 2000    | Hard Rock |    |  |         In The Future To Come    1    18    301    1999    0    0    0    0    0    0            mp3    MPEG Version 1 Audio, Layer 3    CBR    0    320    2    44100    0001-01-01 00:00:00.000    2014-12-29 22:02:21.000
    34555    \MP3\Europe\1993 - 1982-1992\01 - In The Future To Come.mp3    | Europe |    | Europe |     1982-1992    | Hard Rock |    | Joey Tempest |         In The Future To Come    1    17    301    1993    0    0    0    0    0    0            mp3    MPEG Version 1 Audio, Layer 3    CBR    0    320    2    44100    0001-01-01 00:00:00.000    2014-12-29 22:02:17.000
    24187    \MP3\Adriano Celentano\2005 - 20 Greatest Hits\01 - Una Rosa Pericolosa.mp3    | Adriano Celentano |    | Adriano Celentano |     20 Greatest Hits    | Pop |    |  |         Una Rosa Pericolosa    1    20    276    2005    1    0    0    0    0    0        ExactAudioCopy v0.99pb5    mp3    MPEG Version 1 Audio, Layer 3    CBR    0    320    2    44100    2017-01-17 23:01:23.000    2017-01-24 22:35:00.000
    ...
    I think sorting happens later, at the display stage in GUI. :):whistle::coffee:

    Thanks for the replies, I do appreciate you helping me with this.

    If I sort by album name in your first suggestion, then the various artist albums will be all over the place and not grouped together.

    If I first have an artist sort as per your cd bookshelf settings, it will first show me an artist list in MP. That isn't strictly like a bookshelf as you always see the albums on the shelf. I didn't want to have an artist list first when viewing in MP, I wanted just to see straight to albums, like on a cd bookshelf.
     
    Last edited:

    Users Who Are Viewing This Thread (Users: 0, Guests: 1)

    OP Similar threads Forum Replies Date
    N How to shuffle all my music, and how to sort by album artist General 4
    B some music videos stutter Watch / Listen Media 0
    horned_reaper [solved] When playing music Fanart does not shuffle Fanart Handler 20
    horned_reaper [solved] When playing music Fanart does not appear immediately after downloading Fanart Handler 272
    horned_reaper [Music] 5012: Start current music track from the beginning Improvement Suggestions 37
    horned_reaper [solved] 5012: Restart current music track General Support 13
    atlantic How to use Spotify inside Mediaportal? Listen Music 18
    horned_reaper [solved] Music playback hangs General Support 58
    globaldonkey Music Database Error Listen Music 1
    joecrow Music on Headphones Listen Music 8
    2BitSculptor MP 1.23.. music stops playing General Support 6
    Sarxas What Music Are You Listening To? OffTopic 0
    Edwardfc [solved] Mp 2.2.1 Configuration Issues - Goes to Sleep while playing Music General 6
    G [fixed] [MP2-786] Party Music Player can only play playlists with less than 1000 items 2.2 Archive 7
    KlausWirn Music crash Bass crash no change to play music Installation, configuration support 2
    BlueMax1916 [confirm] Music: Every 2nd track skipped MediaPortal 2 30
    N Music player help Listen Music 4
    R MP 2.2 client spielt audio-titel kurz an und springt dann zum nächten Allgemeines Support- und Diskussionsforum 9
    joecrow Music: Fade Out not working 1.20 Pre Release 0
    M Music playback stops after certain files 1.19 0
    R Sort or restrict channels by group in mapping dialog Improvement Suggestions 4
    H [solved] Video database genres, sort titles and collection thumbnails Newcomers Forum 12
    Top Bottom