logseq/journals/2024_01_07.md

• {{query (and (task DOING TODO) (page GOALS-TODOIST) "PAPERS/")}} query-table:: true query-properties:: [:block :todoist-desc :todoist-id]

• query-sort-by:: page query-table:: true query-sort-desc:: false #+BEGIN_QUERY { :title [:b "SELECT ALL THE PAPER GOALS FROM TODOIST"] :query [:find (pull ?block [*]) :where [?block :block/page ?page] [?page :block/original-name ?name] [(clojure.string/starts-with? ?name "GOALS-TODOIST")]

  [?block :block/content ?blockcontent] [(clojure.string/includes? ?blockcontent "PAPERS/")]

  [?block :block/marker ?marker] ( or [(contains? #{"DOING"} ?marker)] [(contains? #{"TODO"} ?marker)] )] :view (fn [rows] [:table [:thead [:tr [:th "Task"] [:th "Priority"] ]] [:tbody (for [r rows :let [content (str (get r :block/content))] :let [firstline (first (str/split-lines content))] ;this will show only the first line of the task. ] [:tr [:td [:a {:href (str (get-in r [:block/content]))} firstline] ] ;link to the block and show the first line [:td (get r :block/priority) ] ;get the priority from the results ] )] ]) } #+END_QUERY

• :view (fn [rows] [:table [:thead [:tr [:th "Page"] [:th "Count"] ] ] [:tbody (for [r rows] [:tr [:td [:a {:href (str "#/page/" (get r :page))} (get r :page)] ] [:td (get r :count)] ]) ]] )

• •  Notes

  • 🤝Meetings

  • 📜Reviews

    • {{query (and REVIEWS (or (property :date-end 07-01-2024) (property :date-start 07-01-2024)))}} query-table:: true query-properties:: [:file :year :venue :deadline]

  • ⤴️Omnivore readings

    • {{query (and (property :source Omnivore) (or (property :deadline 07-01-2024) (property :date-saved 07-01-2024) (property :date-archived 07-01-2024)))}} query-table:: true query-properties:: [:labels :author :site :block]