Summarize Daily Notes Using Dataview

[justdoitcc]

Oh, anytime!

You could use DQL90 or DVJS90 to display the content under the heading :“what happened today”.

Summary

DQL90

• The DQL90 is copied from DQL07_flatten_fLists_groupBy_fLink_and_display_list_items_and_task_items_under_the_heading in the following topic.
  • The file.lists by example - Chapter 1: using DQL to gather list items or task items under the specific heading
  • Links: Solutions=>JonnyP: Grouping Tasks in Dataview by Content at 2022-08-23
  • You could read the following questions under the heading “Topic : file.lists by example”
    • Q: How to use FROM source for best performance when using DQL?
    • Q: What does the following DQL statement mean?
    • Q: How to use F_subpath to filter by the specific heading when using DQL?

DVJS90

• The DVJS90 is copied from DVJS01_groupBy_fLink_flatten_fLists_and_taskList in the following topic.
  • The file.lists by example - Chapter 2 : using DVJS to gather list items or task items under the specific heading and group by a column (and group by another column)
  • Links: Solutions=> johnnyvenom: The codeblock should display each project with the title as a header (H3) followed by the summary, and should group the projects by Area. at 2022-08-24

---

You should ignore the other DQLs at present.

---

Q: How did I have to modify that line, if I’d like to just search for headings, which contain “what happend”?

Summary

for DQL90

the original example

WHERE contains(F_subpath, "what happened today") AND F_type = "header"

the new example

WHERE contains(F_subpath, "what happend") AND F_type = "header"

for DVJS90

the original example

    // M31.FR13 define a_filtered_lists:
    // FLATTEN page.file.lists and gather them: 
    // get items under the heading "Summary"
    // #####################################################################
    let a_filtered_lists = group.rows
        .flatMap((page) => page.file.lists)
        .where(
            (L) => dv.func.contains(L.header.subpath, "what happened today") && 
                   L.header.type === "header"
        );

the new example

    // M31.FR13 define a_filtered_lists:
    // FLATTEN page.file.lists and gather them: 
    // get items under the heading "Summary"
    // #####################################################################
    let a_filtered_lists = group.rows
        .flatMap((page) => page.file.lists)
        .where(
            (L) => dv.func.contains(L.header.subpath, "what happened") && 
                   L.header.type === "header"
        );

---