Combine queries: child text with parent block properties

Questions & Help Queries
2

Something like this:

#+BEGIN_QUERY
{:query [:find (pull ?parent [*]) ?content
   :keys parent content
   :where
     [?child :block/ref-pages ?page]
     [?page :block/name "tldr"]
     [?child :block/parent ?parent]
     [?parent :block/properties ?props]
     [(get ?props :project) ?proj]
     [(= ?proj "research notes")]
     [?child :block/content ?content]
 ]
 :result-transform (fn [result]
   (map (fn [r]
     (update (:parent r) :block/properties (fn [p]
       (assoc p "Child Block" (:content r) )
     ) )
   ) result)
 )
 :remove-child-block? false
}
#+END_QUERY
1 Like