Is it possible to transform dataview results from within a query?

What I’m trying to do

I have a query which produces a table. In addition to the normal ID, it also has a date field, and other fields. I would like to be able to display the date as a link, for example.

here’s a little query that does it in two different ways:

TABLE "[[""]]" AS datelink
FROM "journal"
TABLE link( AS datelink
FROM "journal"

Second one is probably a bit more elegant.
Here I just pulled a few files from my journal and used their names to act as date strings. You can coerce between date and string with date() and string() functions if needed.

1 Like

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