Replace file.link name in dataview query with a different field

What I’m trying to do

I have a very simple dataview query to get the status of and links to my projects.

TABLE without ID name, file.link as link, status
from #project 
where file.name != "project template"
and status != "not doing" 
and status != "done"

image

I don’t want to expose the actual file names as they are not as nicely formatted or usefully descriptive as the name attribute in the YAML is a good descriptor. Using the output example, I want the name of file.link to change from strava metro data to Exploring Strava Metro data for transport policy and planning.

Thanks!

2 Likes

Closing as I managed to find a solution from here.
Code to do what I want below!

TABLE without ID link(file.link, name) as project, status
from #project 
where file.name != "project template"
and status != "not doing" 
and status != "done"
sort status
3 Likes

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.