combine templater with dataview query

[CyRamos]

Hey guys
I'm trying to make a dataview query for the weekly template to show all my daily notes from the past week.
It is essential to base the query on the name and not the creation data because sometimes I delay creating the notes.

my daily format - DD-MM-YYYY
EXAMPLE : 02-12-2022

my weekly template format - WWW_YYYY Report
EXAMPLE : W49_2022 Report

Thanks ahead :)

[remoterocker]

@CyRamos - Were you able to solve this? I'm struggling with a similar query

[CyRamos]

Hey @remoterocker
Eventually, I had too many "issues" with Obsidian that I struggled to solve, realized I burned too much time to solve them instead of making progress, so I back to Notion.so (hopefully they'll make it similar to Obsidian in the near future with all Obsidian amazing features which I currently miss).

Here is the last query I had in my vault for this reference, hope it could help you somehow.

Dataview of the Weekly Template

table rating as ⭐, Aliases as Summary, headings as ✍🏽
from [[<% tp.file.title %>]] OR "00 Daily Reviews"
sort file.name asc

Daily Template

Metadata:

---

Aliases:
title: <% tp.file.title %>
created: <% tp.date.now("DD-MM-YYYY") %>
headings:

• "[[<% tp.file.title%>#what my main goal for today?|✅]] [[<% tp.file.title%>#gratitude?|🙏🏽]] [[<% tp.file.title%>#what I learned today? |📖]]"
• "[[<% tp.file.title%>#Thoughts|😶‍🌫️]] [[<% tp.file.title%>#improvments for tomorrow?|💪🏽]] [[<% tp.file.title%>#difficults thought the day?|🚧]]"
  tags: dailyNote

---

Page content:
<< [[<% moment(tp.file.title,'DD-MM-YYYY').add(-1,'days').format("DD-MM-YYYY") %>]] | [[W<% moment(tp.file.title,"DD-MM-YYYY").add(-1,'days').week() %>_<% moment(tp.file.title,'DD-MM-YYYY').format("YYYY") %> Report]] | [[<% moment(tp.file.title,'DD-MM-YYYY').add(1,'days').format("DD-MM-YYYY") %>]] >>

Daily Agenda : <% await tp.file.title %>

<% moment().format("[day] DDDD of " + moment("31-12", "DD-MM").dayOfYear()) %>

dataview of the daily template

TABLE label AS Label
FROM ""  
WHERE file.ctime.year = [[<%tp.file.title%>]].file.ctime.year AND file.ctime.month = [[<%tp.file.title%>]].file.ctime.month AND file.ctime.day = [[<%tp.file.title%>]].file.ctime.day AND file.name != [[<%tp.file.title%>]].file.name
SORT file.name