INTERACT FORUM

Please login or register.

Login with username, password and session length
Advanced search  
Pages: [1]   Go Down

Author Topic: Expression help: How do I write 'is not in the range' ?  (Read 971 times)

wig

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 750
Expression help: How do I write 'is not in the range' ?
« on: January 04, 2012, 08:38:39 am »

I'm trying to use an 'AND' rule in a mix expression. I want to do something like this,

([Date]=<3y [Bitrate]=1-128)

But I want to exclude the Bitrate range instead of include it. The exclude search term "-" doesn't seem to work with a integer range.

This is just an example, btw. I'm actually working with a custom Integer field but trying to achieve the same result.

Any ideas?


Logged

mark_h

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 1854
Re: Expression help: How do I write 'is not in the range' ?
« Reply #1 on: January 04, 2012, 09:33:38 am »

just use two bitrate rules that specify exclusion range...
Logged

MrC

  • Citizen of the Universe
  • *****
  • Posts: 10462
  • Your life is short. Give me your money.
Re: Expression help: How do I write 'is not in the range' ?
« Reply #2 on: January 04, 2012, 12:13:53 pm »

Technically not in the range of 1-128 would be all bitrates greater than 128. 

   ([Date]=<3y [Bitrate]=>128)

Unless you're worried about bitrates of 0, so you can use OR:  bitrate < 1 or bitrate > 128

   [Date]=<3y ([Bitrate]=<1 or [Bitrate]=>128)

Another more meaningful example of bitrate not in the range of 128 to 320:

   [Date]=<3y ([Bitrate]=<128 or [Bitrate]=>320)
Logged
The opinions I express represent my own folly.

wig

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 750
Re: Expression help: How do I write 'is not in the range' ?
« Reply #3 on: January 04, 2012, 12:36:27 pm »

Unless you're worried about bitrates of 0, so you can use OR:  bitrate < 1 or bitrate > 128

   [Date]=<3y ([Bitrate]=<1 or [Bitrate]=>128)


That's the winner for me. It's actually a custom rating system I use, and I want to include unrated tracks (0 values).

Thanks for the patience and the help, MrC. You too, mark_h.

 

Logged
Pages: [1]   Go Up