Advanced query - exclude blocks where matched content (regex) is page

Questions & Help Queries
1

This query picks up all blocks with lit references (matching the input regex). I’d like to exclude blocks where the lit reference is a page - so it’d pick up @Test2024 but not [[@Test2024]]. Not sure how to approach this and would love guidance. Part of me wonders - is this even possible?

#+BEGIN_QUERY
{:title "References without pages"
:query
[:find (pull ?block [*])
:in $ ?input
:where
[(str "(?i)" ?input) ?pattern]
[?block :block/content ?content]
[(re-pattern ?pattern) ?captured]
[(re-find ?captured ?content)]]
:inputs ["@[a-zA-Z]+\\d{4}"]
}
#+END_QUERY
1 Like
2

Welcome. Try :inputs ["(^|[^[])@[a-zA-Z]+\\d{4}"]

1 Like
3

Works perfectly thank you! Didn’t even think to try adapting the regex, oops.