I want to create a query that shows all pages new pages created this month. How can I do this ? (I’m not an expert with queries)
Thanks for everyone trying to help.
There’s a created-at attribute you can use. I’ve found the attribute unreliable as it seems to update due to my sync set-up. I don’t know if that is an issue with you, but just keep it in mind.
Here’s a query for it.
#+BEGIN_QUERY
{:title "Pages last 30 days"
:query [:find (pull ?p [*])
:in $ ?start
:where
[?p :block/created-at ?d]
[(>= ?d ?start)]
[?b :block/page ?p]
]
:inputs [:30d]
}
#+END_QUERY
1 Like
Thank you for this perfect answer. It worked perfect