Great video, very appreciated I'm new to logseq and have had trouble with clicking on the queries to edit as well but haven't been able to dig up any posts about it Thanks for sharing this 🙏
Excellent, yeah, comparing the parameters against each other is kind of pointless. Should have created a 181 day old test case to be sure it filters out. :)
Thanks, was a bit on the fence on Blender or using Fusion for this, in the end fusion won out because it was much easier to time to what I was saying being inside my video editor and all
Thanks for the feedback :) I get instant nightmares on the music in one of my old video's that was way too loud and haunted me with comments till this day.. Will keep en extra eye on it.
@@toolsontech Yeah. My whole way of working with Logseq got revolutionaized with a few queries with you. Thanks for guiding my meditations in Logseq, which is really what they are, lol.
It was so much fun to make the intro, I will make more in the future but probably move them a bit into the video because it's causes a huge drop at the start of my videos by people that don't realize the informative part comes right after. Glad to hear you liked it!
Thanks for sharing this video. Have you done a video on the latest way to (re)sort property columns in a query table? Looking for an intuitive way to do this...
Not yet, I got a couple of queries that use sort but I must be making a mistake somewhere because they don't always follow the strict order that I would think they have. Will probably discuss that once my video on journal queries goes up in a couple of weeks.
Can you do math operation on page properties? For example I have both a start and of the day property, and I want to have those both as columns in a table plus a third column that computes the difference between both times (thus giving the amount of hours worked).
In just a few days (and videos) you become my all leading Logseq Guru and Guide! ;) Really like your videos. But sometimes it is also frustrating! :D You show a really cool concept (like the Task Overview in your Starter Kit), I say "cool stuff! I will adopt it!" just to see a couple of videos later, that you throw everything over the pile just for another, even better concept... :D Have you also a video about scheeduled and deadline and how to use them?
Unfortunately that's the curse of constantly tweaking my systems. I do know I talked about scheduled and deadline before, but I believe it was a sub section of one of my older videos. Mostly use scheduled on tasks to remind me about things because they show up in my scheduled tasks query even when I miss a day. For repeating tasks I put them all on a single page, so it's easy to cleanup once in a while when all the reminders get too much.
@@axelrudolf5491 Checking my notes I did talk about it a little bit here ua-cam.com/video/LjcreIpujhM/v-deo.html But it's mostly how to use the feature, not really diving in depth on how to apply it.
What VS Code extension do you use for formatting the queries? I'm trying "Calva" but it doesn't seem to handle indentation properly (probably due to the fact that the clojure query is nested in a Markdown bullet). Thanks for this amazing tutorial btw!
I usually just copy the query from Logseq into VS Code, that way the bullet isn't there and the syntax highlight works much better. But does come with a bit of hassle compared to just opening the .md file.
Hello, thanks for your advanced query explanation. I really like the idea to write queries with VS Code. What are you doing to use code highlighting with clojure on markdown-files? All extentions i found don't highlight inside .md-file. Thanks!
I usually load the clojure file in a seperate file, or specify clojure when making code blocks in markdown ```clojure Query ``` That works in Logseq and most Markdown processors (like gitlab)
The external editor option only shows up when you have a single page open. Very often I'm either inside a block or I have the journal view and then it doesn't show. Try going to a page with CTRL+K and then checking the menu
I'm tryng to do a daily note (that I've created) that auto-populates at 12:01am but the one thing it's currently missing is a daily quote pulled from my quotes. Any suggestion on how to do this?
Hmm, tricky. There might be a way by running a query with a random sort and getting the top one. I would ask in the Logseq forum as there are a couple of people there that could probably make an example on the fly and we can all copy it :D
please is it possible for a query to return all images? kind of like a gallery view? I use this query but it returns audio files too #+BEGIN_QUERY {:title "All Images" :query [:find (pull ?p [*]) :where [?p :block/content ?content] [(clojure.string/includes? ?content "![")]]} #+END_QUERY
Great video, very appreciated
I'm new to logseq and have had trouble with clicking on the queries to edit as well but haven't been able to dig up any posts about it
Thanks for sharing this 🙏
It's always great to hear it helped someone! Good luck on your logseq journey.
it should be [( > ?day ?start )] great explanation and documentation. learned a lot, thx
Excellent, yeah, comparing the parameters against each other is kind of pointless. Should have created a 181 day old test case to be sure it filters out. :)
Well made video, especially the code walk-through, kudos
Thanks, was a bit on the fence on Blender or using Fusion for this, in the end fusion won out because it was much easier to time to what I was saying being inside my video editor and all
This helps a lot, thanks~
Glad it helped!
This is extremely good introduction...it helped me "breakthrough and understand the basic concepts. Well done!
I'm so glad it was helpful. Anything you would love to see in a followup video?
OMG, this is exactly the kind of tutorials we need more of, although the music becomes annoying after a while but I love your energy. Good job!
Thanks for the feedback :)
I get instant nightmares on the music in one of my old video's that was way too loud and haunted me with comments till this day.. Will keep en extra eye on it.
@@toolsontech Yeah. My whole way of working with Logseq got revolutionaized with a few queries with you. Thanks for guiding my meditations in Logseq, which is really what they are, lol.
Thats awesome to hear, glad it was helpful!
Loved the intro!!! And thanks for this video!
It was so much fun to make the intro, I will make more in the future but probably move them a bit into the video because it's causes a huge drop at the start of my videos by people that don't realize the informative part comes right after.
Glad to hear you liked it!
Thanks, that was very helpful 👍
Great to hear, that was the goal. :)
Thanks for sharing this video. Have you done a video on the latest way to (re)sort property columns in a query table? Looking for an intuitive way to do this...
Not yet, I got a couple of queries that use sort but I must be making a mistake somewhere because they don't always follow the strict order that I would think they have. Will probably discuss that once my video on journal queries goes up in a couple of weeks.
Well done, thanks buddy :)
Any time!
Great!!! Thanks!!
Thanks for letting me know I'm on the right track. :)
Can you do math operation on page properties? For example I have both a start and of the day property, and I want to have those both as columns in a table plus a third column that computes the difference between both times (thus giving the amount of hours worked).
In just a few days (and videos) you become my all leading Logseq Guru and Guide! ;) Really like your videos. But sometimes it is also frustrating! :D You show a really cool concept (like the Task Overview in your Starter Kit), I say "cool stuff! I will adopt it!" just to see a couple of videos later, that you throw everything over the pile just for another, even better concept... :D
Have you also a video about scheeduled and deadline and how to use them?
Unfortunately that's the curse of constantly tweaking my systems.
I do know I talked about scheduled and deadline before, but I believe it was a sub section of one of my older videos. Mostly use scheduled on tasks to remind me about things because they show up in my scheduled tasks query even when I miss a day.
For repeating tasks I put them all on a single page, so it's easy to cleanup once in a while when all the reminders get too much.
@@toolsontech Thank you. Do you know, which video it was? Did you make a video about task scheduling?
@@axelrudolf5491 Checking my notes I did talk about it a little bit here ua-cam.com/video/LjcreIpujhM/v-deo.html
But it's mostly how to use the feature, not really diving in depth on how to apply it.
Putting queries in config.edn is the way to go back there and edit them again on journal pages.
You mean as a macro? Or are there other ways to apply the queries like in journal?
@@toolsontech Under :default-queries in config.edn. you'll find a sub header called :journals.
👍
What VS Code extension do you use for formatting the queries? I'm trying "Calva" but it doesn't seem to handle indentation properly (probably due to the fact that the clojure query is nested in a Markdown bullet). Thanks for this amazing tutorial btw!
I usually just copy the query from Logseq into VS Code, that way the bullet isn't there and the syntax highlight works much better. But does come with a bit of hassle compared to just opening the .md file.
FYI: The DB schema link in the notes appears to be broken.
Thanks for letting me know, not sure what's happening but going to get it fixed soon
The last greater than, should actually be a less than, FYI 🙂
Got the mistake, excellent!
full text search we need full text search.
Unfortunately Datascript doesn't support full-text search
Hello, thanks for your advanced query explanation.
I really like the idea to write queries with VS Code. What are you doing to use code highlighting with clojure on markdown-files? All extentions i found don't highlight inside .md-file.
Thanks!
I usually load the clojure file in a seperate file, or specify clojure when making code blocks in markdown
```clojure
Query
```
That works in Logseq and most Markdown processors (like gitlab)
At 7:00 I don't have the menu item to edit the page in an external editor. What happened to that?
The external editor option only shows up when you have a single page open. Very often I'm either inside a block or I have the journal view and then it doesn't show. Try going to a page with CTRL+K and then checking the menu
I'm tryng to do a daily note (that I've created) that auto-populates at 12:01am but the one thing it's currently missing is a daily quote pulled from my quotes. Any suggestion on how to do this?
Hmm, tricky. There might be a way by running a query with a random sort and getting the top one. I would ask in the Logseq forum as there are a couple of people there that could probably make an example on the fly and we can all copy it :D
@@toolsontech I have, multiple times, haha. I think it's a lost cause at this point :(
please is it possible for a query to return all images? kind of like a gallery view?
I use this query but it returns audio files too
#+BEGIN_QUERY
{:title "All Images"
:query [:find (pull ?p [*])
:where
[?p :block/content ?content]
[(clojure.string/includes? ?content "![")]]}
#+END_QUERY