View Issue Details

IDProjectCategoryView StatusLast Update
0018911MediaMonkey 5Main Panel: Toolbars & Menuspublic2022-04-07 16:09
Reporterpeke Assigned To 
PriorityurgentSeveritytweakReproducibilityalways
Status assignedResolutionopen 
Target Version5.1 
Summary0018911: Sorting: In Grid views there is no Sort by average rating and album sort by date is not visually presented
Description1. In Grid views there is no Sort by average rating.

2. If user Sort by date there is no way to see Album Year eg. I would expect that Album name is shown like "Album Name (Album Year)" or "Albu... (Album Year)" if album name is too long.
Additional Informationhttps://www.mediamonkey.com/forum/viewtopic.php?t=101490
TagsNo tags attached.
Fixed in build

Activities

barrym

2022-03-07 07:08

reporter   ~0067211

If you did that would you stop there?
Sort by other aggregate functions would equally useful; eg. mostly mean(date last played) and max(date added), but also mean(play count),

peke

2022-03-07 15:23

developer   ~0067213

Last edited: 2022-03-07 22:57

View 2 revisions

If you are in Grid Album view info that you have is Album Art, Rating, Album Name, Album Artist so last played, date added, play count do not have meaning as info is not available, but you ar eright we should consider allowing Grid sort by all Visible information.

Will leave Petr to triage if he likes that idea.

barrym

2022-03-07 15:53

reporter   ~0067214

Don't get your point.
Added, and the Play attributes are the same as Rating and Genre.
Ie. They are all assigned at the individual track level.
None if them are Album attributes, which is why are talking about Averages and Means etc.

peke

2022-03-07 22:56

developer   ~0067215

Not sure what is not Understandable.
Other starts are not seen and as you check only Avg. Rating is missing.

Only other thing that is possibly Missing is "Album Name (Album Year)" in view so that when you sort by date you can visually see sorting.
image.png (42,871 bytes)   
image.png (42,871 bytes)   

barrym

2022-03-08 02:03

reporter   ~0067216

What is not understandable is this:
You support modification to sort album grid by Rating.
But you don't support sort by Date Last Played, or Play Count, or Date Added ... because this info is not available at the album level.

I am saying that they are the same as Rating.
Rating is not available at the album level either.
I don't know of any way to set Album level Rating, other than setting it at the individual track level.
The database has nowhere that album level rating is stored (AFAIK)
So Album Rating is an on-the-fly aggregate function of its tracks.

Don't that mean that all of these things are equally doable?

One other thing: there is value in sorting the Grid even if the value used for the sort sequencing is not visible.
eg. If I sort the Album Grid to descending max(Date Added) ... I don't need to see that actual dates, and in fact they would be distraction ... all I would be wanting to achieve would be a grid of my albums, where my newer rips would be towards the top.

petr

2022-03-15 11:30

developer   ~0067304

Last edited: 2022-03-15 11:36

View 3 revisions

Problem with these computed fields (incl. rating) is that it's loaded asynchronously just for the albums currently in sight (so it's not loaded for all albums in the grid at a time) and sorting performance by this kind of fields can be very slow (incl. grid update).

Also computed values mentioned by Barry makes sense to me.

barrym

2022-03-15 13:44

reporter   ~0067310

petr: "Problem with these computed fields (incl. rating) is that it's loaded asynchronously just for the albums currently in sight (so it's not loaded for all albums in the grid at a time) and sorting performance by this kind of fields can be very slow (incl. grid update)."

I understand. Thanks for explaining.

MM4 offered album grid sort by rating.
How did that work?

IMO the real problem is that these are left as computed fields. It would be better of they were stored fields in the Albums table.
ie. an update trigger on Songs update, where rating, playcount or date last played were altered.
I see that the Albums table already has a date last played attribute for video media

The benefits would be:
* enhancement to Grid by Album sorting|filtering
* enhancement to List By Album sorting|filtering on these attributes without breaking apart the album
* create Collections and playlists using these album level attributes

petr

2022-03-15 15:20

developer   ~0067313

We can add them to the Albums table and update values using triggers