My Artist filter doesn't work correctly

To get bugs in the current release fixed, please report them here.

Moderator: Gurus

roylayer
Posts: 85
Joined: Tue Feb 25, 2003 12:44 am

My Artist filter doesn't work correctly

Post by roylayer » Wed Feb 11, 2004 9:09 pm

Situation:
1) I right-click on the Artist node and select Filter.
2) I check the "Show just artists with songs which" box and click the "Set songs conditions" button.
3) Under the Advanced tab, I set the condition "Artist contains [radio]".
4) I click OK twice to apply the filter

Result: Nothing gets filtered. All artists are still displayed.

Hypothesis: Access uses the square brackets [] to denote a database field in its syntax. I suspect that my "[radio]" expression is messing up some query that is being built for the filter. (I've seen similar problems happen with embedded quote marks in other applications.)

I use brackets in my ID3 info for information that I want to include but which is not part of the actual field's value. For example, the name of a radio show is Alien Worlds. I enter Alien Worlds [radio] in my tags so that I can tell that this "artist" is really a radio show and not a musician when I'm looking at the artist node. I was also hoping to filter on it if I wanted the artist node to show ONLY radio shows.
Happy user of MediaMonkey Gold version 2.5.5.998
Computer: p4, 2.5 ghz, 3 gb ram, win xp

jiri
Posts: 5395
Joined: Tue Aug 14, 2001 7:00 pm
Location: Czech Republic
Contact:

Post by jiri » Thu Feb 12, 2004 4:06 am

Thanks for the report, that indeed doesn't work properly. You were quite close in your hypothesis, although not exactly right - the problem is in SQL 'like' operator, it assigns different meanings to '[', ']', '%' and '_' characters. It will be fixed in the next release, until then you can surround any of these four characters by '[' and ']'. This means that your string would look like '[[]radio[]]'.

Jiri

roylayer
Posts: 85
Joined: Tue Feb 25, 2003 12:44 am

Post by roylayer » Thu Feb 12, 2004 8:21 am

Thanks! This wasn't a huge deal for me, but I thought I should let you know about it.
Happy user of MediaMonkey Gold version 2.5.5.998
Computer: p4, 2.5 ghz, 3 gb ram, win xp

Post Reply