How can I reference fields in the current file?

[laurastephsmith]

I've got this working query in a file called "Eukaryota":
LIST WITHOUT ID link(subtaxa) FROM "Eukaryota" FLATTEN subtaxa

I'd like to replace "Eukaryota" with a reference to whatever the current file is, so I can use the query in any file. Is there anything I should put there?

Thanks!

[AB1908]

list without id link(subtaxa) from this.file flatten subtaxa should work.

[laurastephsmith]

Thanks @AB1908 - but I get an error:

Dataview: Error: 
-- PARSING FAILED --------------------------------------------------

> 1 | LIST WITHOUT ID link(subtaxa) FROM this.file FLATTEN subtaxa
    |                                    ^

Expected one of the following: 

'!', '(', '-', 'csv(', 'outgoing(', file link, string, tag ('#hello/stuff')

[AB1908]

Oops, messed up the syntax. Try [[#]] instead of this.file.

[laurastephsmith]

Thanks, but that's what I started with. That gives files that link to the current file (or you can use outbound([[]]) to give links out of the current file. What I'm trying to get is the current file itself.

[AB1908]

Interesting. The docs say otherwise: https://blacksmithgu.github.io/obsidian-dataview/query/sources/

[AB1908]

Funnily enough, I was able to repro. Meanwhile, can use where file.path = this.file.path as a workaround.

[laurastephsmith]

Not quite. The docs are poorly worded :). "You can implicitly reference the current file via [[#]] or [[]]" is written under the "4. Links" bullet point. It explains that "To obtain all pages which link TO [[note]], use [[note]]". Therefore, [[]] would logically give pages which link to the current page, not the current page itself.

[AB1908]

Interesting. I'll investigate this further at some other time.

[mnvwvnm]

To target the current note in FROM you need to write the full path (with or without the .md extension):

LIST WITHOUT ID link(subtaxa)
FROM "yourfolder/Eukaryota"
FLATTEN subtaxa

[mnvwvnm]

Just a point.
To use links in yaml frontmatter, you need to use quotation marks. Something like this:

---
subtaxa:
  - "[[Agnatha (Jawless Fish)]]"
  - "[[Gnathostomata (Jawed Vertebrates)]]"
---

With this you don't need to use link(field) in the query.

[mnvwvnm]

A second point.
Dataview results are just that, a data "view".
With this I want to say: the links in the result view don't becomes outgoing links!

[laurastephsmith]

Oo thank you!

Unfortunately it seems that breadcrumbs can't accept WHERE. I was hoping to be able to type the list in the body of the note rather than in the frontmatter. But with what you've helped me with I can now at least do it the other way around:

---
subtaxa:
- "[[Agnatha (Jawless Fish)]]"
- "[[Gnathostomata (Jawed Vertebrates)]]"
---

# Vertebrata (Vertebrates)

## Infraphyla

```dataview
LIST WITHOUT ID subtaxa WHERE file = this.file FLATTEN subtaxa
```

To be honest the more I think about it, it makes more sense to have the list in the YAML anyway. It's just that the YAML section might get a bit big in some cases! Not to worry. I'll call this problem solved. Thanks for your help both :)

[laurastephsmith]

A second point. Dataview results are just that, a data "view". With this I want to say: the links in the result view don't becomes outgoing links!

Good, or we'll be going around in never ending circles ;)

[laurastephsmith]

Just putting this here for the benefit of anyone who follows this in the future: unfortunately this doesn't/can't work at the moment because of the way Obsidian caches in live preview (see blacksmithgu's comment here). The whole point of using this.file was so the query would be the same in lots of files. Unfortunately in live preview switching between files that contain the same Dataview query seems to pull the same results from Obsidian's cache. So you end up seeing the results of the previous page's query!