Signin Signup

Search for open tasks

This post was last updated for 1157 days ago, and the information may already be changed

First I want to say I'm pretty impressed with the functionality SiYuan offers... Especially the standard mermaid, UML, ... is great. Also the SQL query possibility is a handy thing.

Now for my question:

I want to see a list of all open task items across all documents. Since I did not find this in the UI, I figured I can create a query.

It's pretty easy to find all tasks:

select * from blocks where type = 'i' and subtype = 't' order by created

But I'm stuck for the attribute/field that can filter on the state of the task (open/done).

Hoping someone can help me out?

    20 Ask
    1 Thank
    1 Collect
    4 Reply
    2.3k 119 76 260 1 1.8k

    Related articles

    4 Reply
    Search for open tasks

    Welcome to here!

    Here we can learn from each other how to use SiYuan, give feedback and suggestions, and build SiYuan together.

    Signup About
    Please input reply content ...
    • wouter • • 1
      Author

      I was checking GitHub for a possible answer, and found a solution.

      Apparently you can query the markdown syntax of each block.

      So my new query looks like this:
      select * from blocks where type = 'i' and subtype = 't' and markdown like '%[ ]%' order by created

      And now I filter only the open tasks / open todo's.

      Likewise, one can filter the done tasks with markdown like '%[x]%'

    • MiscReply
    • 45782 •
      VIP Warrior

      @88250 Are there any plans to implement more advanced task management features in SiYuan? Is there an issue I can follow regarding this? Features such as setting priorities, deadlines, recurring tasks, additional statuses, etc ?.

      1 Reply
    • 88250 •
      MOD

      There are currently no development plans for task management; it is recommended to look for relevant plugins in the marketplace.

    • ranggasan •
      PRO

      You could read SiYuan User Guide, in "Content Block" section, there are several examples of query that you can use, and modify according to your needs including the one you're asking for

    wouter
    Reply
    1
     Article
    1
     Point
    523

    Recent hot