Dataview table linking to a field in the current document

[gianx]

Hi,

I have notes representing "Companies" and I want to have a dataview table with all the related notes in the folder Streams.
Actually in the Companies note I have a field:

CompanyName:: [[MyCompanyName]]

And I need to write something like this:

TABLE title, company
FROM "Streams"
WHERE company = this_document.CompanyName

How can I do that?

[AB1908]

How are these relations defined? Do notes in streams link to companies?

[gianx]

Yes, notes in streams have a:

company:: Company name

that links to Company.

[AB1908]

Is it a link or is it a string like you've written out? If it is a link, assuming you're querying from the note represented by [[MyCompanyName]]

```dataview
TABLE title, company
FROM "Streams"
where company = this.file.link
```

[gianx]

My bad, I lost a ':', now corrected

[AB1908]

Did that work? I'm assuming it didn't.

[gianx]

It worked instead, thanks