Feature Request following this discussion thread > Dashboard reporting play history tracks from different albums to what was actually played
Currently plex will store the track ID and artist ID in the play history table but does not store album ID. To see this play a track and then query the metadata_item_views table afterwards. Example below …
sqlite> SELECT * from metadata_item_views WHERE id = 20705;
id account_id guid metadata_type library_section_id grandparent_title parent_index parent_title index title thumb_url viewed_at grandparent_guid originally_available_at device_id
----- ---------- ------------------------------------- ------------- ------------------ ----------------- ------------ --------------- ----- ------------ --------- ---------- -------------------------------------- ----------------------- ---------
20705 1 plex://track/5d07cdbe403c640290f5d5fe 10 3 Kate Bush 1 The Whole Story 2 Cloudbusting 1657032157 plex://artist/5d07bbfd403c6402904a65ce 94
sqlite>
So why is this a problem. Well, full details are in post Dashboard reporting play history tracks from different albums to what was actually played but for summary I’ll quote from @OttoKerner
When a track is played, only its numerical track ID is stored. The same track ID can occur in several albums.
When a list of played tracks is compiled, Plex simply uses the album information of the first occurrence of the same track ID in the database. It doesn’t necessarily have to be the album from which you have actually played this track.
This then causes problems with the album in the dashboard report as per my other post.
Please consider adding this information to improve over all stats for play history …
