Ask / Submit

Change of order in Media Player [answered]

asked 2018-04-02 15:51:45 +0300

Lars Maria gravatar image

The Media Player in SFOS from version 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"

edit retag flag offensive reopen delete

The question has been closed for the following reason "the question is answered, an answer was accepted" by Lars Maria
close date 2018-04-02 16:38:53.725880


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

1 Answer

Sort by » oldest newest most voted

answered 2018-04-02 16:27:05 +0300

nthn gravatar image

Already asked here:

In short, your tags are broken. Music files can have two tags related to the date it was released, namely the 'date' tag and the 'originaldate'. The 'date' tag should be used to indicate the date this particular edition of the entire album was released, the 'originaldate' tag should be used to indicate the date that song was originally released. It sounds like you're using the 'date' tag where you should be using the 'originaldate' tag.

edit flag offensive delete publish link more

Question tools

1 follower


Asked: 2018-04-02 15:51:45 +0300

Seen: 154 times

Last updated: Apr 02 '18