Tagnavi_custom.config: last played

[SoulSkorpion]

I'm trying to create a custom database view where it shows only songs that I haven't heard in the last four days. Looking at the existing items in the tagnavi.config, my understanding is that it can access the last played time, but I can't figure out the syntax from the examples there. I tried looking at the wiki and I see that the lastplayed tag is available, but the comment of "Incremental number. Works, but not sorted correctly when used in filter" is cryptic and unhelpful.

Google and forum searches for tagnavi syntax haven't turned anything up, other than posts from 2006 saying that it's still experimental. Any hints about how the syntax works in this department would be greatly appreciated.

[roolku]

I'm trying to create a custom database view where it shows only songs that I haven't heard in the last four days.

Not currently possible, as the DB doesn't store the time stamp when a song was last played (not useful for targets without RTC)

I wrote a patch once: http://www.rockbox.org/tracker/task/6301 (6_dayssince.patch - doesn't apply anymore) for that but abandoned the idea as I didn't find it very useful.

and I see that the lastplayed tag is available, but the comment of "Incremental number. Works, but not sorted correctly when used in filter" is cryptic and unhelpful.

Well, there is a number that increments whenever a song is played and is assigned to that songs lastplayed field. Feel free to clarify the wiki.

[bascule]

Unfortunately, there is no 'Real-Time' information stored in the database, only 'relative' (either to now or to the last database update).

A quick 101 on the lastplayed tag, as used in the default Database config:

Code: [Select]

%format "fmt_lastplayed"  "%06d%s - %s" lastplayed artist title %sort = "inverse" %limit = "99" %strip = "6"

This formatting string uses (but strips from view) the lastplayed value to create a list of tracks in the order in which they were listened to.
It then inverts it, to display the most recent first.
It then limits it to 99 tracks

Code: [Select]

"Recently played tracks" -> title = "fmt_lastplayed" ? playcount > "0"

This database menu item then uses the formatting string defined above to choose the tracks, in this case going directly to the track title.
The conditional 'playcount > "0" ensures that tracks that have never been listened to are excluded.
This is necessary because the lastplayed value for all non-listened-to tracks is zero and they can show up in the listing if not explicitly taken out.

So, to plainly answer your question, no, you can't specify by actually how long ago you last listened to them, only relatively how long ago compared to all the tracks you have listened to.

[Job Van Dam]

I'm wondering is it possible to show the number of tracks in each genre?

[bascule]

Not as far as I know...

[SoulSkorpion]

Unfortunately, there is no 'Real-Time' information stored in the database, only 'relative' (either to now or to the last database update).

So, to plainly answer your question, no, you can't specify by actually how long ago you last listened to them, only relatively how long ago compared to all the tracks you have listened to.

Oh right. Thanks.

%format "fmt_lastplayed"  "%06d%s - %s" lastplayed artist title %sort = "inverse" %limit = "99" %strip = "6"

This was the part I couldn't work out. It looks a bit like a sprintf string... ah, and there are three fields after it that get substituted in, right? I didn't realise that lastplayed was just a digit, and I was trying to figure out how the format string could contain a date.

What causes these details to be stripped from view or is that automatic?

[pabouk]

What causes these details to be stripped from view or is that automatic?

The part '%strip = "6"' removes the first 6 characters from the view. Unfortunately it is not possible to strip a variable number of character using something like regular expressions.

Please read the documentation Wiki - DataBase and/or Daily Built Manuals.

[bascule]

... ah, and there are three fields after it that get substituted in, right?

What causes these details to be stripped from view or is that automatic?

Yes for substitution. Each %whatever token is rendered using the respective tag in the subsequent text.

I was hoping that by using the phrase '...formatting string uses (but strips from view)...' that the reader would automatically associate the %strip token as the one doing that function...  

* bascule ...must ...try ...harder to be understood

[SoulSkorpion]

I was hoping that by using the phrase '...formatting string uses (but strips from view)...' that the reader would automatically associate the %strip token as the one doing that function...  

* bascule ...must ...try ...harder to be understood

Well, if it helps, what I initially thought that part meant was that it would strip out the sixth arg of something. Seeing as there were only three fields being operated on, that confused me