Exclude child tags of tag in WHERE condition

[finn-matti]

I envision the following DQL query:

LIST
FROM #main/topics
WHERE file.name!=this.file.name AND <!econtains(child.tags of #main/topics)>
SORT file.name

How do I construct the WHERE condition here? I could se excluding all child tags of #main/topics manually (AND !econtains(this.file.etags, "#main/topics/child1") AND …), but there probably is a better way, right?

[ymwp]

Not exactly a solution, but it seems you could get away with using

WHERE file.name!=this.file.name AND econtains(file.etags, "#main/topics")

since parent tags are not included in file.etags (unless explicitly present).

If you want to exclude files containing both #main/topics and #main/topics/child, or if you want to include files that don't contain #main/topics at all, then you could try a DataviewJS query like:

let pages = dv.pages("#tag").where(p => {
  let r = true;
  for (let tag of p.file.etags) {
    r &&= tag.match(/#tag\/.+/) === null;
  }
  return r;
});
dv.list(pages.file.link)