Change of order in Media Player [answered]
asked 2018-04-02 15:51:45 +0300
The Media Player in SFOS from version 2.1.4.14 is ordering the music albums after year instead of alphabetically after album title.
I can see the logic in that, but suddenly every Greatest Hits-album I have, and where I've tagged the songs individually with the year they were originally released, are now scattered all over the album view into as many 'albums' as different year tags.
I'm guessing there's a kind of ORDER BY on all songs' year tags that does it? And I'm thinking: is it possible to, instead, do the ORDER BY only on the one (1) year tag with the highest value in an album?
Either all songs in an album have the same year tag, so it should be all the same. Or, almost every song in a Greatest Hits album has a different year tag, but if you ORDER BY only on the one (1) year tag with the highest value, the Greatest Hits album should show up as one album. It might come in the "wrong" place in the order of albums of the same artist, because the album was not released the same year as the latest song on it, but I can live with that.
I'm not King of SQL, so I don't know if this is possible, or how to do it in that case, but is it possible to do something like:
SELECT MAX("YearTag") AS "YearOrder" ... ... ... ORDER BY "YearOrder"
Oh, this change in the Media Player made life so much easier for all of us ... We only need to re-tag our entire music collection for no reason or benefit at all. But hey, of course they had nothing else to do. I mean - could anyone think of any other parts of the OS that would require some love and attention instead?
ossi1967 ( 2018-04-02 22:53:26 +0300 )edit