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

ajs

Development Group
  • Team MediaPortal
  • February 29, 2008
    15,492
    10,366
    Kyiv
    Home Country
    Ukraine Ukraine
    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
    15,492
    10,366
    Kyiv
    Home Country
    Ukraine Ukraine
    What view settings yuo have? I still dont understand you problem :(

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

    sleepycol

    Portal Pro
    June 2, 2006
    538
    39
    Home Country
    United Kingdom United Kingdom
    What view settings yuo have? I still dont understand you problem :(

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

    The attached screengrab shows the problem and where the disc should be listed correctly.....

    Other attachment shows this needs a secondary sort to sort by album name
     

    Attachments

    • Correct position.JPG
      Correct position.JPG
      481.4 KB
    • MPSettings.png
      MPSettings.png
      44.8 KB
    Last edited:

    sleepycol

    Portal Pro
    June 2, 2006
    538
    39
    Home Country
    United Kingdom United Kingdom
    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
    15,492
    10,366
    Kyiv
    Home Country
    Ukraine Ukraine
    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
    538
    39
    Home Country
    United Kingdom United Kingdom
    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

    Top Bottom