Advanced queries for use with CRM

[Siferiax]

From the queries for task management topic:

@Siferiax

Tasks by current page & it’s aliases

This uses a more complex or statement. This is basically a logical or. it is needed here as variable ?a is only for use in the or. [?b ?p] means these two variables are bound with the rest of the query.
More information: Datomic Queries and Rules | Datomic

#+BEGIN_QUERY
{:title ["Query by page & alias"]
 :query [:find (pull ?b [*])
   :in $ ?page
   :where
     [?b :block/marker "TODO"]
     [?p :block/name ?page]
     (or-join [?b ?p]
       [?b :block/refs ?p] 
       (and [?p :block/alias ?a] ; this attribute is available only when alias:: has been specified as a page property.
          [?b :block/refs ?a])
     )
 ]
 :result-transform :sort-by-priority
 :table-view? false
 :inputs [:current-page] ; alternatively use :query-page to use the page the query is on, rather than the page you are viewing
}
#+END_QUERY