INTERACT FORUM

Please login or register.

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

Author Topic: I need a filter for files where Artist not equal to Band  (Read 1049 times)

DaremoS

  • World Citizen
  • ***
  • Posts: 151
  • Rock is not just music... is a way of living
I need a filter for files where Artist not equal to Band
« on: December 07, 2007, 12:47:30 pm »

I've been trying to create a search / filter / playlist to show files where Artist field is different than Band field.

Anybody knows how to do this?
Logged

Matt

  • Administrator
  • Citizen of the Universe
  • *****
  • Posts: 42344
  • Shoes gone again!
Re: I need a filter for files where Artist not equal to Band
« Reply #1 on: December 07, 2007, 12:52:14 pm »

One easy way is to:

1) Right-click the column headers on any view (or use the view header menu)
2) Pick Columns > Add Expression Column...
3) Type this for the expression:
IsEqual([Artist], [Band])
4) Sort by the column -- "1" means they're the same
Logged
Matt Ashland, JRiver Media Center

Doof

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 5908
  • Farm Animal Stupid
Re: I need a filter for files where Artist not equal to Band
« Reply #2 on: December 07, 2007, 01:35:15 pm »

One easy way is to:

1) Right-click the column headers on any view (or use the view header menu)
2) Pick Columns > Add Expression Column...
3) Type this for the expression:
IsEqual([Artist], [Band])
4) Sort by the column -- "1" means they're the same

You could also set that up as a database field, then create a smartlist that only shows files where that field = 1.
Logged

Matt

  • Administrator
  • Citizen of the Universe
  • *****
  • Posts: 42344
  • Shoes gone again!
Re: I need a filter for files where Artist not equal to Band
« Reply #3 on: December 07, 2007, 06:58:50 pm »

You can also just type this search, based on the same expression:
[=IsEqual([Artist], [Album])]=[1]
Logged
Matt Ashland, JRiver Media Center

Doof

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 5908
  • Farm Animal Stupid
Re: I need a filter for files where Artist not equal to Band
« Reply #4 on: December 08, 2007, 12:49:21 am »

You can also just type this search, based on the same expression:
[=IsEqual([Artist], [Album])]=[1]

YM
[=IsEqual([Artist], [Band])]=[1]
HTH!
Logged
Pages: [1]   Go Up