How to use <> not operator with search columns ?
-
anmac1789
- Posts: 747
- Joined: Mon Aug 24, 2020 1:16 pm
How to use <> not operator with search columns ?
How do I use the <> which means not for a search parameter ? for example find all files/folders where media-created:<> which is supposed to mean empty/has no data etc..
-
void
- Developer
- Posts: 19902
- Joined: Fri Oct 16, 2009 11:31 pm
Re: How to use <> not operator with search columns ?
To find files/folders where media-created: is not empty, include the following in your search:
media-created:
Alternatively, Everything has an unknown keyword.
unknown will match the empty value.
media-created:!=unknown
Use != for NOT EQUAL.
media-created:
Alternatively, Everything has an unknown keyword.
unknown will match the empty value.
media-created:!=unknown
Use != for NOT EQUAL.
-
anmac1789
- Posts: 747
- Joined: Mon Aug 24, 2020 1:16 pm
Re: How to use <> not operator with search columns ?
do you mean to use it asvoid wrote: Sun Oct 13, 2024 10:12 pm To find files/folders where media-created: is not empty, include the following in your search:
media-created:
Alternatively, Everything has an unknown keyword.
unknown will match the empty value.
media-created:!=unknown
Use != for NOT EQUAL.
$media-created:==$unknown-
void
- Developer
- Posts: 19902
- Joined: Fri Oct 16, 2009 11:31 pm
Re: How to use <> not operator with search columns ?
With $media-created:, use:
$media-created:!=
-or-
$media-created:<>
$media-created: is slower than media-created: as the expression is evaluated.
$media-created:!=
-or-
$media-created:<>
$media-created: is slower than media-created: as the expression is evaluated.