Listing content of sub-headings by date?

[aravindsv]

Hi, I'm hoping to get some help with 1. figuring out if what I'm trying to do is even possible, and 2. structuring the query if it is.

My normal workflow is that I have long-running projects that each have their own project pages. I typically make a new heading under that project page where the heading is the current date in YYYY-MM-DD format whenever I work on a specific project on that day. At the end of the day, I'll usually drop a link to that project in my daily note so I know I worked on it that day.

I'd like to automate this a little, by using a query to search through all the H1 headings in my project directory, and list any projects that have the current date on them. Is this possible to do? I haven't found much info on querying headings with dataview. Any help is appreciated. Thanks!

[aravindsv]

Managed to figure out an answer to my own question! Pasting code here in case someone needs it in the future, or if there's improvements that can be made:

dv.header(1, "Project Work");
const file_title = dv.current().file.mday;
const luxon_date = dv.date(file_title);
const date = luxon_date.toFormat("yyyy-MM-dd");

const pages = dv.pages('"Projects"');
const filter_text = date;

const regex = new RegExp(`#+ ${date}\r?\n(.*?)(\n#+ |\n---|$)`, "s");
for (const page of pages) {
    const file_contents = await dv.io.load(page.file.path);
    const header_match = file_contents.match(regex);
    if (header_match) {
        dv.header(2, (dv.sectionLink(page.file.name, date, false, page.file.name)));
        dv.paragraph(header_match[1]);
    }
}

[huyz]

Hmm, is there no other way to query for sub-headings other than doing a regex?