Database query help

I am using databases for task tracking. I prefer it over the normal built in task checkboxes, because I can have due dates, links, and status'.

I am trying to generate an embedded block query to return all rows from any database with the name project_task, that has a value of To Do or In progress in the Status column.

I can retrieve the databases easy enough but it flattens the content into a single string making it extremely difficult to parse in a generalized way.

Is there a way to retrieve the underlying database JSON or is there a way to return the rows I am looking for?

    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 ...