List from tag 1 exclude tag 2

[filmgal]

I don't think there's a way to say:
list from #dessert but not #icecream

I've tried a few ways to no avail.
Something like this would be so useful.

This is probably a separate issue, but a way to say does not contain would also be great.
list from #dessert
where !=contains(file.name, "Ice Cream")
or something like that.

[blacksmithgu]

Both are possible - for the first, negation is done via the minus sign ("-"), so

LIST FROM #dessert and -#icecream

For the second, use "!" for negation:

LIST FROM #dessert WHERE !contains(file.name, "Ice Cream")

The negation operator being different in both cases is a little wierd. Will add support for "!" in both cases so you don't need to remember the sublety.

[SkepticMystic]

I was also a little confused about excluding tags. The minus - syntax didn't occur to me. Thanks for supporting both options

[liamcain]

Related:

---

I also just discovered that ! works when checking for null/undefined in YAML objects. I just created the following frame for example:

table file.mtime as Modified 
from #task
WHERE file.name != "TODO" and !completed_at
sort file.ctime desc

which properly filters out notes that contain completed_at in the YAML

e.g.

[blacksmithgu]

That's right. In WHERE blocks, I follow JavaScript style "truthiness", so null values are considered false. Thus, negating a null/undefined value yields true.

[blacksmithgu]

Added support for '!' in front of sources as well, so you can use it for everything. I can't use '-' in fields, since that could also mean numeric negation.