Print

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

[EpF]

I want to put a rule in a viewscheme which excludes all the tracks rated 2 or lower, but only by artists with an artist-rating of 1 (my own, custom field). Anyone know how to do that?

The viewscheme already has other exclusions in it, and I thought if I put brackets around the new rule pair like this:

( [Artist Rating]==1 -[Rating]=<=2 )

that it would work the way I wanted, but it didn't. 

[EpF]

Anyone? Marko?

[Deivit]

I would probably build a smartlist with the tracks rated 2 or lower by artists with the artist-rating of 1, and then exclude that smartlist from your wiew scheme rules, but hopefully Marko will come up with a better solution.

[marko]

Nice Deivit

so, a better way you say?

hmmm,

perhaps not better, but this works too, so here you go:

Create a new library field. Call it anything you like (for the purposes of this test, I called mine EpF), and perhaps hide it in the 'calculated' category (as it will be a calculated field)

The calculated data template will be:

if(isequal([artist rating],1,2),if(isequal([rating],2,2),hide,show),show)

Next, edit your viewscheme, and in step 4, add the exclusion:

-[EpF]=hide

============

[EpF]

Well gents, I'm surprised and gratified to discover that it's not as simple as I thought it would be! Thanks for your suggestions - I'll play around work something out. If it's any different to either of your solutions, I'll let you know.

[EpF]

I found a simple solution!

(([Artist Rating]==1 -[Rating]=<=2) or ([Artist Rating]=>1))

Then add all my other exclusions. It seems obvious now, but it was mighty confusing beforehand - Deivit's and Marko's solutions made me focus harder on the how's and why's. Thanks lads. 

[marko]

like it

away back when, I got into all kinds of trouble trying to understand how parenthesis was affecting things I gave up trying alltogether.

as I began to realise that MC provided more ways than one to get stuff done, I started to dig deeper and found other ways to do things that my brain could actually retain!!

I'm even having trouble translating your solution above :-|

(btw, I see you got that News Of The World cd too huh;) )





 

[EpF]

I'm even having trouble translating your solution above :-|

(
  ([Artist Rating]==1 -[Rating]=<=2) or
  ([Artist Rating]=>1)
)
The way it works is that each set of parenthesis gets processed as its own mini-smartlist, so that "-[Rating]=<=2" operates exclusively on "[Artist Rating==1", in the first inner set of parenthesis. Then the final results of that process are added to the results from the second set, as per normal "or" operation. By including the overall parenthesis I just made sure that all that was done before I added the other exclusions, such as no .cda files etc.

btw, I see you got that News Of The World cd too huh
 

LOL! Yeah, I got a bunch of them; some pretty dreadful stuff on some of them, but there's usually at least one song that makes it worth the €1 - except that after a while they all have the same stuff! I have 'Brown-Eyed Girl' by Van Morrison on 3 or 4 of them!
 

[marko]

thanks for the real-world example.
I got as far as the 'bob dylan' examples in the helpfile, where it says that this is not the same as that, you know, but it didn't proceed to spell out why. I'm willing to bet I could employ these efficiently in many areas of my library.

I got those darn things for free from my work (a perk? perhaps not;))