INTERACT FORUM

Please login or register.

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

Author Topic: Possible to create smartlist which compares column A against column B?  (Read 850 times)

winterminute

  • Junior Woodchuck
  • **
  • Posts: 61
Possible to create smartlist which compares column A against column B?
« on: December 29, 2009, 08:57:42 pm »
Some of my metadata is messed and the easiest way to figure out which songs need to be fixed is to run a query which is basically: Show me all the songs where (Artist != AlbumArtist) & AlbumArtist != "Various Artists".  I didn't see an easy way to compare columns like this, is this possible in MC?
Logged

Matt

  • Administrator
  • Citizen of the Universe
  • *****
  • Posts: 42373
  • Shoes gone again!
Re: Possible to create smartlist which compares column A against column B?
« Reply #1 on: December 29, 2009, 09:09:23 pm »
This search will give you all songs where album artist and artist are different:
[=IsEqual([Artist], [Album Artist])]=[0]

This is called 'expressions'.  The link to the wiki above will have more information about some of the things you can do with them.
Logged
Matt Ashland, JRiver Media Center
Pages: [1]   Go Up
« previous next »