This time last year query in config.edn?

Questions & Help
1

I am wondering what is the syntax for querying the journal page of this date yet exactly one year ago (eg today is Jun 27, 2022 and the query result is Jun 27, 2021). I found here that the logseq query is {{query (between -1y -1y )}}, which works. But I am wondering what is the equivalence for the query syntax in config.edn?
Thanks!

2

Anyone got a clue? Appreciate any input!

3

Okey I think I got the solution

{                                                                                                    
    :title            "This time last year"                                                                        
    :query            [:find (pull ?b [*])                                                              
                       :in $ ?span                                                                      
                       :where                                                                           
                       (between ?b ?span ?span)                                                         
                       ]                                                                                
    :inputs           [:365d-before ]                                                                   
   :collapsed?       false}
4

https://logseq.pro/#/page/queries

Put this in config.edn.

#+BEGIN_QUERY
{:title [:b "🌺那年今日"]
 :query [:find (pull ?j [*])
         :in $ ?today
         :where 
         [?j :block/journal-day ?jd]
         [(- ?today ?jd) ?days]
         [(mod ?days 10000) ?r]
         [(= 0 ?r)]
         [(> ?days 0)]
         ]
 :inputs [:today]
 }
#+END_QUERY

Put this in siderbar.

#+BEGIN_QUERY
{:title [:b "🌺那年今日(动态)"]
 :query [:find (pull ?j [*])
         :in $ ?cn
         :where 
         [?c :block/name ?cn]
         [?c :block/journal-day ?cd]
         [?j :block/journal-day ?jd]
         [(- ?cd ?jd) ?days]
         [(mod ?days 10000) ?r]
         [(= 0 ?r)]
         [(> ?days 0)]
         ]
 :inputs [:current-page]
 }
#+END_QUERY

:hatching_chick:Have fun! (And learn some Chinese in those queries :smiley: )

1 Like
5

I’m sorry to bother you, but I’m not sure where to put this query. Could you please guide me?

6

Welcome. This is probably about section :default-queries of file config.edn inside folder logseq of your graph.

7

I did this, but there was no response on the journal page.

CleanShot20231015_231845
CleanShot20231015_231845837×413 32.2 KB

8

Be careful with the syntax, the queries should be inside an array:

 :default-queries
 {:journals
  [
   {:title

    ...

   }
  ]
 }
9

Thanks to your suggestion, the problem has been fixed and everything’s running smoothly now. Thanks again!