INTERACT FORUM

More => Old Versions => Media Center 14 (Development Ended) => Topic started by: winterminute on December 29, 2009, 08:57:42 pm

Title: Possible to create smartlist which compares column A against column B?
Post by: winterminute 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?

Title: Re: Possible to create smartlist which compares column A against column B?
Post by: Matt 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.