List from tag 1 exclude tag 2 about obsidian-dataview HOT 7 CLOSED

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.

from obsidian-dataview.

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

from obsidian-dataview.

Yes, file.etags[0] or similar ideas should work.

from obsidian-dataview.

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.

from obsidian-dataview.

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.

from obsidian-dataview.

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.

from obsidian-dataview.

can obsidian dataview table get tags , but only first tag ??

from obsidian-dataview.