Is there a way to query database to create custom views?

I am using the database to impliment a GDT style task management system

image.png

Is there a way to query the contents of the database or the rows to impliment custom views on due date, priority, tasks by project etc.

I am trying to query like this but dont see any results

image.png

    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 ...
    • chemacortes
      VIP Warrior

      Don't use block queries with databases. Make all views with the database interface. With a simply copy/paste, you get synced copies of the database where you need the view.

      1 Reply
    • czumaa

      i'm trying the same, have a database full of tasks, create a new page called Pending Board and copy the database and paste it in the other page, then apply some filters.

      The idea is, Title: Pendings for today... pendings high priority... and so on

      so i try to make a dashboard, by my surprise, if i apply a filter, the original and all their copies apply the same filter.

      I try copy mirror, copy embed ... duplicate mirror...

      The interesting part is that i found on top of database title a + sign called "add view"

      and the view is exactly what i need.

      if you add a new view to the database, you can segment your own filters and works as spected so i create many views and every view with their own filters..

      The problem is i don't know how i can "copy" only the view i'm interested and move it to another page so i can "isolate" the view.

      for now i just click on the buttons to change the view, it works, but will be great to "split" or "isolate" the view so i can move it to another place.

      the buttons start to see ugly and don't stack so ... yeah