I’ve tried going through the dataview documentation and tried to use the WITHOUT ID and aliases AS Name part of the TABLE command, but I don’t know how to make that result a link to the document. I thought that I could perhaps have the result of the first column (file) show the alias instead, but I’m stuck!
What I’m trying to do
I have a bunch of subject MOCs that I want to present in a list on an index page from a dataview query that uses each MOC’s alias rather than their respective file names (because I don’t want a massive list of entries with MOC in their name). So instead of:
[[Editing MOC]]
[[Marketing MOC]] et al…
it should simply be:
[[Editing]]
[[Marketing]] et al…
It’s worth saying that I’ve only been using Obsidian for a week or so and I’m not that savvy when it comes to JavaScript, so I’d like to stick with basic query language if that is possible, though I’m happy to learn JS if there’s no facility for it.
TABLE WITHOUT ID link(file.link, aliases)
bookNumber AS "No.",
author As "Author",
location as "Loc",
choice(series, join(list(series, seriesnumber), " #"), " ") AS "Series"
where file.name = this.file.name
2 | bookNumber AS “No.”,
| ^
3 | author As “Author”,
4 | location as “Loc”,
Expected one of the following:
‘*’ or ‘/’ or ‘%’, ‘+’ or ‘-’, ‘,’, ‘>=’ or ‘<=’ or ‘!=’ or ‘=’ or ‘>’ or ‘<’, ‘and’ or ‘or’, /AS/i, /FROM/i, EOF, FLATTEN [AS ], GROUP BY [AS ], LIMIT , SORT field [ASC/DESC], WHERE