Thanks for responding xhir. Yes I just noticed your plugin a couple of days ago so I will try it out too.

I am now understanding how to query my tasks better, as well as create columns within SiYuan so I can display TODO, NEXT, DOING, DONE as well as priority, project or date filtering which can be really helpful in managing tasks. I mention these thing in case they are helpful ideas for your plugin.

I will indeed try the plugin as I mentioned - It will be useful for sure to have a drop down task list available indepenent of which tab I have open, so it should suppliment my task workflow very well.

Thanks again

Well I finally managed to create some columns (not in super block) by dragging stuff around in the GUI. It did crash SiYuan a couple of times before I could get it to do what I wanted.

So it looks as though this functionality just needs some bug fixing.

It's currently quite hard to get things to snap to the position you want them in.

But the fact it can even do this at all is still a vast improvement over Logseq or Obsidian IMO.

I am finding more and more that there is usually a way to get it to do the things I want, without requiring a million plugins or a degree in markdown!

Thank you SiYuan developers - keep up the good work :)

Hi

Thanks for sharing this.

When you say you first created horizontal "superblock" and then several vertical ones, can you explain how you achieved that?

I have been trying to create columns that I can then put embeds in, so that I can have queries showing my tasks in different columns; similar to kanban style.

But trying to achieve that in the GUI seems to always fail. It would be great if it could work that way.

I have the Monaco integrated edit environment plugin - but it seems that it doesn't actually allow you to edit! only to view in markdown etcetera.

So next I will try editing in Markdown offline and then importing templates etcetera...sadly I am quite new to markdown as well as SQL - so it will probably be a slow process.

OK so after looking at the sql in the template mentioned above, I noticed it does NOT have "{{...}}". So I tried the above sql again; but this time WITHOUT the curly brackets...and viola it works!😄

I have since tried the "Simple Todo" Template, which seems to work to some degree: for example to pull in tasks from within the last month it creates and embed with the following sql:

SELECT * from blocks WHERE type = "l" AND subtype = "t" AND created >= strftime('%Y%m%d%H%M%S', datetime('now', '-1 month')) AND markdown REGEXP "\* \[ \] \S+" AND parent_id not in ( select id from blocks where subtype = "t" ) ORDER BY created DESC

Hope this might help someone.

Looks like I need to learn some sql query language :)

I am also trying to achieve the same thing; so I copied and pasted these queries ; but I get the same error message as the original poster: "Search content block does not exist".

It would be great to have a built in configurable tasks dashboard or kanban in the future.

But for now I would just be happy if I could get this to work

Many thanks in advance for any help