IPB

Welcome Guest ( Log In | Register )

> foobar2000 General Forum Rules

This is NOT a tech support forum.
Tech support questions go to foobar2000 Tech Support forum instead.

See also: Hydrogenaudio Terms of Service.

Query/title format to get the last time an album was played, if some tracks can be played separetely
r0k
post Oct 9 2012, 10:50
Post #1





Group: Members
Posts: 74
Joined: 8-September 11
Member No.: 93574



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.
Go to the top of the page
+Quote Post
 
Start new topic
Replies
derty2
post Oct 9 2012, 11:43
Post #2





Group: Members
Posts: 581
Joined: 5-June 11
Member No.: 91257



I don't know if this is the exact answer you want but it may be helpful (I use CUI interface)...

If we assume that entire album == directory containing a set of files

and we have a Filter panel in our layout for library viewing

then we can create some views like these:

History Last Played (Directory Path), by Day
QUOTE
$cut(%last_played%,10)''$directory_path(%path%)

History Last Played (Directory Path), by Day-Time
QUOTE
$cut(%last_played%,10)-$replace($time(%last_modified%),' ',,'-',,':',)''$directory_path(%path%)


This post has been edited by derty2: Oct 9 2012, 12:06
Go to the top of the page
+Quote Post

Posts in this topic


Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 



RSS Lo-Fi Version Time is now: 20th August 2014 - 08:43