Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[vbphil]

I was reminded of query reports from my old SQL report writing days.

I'd like to have a list showing the 'count' of how many Songs for each Artist are rated greater than 3 stars, sorted by the count, so the Artist with the most are at the top of the list. Given that, I'd want to see what the Songs are and on what Albums.

I've played around with some expressions but only manage to lock up Media Center and I'm not really sure what View to use. I've tried Panes which is probably the likely place for the view.

Any help would be appreciated.  Thanks,   -phil

[vbphil]

I found out what to do in the Wiki under grouping functions. https://wiki.jriver.com/index.php/Grouping_Functions

Also, this Library I used only had songs rated 4 or 5 stars so I didn't have to worry about filtering that part and could just use the whole library.

I added an empty View under Audio and configured it with the grouping function from the Wiki example with some slight modifications.
GroupCountQuery(album artist /(auto/), name) Songs

It works okay for what I wanted to see. Could probably use some enhancements.
Who knew Pink Floyd has the most songs in my Library and that I really had 46 James Taylor songs that I liked.

See attachments for configuration.