home
products
contribute
download
documentation
forum
Home
Forums
New posts
Search forums
What's new
New posts
All posts
Latest activity
Members
Registered members
Current visitors
Donate
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Search titles only
By:
Menu
Log in
Register
Navigation
Install the app
Install
More options
Contact us
Close Menu
Forums
MediaPortal 1
Development
Improvement Suggestions
Music "sort by" AlbumArtist
Contact us
RSS
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="ajs" data-source="post: 1265327" data-attributes="member: 68833"><p>Ok! Let's try to figure it out. <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":)" title="Smile :)" loading="lazy" data-shortname=":)" /></p><p></p><p>Let's start with your music view settings.</p><p>When you go to Music window you see:</p><p>1. <strong>All Albums</strong> for All Artists and for All Album Artists in <strong>Artist order</strong> (Which is inconvenient but also does not make sense).</p><p>How to <strong>sort Album by Artist</strong> in this situation: Album - <strong>Alambra</strong>, Artist - <strong>Wagner </strong>and Album - <strong>Wing</strong>, Artist - <strong>Andrew</strong>? <strong>Wing </strong>then <strong>Alambra</strong>? Or better, as usual, by name, <strong>Alambra </strong>then <strong>Wing </strong>...</p><p>2. Then you see all the discs for the selected album.</p><p>3. Then you see all the songs for the selected album and for the selected disc.</p><p>And when i try you view setting i have:</p><p>[ATTACH]203454[/ATTACH]</p><p>And as I understand it, what are you talking about the problem of sorting albums as in the screenshot?</p><p></p><p>I make this Test music view:</p><p>[ATTACH]203445[/ATTACH]</p><p>And get:</p><p> [ATTACH]203449[/ATTACH]</p><p></p><p>When i switch Sort order by Artist i get:</p><p>[ATTACH]203450[/ATTACH]</p><p>And as I understand it, what are you talking about the problem of sorting albums as in the screenshot?</p><p></p><p>Then i make this view:</p><p>[ATTACH]203446[/ATTACH]</p><p>And get:</p><p>[ATTACH]203451[/ATTACH] [ATTACH]203452[/ATTACH] [ATTACH]203453[/ATTACH]</p><p></p><p>But the best for me (like cd bookshelf) this View:</p><p>[ATTACH]203447[/ATTACH]</p><p></p><p><strong>PS:</strong></p><p>If I understand the problem correctly, then I'll see where this sorting occurs, because At this stage, the following query works:</p><p>[CODE=SQL]select * from tracks group by strAlbum, strAlbumArtist order by strAlbum asc[/CODE]</p><p>And result:</p><p>[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</p><p>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</p><p>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</p><p>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</p><p>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</p><p>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</p><p>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</p><p>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</p><p>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</p><p>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</p><p>...[/code]</p><p>I think sorting happens later, at the display stage in GUI. <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":)" title="Smile :)" loading="lazy" data-shortname=":)" /><img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite27" alt=":whistle:" title="Whistling :whistle:" loading="lazy" data-shortname=":whistle:" /><img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite29" alt=":coffee:" title="Coffee :coffee:" loading="lazy" data-shortname=":coffee:" /></p></blockquote><p></p>
[QUOTE="ajs, post: 1265327, member: 68833"] 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. [B]All Albums[/B] for All Artists and for All Album Artists in [B]Artist order[/B] (Which is inconvenient but also does not make sense). How to [B]sort Album by Artist[/B] in this situation: Album - [B]Alambra[/B], Artist - [B]Wagner [/B]and Album - [B]Wing[/B], Artist - [B]Andrew[/B]? [B]Wing [/B]then [B]Alambra[/B]? Or better, as usual, by name, [B]Alambra [/B]then [B]Wing [/B]... 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: [ATTACH]203454[/ATTACH] 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: [ATTACH]203445[/ATTACH] And get: [ATTACH]203449[/ATTACH] When i switch Sort order by Artist i get: [ATTACH]203450[/ATTACH] And as I understand it, what are you talking about the problem of sorting albums as in the screenshot? Then i make this view: [ATTACH]203446[/ATTACH] And get: [ATTACH]203451[/ATTACH] [ATTACH]203452[/ATTACH] [ATTACH]203453[/ATTACH] But the best for me (like cd bookshelf) this View: [ATTACH]203447[/ATTACH] [B]PS:[/B] If I understand the problem correctly, then I'll see where this sorting occurs, because At this stage, the following query works: [CODE=SQL]select * from tracks group by strAlbum, strAlbumArtist order by strAlbum asc[/CODE] 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 ...[/code] I think sorting happens later, at the display stage in GUI. :):whistle::coffee: [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
MediaPortal 1
Development
Improvement Suggestions
Music "sort by" AlbumArtist
Contact us
RSS
Top
Bottom