can MediaMonkey do "OR" searches too?

[pomozki]

Hi folks, I'm new to this and MM - I'd love some advice about doing searches in MM. sorry, haven't any files to attach but I'll explain...
I'm using MM Gold.
I'm doing Ctrl-F (Search) ... then going to the advanced tab
It then asks you to add search criteria.
I can do easy searches (e.g. show me only genre = ROCK and date = 1975 ... and I get heaps of songs showing up
but how do I ask for music from, say, 1975 that's either ROCK or POP?

It's the genre filter I'm having trouble with and it's really important to me: I've tried genre "equals" - but as soon as you do that, it only allows you to pick from a dropdown list of genres you already have in your library - so for me it allows songs whose genre is rock...or whose genre is pop ... or whose songs are rock AND pop
but so far I haven't worked out how to filter songs whose genre is either rock or pop or something else
I've tried
genre contains rock or pop
and
genre contains "rock" or "pop"
and
genre contains 'rock' or 'pop'
but none of them works

hope someone can put me right, many thanks Alan

[Kalle]

Hi folks, I'm new to this and MM - I'd love some advice about doing searches in MM. sorry, haven't any files to attach but I'll explain...
I'm using MM Gold.
I'm doing Ctrl-F (Search) ... then going to the advanced tab
It then asks you to add search criteria.
I can do easy searches (e.g. show me only genre = ROCK and date = 1975 ... and I get heaps of songs showing up
but how do I ask for music from, say, 1975 that's either ROCK or POP?

It's the genre filter I'm having trouble with and it's really important to me: I've tried genre "equals" - but as soon as you do that, it only allows you to pick from a dropdown list of genres you already have in your library - so for me it allows songs whose genre is rock...or whose genre is pop ... or whose songs are rock AND pop
but so far I haven't worked out how to filter songs whose genre is either rock or pop or something else
I've tried
genre contains rock or pop
and
genre contains "rock" or "pop"
and
genre contains 'rock' or 'pop'
but none of them works

hope someone can put me right, many thanks Alan

Hi Alan, welcome in VoxCommando-Forum. I'm not sure If I understand you right, you will do a search in MM for "genre" from "year"?
like - "play rock from year 1990"
Important for us is: What version of VoxCommando do you use?

Kalle

[jitterjames]

Hi Alan,

please don't take this the wrong way, but...  what does this have to do with VoxCommando?

[jitterjames]

also, I'm not sure but it might help to know if you are using MM3 or MM4

[jitterjames]

anyway on MM4 this is how you do it.  I don't have MM3 installed any more but hopefully it works about the same.

You just have to put checkboxes in all the genres that are acceptable and it will "or" them since it usually doesn't make much sense to "and" genres.

[Kalle]

Hi Alan,

please don't take this the wrong way, but...  what does this have to do with VoxCommando?

Hi James, I think it has nothing to do with VC  
But it is a nice question, how can do it "play genre from year" with VC?   (MM4)

Kalle

[jitterjames]

actually I don't even know how to search by year in MediaMonkey because there seems to be confusion between Date and Year.  Most of my songs have only a year as the date but some have a bull date with date, month and year.  Mediamonkey stores this as a long number.  If the date is set to 2000 then the database will store it as 20000000.  If the date is set to February 13th 1996 is it is stored as the number 19960213.

If they used a string it would be easier since we could use LIKE in our SQL:

  Year like '1996%'

would work fine.

as it is though, because it is a number, we need to be trickier and use this:

Year>=19960000 and Year<19969999

(note that we use >= so we will get all the songs marked as 1996 with no full date, because they are stored as 19960000

Now to use payloads you can change this to
Year>={1}0000 and Year<{1}9999

or in the case of your example Kallle using genre as the first payload:

genre like '%{1}%' and Year>={2}0000 and Year<{2}9999

and that works, but if you ask for genre "rock" you will also get "folk rock" etc...  getting the exact genre is another difficulty which has already been discussed I think.

[Kalle]

actually I don't even know how to search by year in MediaMonkey because there seems to be confusion between Date and Year.  Most of my songs have only a year as the date but some have a bull date with date, month and year.  Mediamonkey stores this as a long number.  If they date is set to 2000 then the database will store it as 20000000.  If the date February 13th 1996 is it is stored as the number 19960213.

If they used a string it would be easier since we could use like.  Year like '1996%' would work.

as it is we need to be trickier and use this:

Year>=19960000 and Year<19969999

(note that we use >= so we will get all the songs marked as 1996 with no full date.

now to use payloads you can change this to
Year>={1}0000 and Year<{1}9999

or in the case of your example Kallle using genre as the first payload:

genre like '%{1}%' and Year>={2}0000 and Year<{2}9999

and that works, but if you ask for genre "rock" you will also get "folk rock" etc...  getting the exact genre is another difficulty which has already been discussed I think.

Wow, your are real one and only "Voxinator" 
I will test a bit with this command 

Big THANKS
Kalle

[jitterjames]

Here's the killer SQL for 1996 songs that are either 'acapella' or 'acid jazz'

Code: [Select]

(Songs.Year>=19960000 and Songs.Year<=19969999) AND
Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (21,65)))
 

but you need to know the id for the genres you want.

[Kalle]

Here's the killer SQL for 1996 songs that are either 'acapella' or 'acid jazz'

Code: [Select]

(Songs.Year>=19960000 and Songs.Year<=19969999) AND
Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (21,65)))
 

but you need to know the id for the genres you want.

  Haha, I think I'm too tired to understand something about that 

[jitterjames]

I don't blame you.  I finally figured out how to do it with Genre Names instead of ID, but you have to get the capitalization (of the genre name) correct:

[edit:  actually it seems like the capitalization doesn't matter ]

this will play anything from either Rock and Jazz genres.

Code: [Select]

Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.genrename in ("Rock","Jazz") )) Order by random()
and now my brain is melting...

[Kalle]

I don't blame you.  I finally figured out how to do it with Genre Names instead of ID, but you have to get the capitalization (of the genre name) correct:

[edit:  actually it seems like the capitalization doesn't matter ]

this will play anything from either Rock and Jazz genres.

Code: [Select]

Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.genrename in ("Rock","Jazz") )) Order by random()
and now my brain is melting...

Haha, oh no, I still need your brain 

Kalle

[Wanilton]

Walking Dead, Kalle...

[pomozki]

oh I'm so sorry - I ended up in the wrong forum!! My question has nothing to do with VC - in fact, I don't even know what it is 
I just googled MediaMonkey or iTunes forums - and yours appeared so I joined and posted my question
thanks to everyone for their replies ... in particular thanks to James for solving my puzzle with this reply

anyway on MM4 this is how you do it.  I don't have MM3 installed any more but hopefully it works about the same.

You just have to put checkboxes in all the genres that are acceptable and it will "or" them since it usually doesn't make much sense to "and" genres.

now I should go off and see what your program is all about 

[jitterjames]

 

No problem. $©√t happens