Query/title format to get the last time an album was played, if some tracks can be played separetely Options

[r0k]

Hello. My library is still organized the old-way by albums (ripped CDs) and i often play albums rather than playlists. However, i also have random pools active to select tracks/albums when i don't want to worry about selecting something manually. This means i can have an album that i didn't play for the last 3 months, but have one track on that albums that was played 2 days ago.

foo_playcount does only store per-tracks data so i don't have an easy way to know when was the last time the entire album was played. I searched for some way to do this with query syntax, but can't find any way to get the oldest of all the last played entries for an album. I'm missing something similar to the aggregate functions of SQL. Maybe i overlooked something.

Is there a way to do this with querry syntax and/or title format scripts. I know i can do this with SQL tree but i'd like to be able to get this information anywhere and not just in one component.

[marc2003]

but can't find any way to get the oldest of all the last played entries for an album

it's probably possible to do this with WSH panel mod. it could loop through every track in a playlist and display the earliest play date for each album. i might be able to knock something up if you're interested.