Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[biblio]

I've just had a quick glance through the wiki and searching here but can't see it.

I want to be able to search for something in my fields but exclude known correct fields.

Something like one of these for files mistagged over samba.
[Album Artist]="~" AND [Album Artist]!="~▲†▲~"
[Album Artist]="~" AND NOT [Album Artist]="~▲†▲~"

There's and/or etc but no not/!=?

[swiv3d]

From the wiki:
Negation and All
Operator    Description
-field    Inverts the sense of the comparison, returning those files whose field does not match the specified value. Usage is limited to the equality and comparison operators.

Example: Return all files whose track number is not 1:

-[Track #]=1

Example: Return all files whose track number is not greater than or equal to 3:

-[Track #]=>=3

Note that this equivalent to the more direct search phrase:

[Track #]=<3

Example: Return all files by artist Mark Isham, except those whose album names begin with after or quiz, or end with home, and exclude files from 1993:

[Artist]="Mark Isham" -[Album]=[after",[quiz","home] -[Date (year)]=1993

Example: Return all files that have associated artwork (i.e. [Image File] is not empty).

-[Image File]=[]

[biblio]

Ahhh, Thank you!

I was looking for all the sql/query things i was used to and glossed over that

[swiv3d]

Yes  I agree, it is a bit of a learning curve after using MSQL etc. But it does a good job - hope it all works for you.

[biblio]

Are we able to make an account and propose edits on the wiki?

I would just like to put extra language in to make the search come up for other people with the same issue.

[swiv3d]

I would suggest the  - Be happy my problem is solved!

[RoderickGI]

Are we able to make an account and propose edits on the wiki?

What would you want added?

You can request Wiki editing access if you want to do it yourself. Or just make a suggested change here in this thread.



I always have to think twice with the Negation operator ( -[field] ), particlarly when MC uses the functions like "isequal()" to test if something is equal, and "!isequal()" to test is something is NOT equal.
i.e. In an expression such as
If(!isequal([Artist], Enigma, 1), NOT, TRUE)

The simple dash doesn't feel natural to me. But, that is what we have. 

[biblio]

I don't need edit access I would just suggest an additional sentence in "Negation and All" at the top of the section. Something that included common search terms would cover all the sql guesses I took this morning in one sentence:

In database terms; the use of negation is similar to "!=" (not equals) and "IS NOT" but is set at the beginning of the term.

[biblio]

I would suggest the  - Be happy my problem is solved!

This forum has made me really happy i purchased MC

[RoderickGI]

Done.