Query journal blocks that reference a page

[ddavo]

I tried getting also the aliases, based on:

@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

My query is now this:

#+BEGIN_QUERY
{:title [:h2 "Diario de clases con alias"]
    :query [:find (pull ?b [*])
            :in $ ?current
            :where
            [?b :block/page ?p]
            [?p :page/journal? true]
            [?b :block/refs ?r]
            [?r :block/name ?current]
            (or-join [?b ?r] ; needed because ?a might not unify
              [?b :block/refs ?r]
              (and [?r :block/alias ?a] [?b :block/refs ?a])
            )
    ]
    :inputs [:query-page]
    :collapsed? false}
#+END_QUERY

But it doesn’t return the blocks that use the aliased version