INTERACT FORUM

Please login or register.

Login with username, password and session length
Advanced search  
Pages: [1]   Go Down

Author Topic: Album Ratings, Most-Played-Song, etc.  (Read 1929 times)

Gl3nn

  • Galactic Citizen
  • ****
  • Posts: 384
Album Ratings, Most-Played-Song, etc.
« 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?
Logged

gappie

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 4580
Re: Album Ratings, Most-Played-Song, etc.
« Reply #1 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
Logged

Vincent Kars

  • Citizen of the Universe
  • *****
  • Posts: 1154
Re: Album Ratings, Most-Played-Song, etc.
« Reply #2 on: September 15, 2010, 03:32:43 pm »

We need a couple of functions like MIN[Field], MAX[], SUM[], AVG[]
Logged

gappie

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 4580
Re: Album Ratings, Most-Played-Song, etc.
« Reply #3 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
Logged

Vincent Kars

  • Citizen of the Universe
  • *****
  • Posts: 1154
Re: Album Ratings, Most-Played-Song, etc.
« Reply #4 on: September 15, 2010, 05:17:46 pm »

By default Album, otherwise Selected Tracks.
Just some plain SQL...
Logged

gappie

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 4580
Re: Album Ratings, Most-Played-Song, etc.
« Reply #5 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 .
Logged

zxsix

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 1753
Re: Album Ratings, Most-Played-Song, etc.
« Reply #6 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.
Logged

Gl3nn

  • Galactic Citizen
  • ****
  • Posts: 384
Re: Album Ratings, Most-Played-Song, etc.
« Reply #7 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!!
Logged
Pages: [1]   Go Up