I do SQL for a living, but in spite (or maybe because) of that I’m having a hard time wrapping my head around Logseq’s queries. I’ll start with this. I’m trying to find all pages in my project namespace with active tasks. I can get this far: :query [ :find (pull ?p [*]) :where [?b :block/marker ?…

What helped me with SQL to datalog is to keep in mind that datalog where clauses are based on table form. So select * from table where column = value Becomes {:query [:find (pull ?id [*]) ;this is the select, get all attribute (columns) for this ?id :where [?id column value] ] } As datalog…

Tasks in namespace

Questions & Help Queries

Siferiax October 5, 2023, 7:07am 4

See this topic for some ideas:

I haven’t gotten back to that discussion, but hopefully it suits your use case.