Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

outgoing() in where clause with file.link as the source #89

Closed
davecan opened this issue Apr 8, 2021 · 3 comments
Closed

outgoing() in where clause with file.link as the source #89

davecan opened this issue Apr 8, 2021 · 3 comments

Comments

@davecan
Copy link

@davecan davecan commented Apr 8, 2021

Is it possible to construct a query like this?

list from ""
where contains(outgoing(file.link), this.file.link)

To return a list of all files that link to the current file.

I know this is possible in the from clause if the name of the note is explicitly provided, but I'm looking for something that doesn't require specifying the name of the note in every query. Plus I'm trying to build a slightly more complex query that merges results from a few sets and this is one of them.

@blacksmithgu
Copy link
Owner

@blacksmithgu blacksmithgu commented Apr 9, 2021

I can implement this as a function until I properly implement the file.links.incoming and file.links.outgoing metadata fields.

@balajimalanji
Copy link

@balajimalanji balajimalanji commented May 10, 2021

Is there an issue open regarding file.links.incoming and file.links.outgoing?

@blacksmithgu
Copy link
Owner

@blacksmithgu blacksmithgu commented Sep 9, 2021

Going to close this specific ticket since you can actually do this with the wonderful hack LIST FROM outgoing([[]]), and this specifically will be tackled as part of more general tickets for "arbitrary computation in the FROM block`.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
3 participants