INTERACT FORUM

More => Old Versions => Media Center 11 (Development Ended) => Topic started by: psiborg.ca on April 03, 2005, 08:57:56 pm

Title: Smartlist question.
Post by: psiborg.ca on April 03, 2005, 08:57:56 pm

After searching for a couple of hours in the forums I think I need some help from the smartlist experts...

I'd like a smartlist that shows all songs in my database by all artists that have at least 3 songs. If I were to use SQL it would look something like:
SELECT allSongs
GROUP BY artist, numTracks
HAVING count(numTracks) >= 3;

I'm basically just trying to weed out all of the 1 hit wonder artists that I seem to have so many of in my database.... Any ideas?

(currently using MediaCenter 10.0.173 registered)

Title: Re: Smartlist question.
Post by: risingdamp on April 04, 2005, 01:33:57 am

Sorry but not possible.

(If marko comes along with the answer I will be very upset  :(  )

Title: Re: Smartlist question.
Post by: marko on April 04, 2005, 02:38:24 am

I think you're right.

The closest I can get to this is to use the LIMIT function to list 4 tracks from every artist. for those that don't have 4 tracks it'll just show what it's got. sort them by artist and then manually weed out the bits you want.

[media type]=audio ~limit-1,4,[artist] ~sort=[artist]

not sure it's possible to get any closer than that. that search has just taught me that I have just one Acker Bilk track in my library. no prizes for guessing which one  ::)

-marko.

Title: Re: Smartlist question.
Post by: risingdamp on April 04, 2005, 02:57:04 am

Great track though.

de da, da da, da da da da da da.  De da da da da da.... da da da da da da da.. aaa.