Please Help, with Query and correct nesting

Questions & Help Queries
1

I have management boards for the different clients that I work with as I am an Business Analyst. I want to return a query on other pages or my journal pages that returns all the blocks under the heading Key Projects. my goal is to display the different key projects in the table format.

I have tried multiple queries from ancester to everything else I could think of. However, it is not working. I am new to coding and logseq and it is becoming frustrating. Please help.

Page: Company Name

Company Management Board

  • Task Planning

    • [[Key Projects]]

      • [[DDC Strategic Plan]]
      • [[Task 2]]
2

Here is one way:

#+BEGIN_QUERY
{
 :query [:find (pull ?b [*])
   :where
     [?key :block/original-name "Key Projects"]
     [?b :block/path-refs ?key]
     (not [?b :block/refs ?key])
 ]
 :remove-block-children? false
}
#+END_QUERY
3

Legend, I got it to work using the following:

#+BEGIN_QUERY
{
 :query [:find (pull ?child [*])
         :where
           [?parent :block/content ?content]  ; Match blocks with "Key Projects" in content
           [(clojure.string/includes? ?content "Key Projects")] ; Matches plain, bold, or linked
           [?child :block/parent ?parent]     ; Find all child blocks of the matched blocks
        ]
}
#+END_QUERY
4

Some issues with your version:

  • It works only for direct child-blocks of “Key Projects”.
    • If in the future you try to nest deeper some projects (e.g. group them under common tags), the query will miss them.
  • It will gradually get slow, as it has to search:
    • the whole text content
    • of every block
    • every time