INTERACT FORUM

Please login or register.

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

Author Topic: does search language have not equals? (!=)  (Read 1181 times)

biblio

  • Junior Woodchuck
  • **
  • Posts: 83
does search language have not equals? (!=)
« on: February 25, 2019, 03:20:50 pm »

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/!=?
Logged

swiv3d

  • Guest
Re: does search language have not equals? (!=)
« Reply #1 on: February 25, 2019, 03:44:12 pm »

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]=[]
Logged

biblio

  • Junior Woodchuck
  • **
  • Posts: 83
Re: does search language have not equals? (!=)
« Reply #2 on: February 25, 2019, 05:01:16 pm »

Ahhh, Thank you!

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

swiv3d

  • Guest
Re: does search language have not equals? (!=)
« Reply #3 on: February 25, 2019, 05:03:54 pm »

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.
Logged

biblio

  • Junior Woodchuck
  • **
  • Posts: 83
Re: does search language have not equals? (!=)
« Reply #4 on: February 25, 2019, 07:26:34 pm »

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.
Logged

swiv3d

  • Guest
Re: does search language have not equals? (!=)
« Reply #5 on: February 25, 2019, 07:37:51 pm »

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

RoderickGI

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 8186
Re: does search language have not equals? (!=)
« Reply #6 on: February 25, 2019, 08:15:01 pm »

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.  :)
Logged
What specific version of MC you are running:MC27.0.27 @ Oct 27, 2020 and updating regularly Jim!                        MC Release Notes: https://wiki.jriver.com/index.php/Release_Notes
What OS(s) and Version you are running:     Windows 10 Pro 64bit Version 2004 (OS Build 19041.572).
The JRMark score of the PC with an issue:    JRMark (version 26.0.52 64 bit): 3419
Important relevant info about your environment:     
  Using the HTPC as a MC Server & a Workstation as a MC Client plus some DLNA clients.
  Running JRiver for Android, JRemote2, Gizmo, & MO 4Media on a Sony Xperia XZ Premium Android 9.
  Playing video out to a Sony 65" TV connected via HDMI, playing digital audio out via motherboard sound card, PCIe TV tuner

biblio

  • Junior Woodchuck
  • **
  • Posts: 83
Re: does search language have not equals? (!=)
« Reply #7 on: February 25, 2019, 09:28:45 pm »

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.
Logged

biblio

  • Junior Woodchuck
  • **
  • Posts: 83
Re: does search language have not equals? (!=)
« Reply #8 on: February 25, 2019, 09:29:53 pm »

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

This forum has made me really happy i purchased MC
Logged

RoderickGI

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 8186
Re: does search language have not equals? (!=)
« Reply #9 on: February 26, 2019, 12:21:34 am »

Done.
Logged
What specific version of MC you are running:MC27.0.27 @ Oct 27, 2020 and updating regularly Jim!                        MC Release Notes: https://wiki.jriver.com/index.php/Release_Notes
What OS(s) and Version you are running:     Windows 10 Pro 64bit Version 2004 (OS Build 19041.572).
The JRMark score of the PC with an issue:    JRMark (version 26.0.52 64 bit): 3419
Important relevant info about your environment:     
  Using the HTPC as a MC Server & a Workstation as a MC Client plus some DLNA clients.
  Running JRiver for Android, JRemote2, Gizmo, & MO 4Media on a Sony Xperia XZ Premium Android 9.
  Playing video out to a Sony 65" TV connected via HDMI, playing digital audio out via motherboard sound card, PCIe TV tuner
Pages: [1]   Go Up