How to filter all tasks with tag MYTAG or page tag MYTAG

[Dorinand]

I upgraded to latest version 0.7.0 and queries started working, the problem was probably with the version of logseq I did not mention here.

@starryveshch

#+BEGIN_QUERY
{:title "All tasks tagged with MYTAG"
 :query [:find (pull ?b [*])
         :where
         (task ?b #{"NOW" "LATER" "DOING" "TODO"})
         [?b :block/page ?p]
         [?r :block/original-name "MYTAG"]
         (or [?b :block/path-refs ?r]
             [?p :block/tags ?r])]}
#+END_QUERY

Also this

@stdword

#+BEGIN_QUERY
 {:title "`or-join` example"
  :query [:find (pull ?b [*])
          :where
          (or-join [?b ?n]
                 (and [?b :block/page ?p] [?p :block/tags ?t] [?t :block/name ?n])
                 (and [?b :block/path-refs ?r] [?r :block/name ?n])
          )
          [(= ?n "mytag")]
          (task ?b #{"NOW" "LATER" "DOING" "TODO"})
     ]
  :collapsed? false}
#+END_QUERY

@starryveshch could you explain how does the query is processed? I understand that ?p, ?b and ?r are variables, but even after reading some tutorial, I am not able to understand the logic of queries. Can you describe step by step what each line do, where it stores and how is it passed to the next clause? What if I want to filter based on multiple tags not just MYTAG but also MYTAG2? Thank you.