I just realised that I have asked something similar earlier:
But there is a slight difference: In the earlier example it was just “regular” dataview query that can return several values. This time I would need to return just one value, and I would prefer an inline query.
But, in the meantime I decided to handle my request using the approach outlined in my earlier forum post. But I can’t get it to work. Which is weird, as the format in both cases is basically same: a rolling list of entries, each entry linking to a daily note. I started from the beginning and listed every entry along with outlinks:
TABLE WITHOUT ID item.text, item.outlinks
FLATTEN file.lists as item
WHERE file.name = "Values"
And it returns nothing. I even changed the format of the entries to match the one in the earlier discussion. If I do the exact same query (Modified for different note of course) for Log.md, it works fine. So I’m again stumped…