INTERACT FORUM

More => Old Versions => JRiver Media Center 23 for Windows => Topic started by: broncodan on August 06, 2018, 02:09:26 pm

Title: smartlist or view to show artists that have more than x number of rated songs
Post by: broncodan on August 06, 2018, 02:09:26 pm

Hi,

I think this was asked about a long time ago but with all the new changes maybe there is now a way that this can be done - I would like to either create a veiw or playlist that shows all artists that have x number of songs with ratings?  Ultimately I would like to create either a smartlist template or an sql query that could determine which artist in my collection has 10 songs that have ratings, remove the duplicate songs, and present a list. 

Title: Re: smartlist or view to show artists that have more than x number of rated songs
Post by: mark_h on October 15, 2018, 03:42:51 am

Any good?

([Media Type]=[Audio] -[Rating]=0 [=save(0,var_artist_votes[artist])1]=1 [=saveadd(var_artist_votes[artist],1)1]=1) [=compare(load(var_artist_votes[artist]),>,9)]=1 ~nodup=[Artist],[Name]