logseq page-property-join-example-query

page-property-join-example-query

- #+BEGIN_QUERY
{:title "Query joining page properties with a rule"
 :query [:find (pull ?things [*])
     :in $ ?region %
     :where
     (page-name-property ?_b ?country :region ?region)
     (page-name-property ?_b2 ?author :country-of-origin ?country)
     (page-name-property ?things ?_name :authored-by ?author)]
:inputs ["Middle East"
         [[(page-name-property ?b ?block-name ?property-name ?property-value)
          [?b :block/original-name ?block-name]
          [?b :block/properties ?p]
          [(get ?p ?property-name) ?property-values]
          [(contains? ?property-values ?property-value)]]]]
 }
#+END_QUERY