INTERACT FORUM

More => Old Versions => Media Center 17 => Topic started by: locust on November 22, 2011, 01:45:20 pm

Title: Album Thumbnail View Search List
Post by: locust on November 22, 2011, 01:45:20 pm
Hi

In my view scheme that is listed by album thumbnail. My first pane consists of search lists..

I'd like to make a few new search lists but I am unsure whether or not they will function correctly..

I would like to make the following

Albums; Played the Least, Played the Most and possibly Top 100 Albums..
I've tried to make the first two but I've kept in mind that files are blind to each another so I am not sure it it even works correctly. It seems to look ok  but I doubt it..

I am not sure as to how a played the most album type view would work.. Because albums and eps can vary quite drastically in the total number of tracks, would it be best to calculate it by the combination of the play counts for every track, then divided by the total number of tracks.

Are there any other ways I could achieve these results.

I thought about making a custom field that would operate just like play count but album relational.. So it would increment the play count for every track when even one track is played, giving a play count.. I don't think would give an accurate representation of the top 100 albums, how far off I'm not sure. (I don't know it might be more fair depending of where you look at it from). I don't think I can make a field that increments, would it have to be a stock field?

Thanks
Title: Re: Album Thumbnail View Search List
Post by: MrC on November 22, 2011, 02:14:53 pm
... would it be best to calculate it by the combination of the play counts for every track, then divided by the total number of tracks.

This can't be done, since you can't obtain values cumulatively over tracks.

You can sort by Number Plays and from those tracks expand to a full album.
Title: Re: Album Thumbnail View Search List
Post by: Lasse_Lus on November 22, 2011, 02:21:45 pm
..but if you really want it, have a look @ prods "sqlmytunes" http://yabb.jriver.com/interact/index.php?topic=56405.0  :P
Title: Re: Album Thumbnail View Search List
Post by: locust on November 22, 2011, 02:25:01 pm
This can't be done, since you can't obtain values cumulatively over tracks.

You can sort by Number Plays and from those tracks expand to a full album.

I tried the expand to full album thing, it didn't seem to work that well, Thanks MrC

..but if you really want it, have a look @ prods "sqlmytunes" http://yabb.jriver.com/interact/index.php?topic=56405.0  :P

Does it work any good? I think I'll have to try that out..
Title: Re: Album Thumbnail View Search List
Post by: Lasse_Lus on November 22, 2011, 02:28:27 pm
Quote from: brian0001
Does it work any good? I think I'll have to try that out..

it's unlimited..in short you "dump" your MC data into a sql server where it's calculated the way you want then it's "pushed" back into MC
Title: Re: Album Thumbnail View Search List
Post by: locust on November 22, 2011, 02:34:54 pm
Thanks I have to check it out..