Print

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

[MusicBringer]

Hello,
I have a playlist of 1000+ tracks.
How can I tell how many Artists are in there ❓
thanks,

[zybex]

Services & Plugins -> Reporter

[MusicBringer]

Thanks zybex,
Yes I know that Reporter is  there.
My question is How many Artists are in my Playlist?

[zybex]

Sorry, I misread and thought you wanted the total count for your entire library.
For a single playlist... hmm...

> SELECT COUNT(distinct Artist) from files F where F.Playlists like '%my playlist%'
error: non-relational DB

Damn. This probably requires some global variable magic, I'll leave this for someone else 

Well, actually you may get a quick answer with this on the Search box:

Code: [Select]

~nodup=Artist
This will pickup one file per Artist, so the number of files on the resulting list is your answer.
Note that 'ArtistA; ArtistB' counts as 1, and 'ArtistB; ArtistA' also counts as 1 and is different from the first.

[MusicBringer]

~nodup=Artist

Whoopee! By George, I think he’s got it!
For example it has found I have J.J. Cale and J.J.Cale.
Many thanks zybex, just what I wanted 🙂👍

[blgentry]

An alternative solution:

Build a new Panes view.  Add the following panes to it:

Playlist group: Root of all playlists
Artist
Album

Now to use it, just scroll through the playlists pane and click on a playlist name.  You'll see that the Artist and Album columns now have a count in (parenthesis) that shows the total in the playlist you have selected.  Count of artists, count of albums.  You can add more columns if it's interesting to you like Genre, etc.  This is a nice way of working with playlists in general.

Brian.

[MusicBringer]

This is a nice way of working with playlists Brian.

Brian, nice. Very nice thank you.