INTERACT FORUM

More => Old Versions => Media Center 15 (Development Ended) => Topic started by: Gl3nn on September 15, 2010, 09:23:25 am

Title: Album Ratings, Most-Played-Song, etc.
Post by: Gl3nn on September 15, 2010, 09:23:25 am
I've been building custom views (category views, listed as thumbnails) and I really liked seeing the Album Ratings flicker-by when hovering the mouse over the thumbnail text.  With the help I've received here in other threads, I added the 'average rating' and 'average number of plays' to the thumbnail text.  Very nice!

Is there a similar way to add the most-played song (which also scrolls by) in that particular album to the thumbnail text?  If so, I'm at a loss to define the expression.

And lastly, I presume we can't use this calculated Album Rating to actually sort the albums that way?  It's not a "real" calculated database field?
Title: Re: Album Ratings, Most-Played-Song, etc.
Post by: gappie on September 15, 2010, 10:48:29 am
the most played song as text under the album thumb is not possible.. i think.

but as far as my experience goes, when you have album thumbs and you sort by rating, it will sort by the album rating, the same is true with for instance number plays. but i think it does not work that way with last played...

 :)
gab
Title: Re: Album Ratings, Most-Played-Song, etc.
Post by: Vincent Kars on September 15, 2010, 03:32:43 pm
We need a couple of functions like MIN[Field], MAX[], SUM[], AVG[]
Title: Re: Album Ratings, Most-Played-Song, etc.
Post by: gappie on September 15, 2010, 04:08:11 pm
We need a couple of functions like MIN[Field], MAX[], SUM[], AVG[]
that would be sweet.. especially when it would know where to take the avg, etc from. and even much more if there would be a way to use those, or the existing ones, in thv.

 :)
gab
Title: Re: Album Ratings, Most-Played-Song, etc.
Post by: Vincent Kars on September 15, 2010, 05:17:46 pm
By default Album, otherwise Selected Tracks.
Just some plain SQL...
Title: Re: Album Ratings, Most-Played-Song, etc.
Post by: gappie on September 15, 2010, 06:14:59 pm
By default Album, otherwise Selected Tracks.
Just some plain SQL...
sure.. like plain sql as in r-db .
Title: Re: Album Ratings, Most-Played-Song, etc.
Post by: zxsix on September 15, 2010, 09:48:19 pm
We need a couple of functions like MIN[Field], MAX[], SUM[], AVG[]

There are times when I wish I had these available to me.  Chalk up another vote.
Title: Re: Album Ratings, Most-Played-Song, etc.
Post by: Gl3nn on September 16, 2010, 12:01:11 am
but as far as my experience goes, when you have album thumbs and you sort by rating, it will sort by the album rating, the same is true with for instance number plays. but i think it does not work that way with last played...

You're right again.  :)  Thanks much!!