[GH-ISSUE #5787] [FR] Query field type #2577

New issue

Open

opened 2026-03-23 21:23:30 +00:00 by mirror · 0 comments

mirror commented

2026-03-23 21:23:30 +00:00

Owner

Originally created by @zoli on GitHub (Jul 22, 2024).
Original GitHub issue: https://github.com/AppFlowy-IO/AppFlowy/issues/5787

Description

A query field type to enable fetching data from all databases and working with them.
My specific use case is to get the total time I've spent on my tasks this week, month, and year. Also, being able to filter them by their status and tags.
So for example, I have 3 databases named "Work", "Home", "Study" and all three have "Status", "Tag", "Spent time" field. Having query field type will enable me to create a fourth database let's name it "Summary". It will have 2 fields one primary which is text and the second one query field type. On each row I will be able to calculate total spent time on each database separately and also all 3 databases together. For example the query type field cell for total spent time on Home will be STH like this select sum('Spent time') where 'Status' = 'Done' from 'Home'.

Impact

Probably this will be useful to more advanced users who intend to get some sort of summary from their data in all databases (grids, boards, ...).

Additional Context

Somehow related to #2813 (the scope of this issue is document, not database field type).

Originally created by @zoli on GitHub (Jul 22, 2024). Original GitHub issue: https://github.com/AppFlowy-IO/AppFlowy/issues/5787 ### Description A query field type to enable fetching data from all databases and working with them. My specific use case is to get the total time I've spent on my tasks this week, month, and year. Also, being able to filter them by their status and tags. So for example, I have 3 databases named "Work", "Home", "Study" and all three have "Status", "Tag", "Spent time" field. Having query field type will enable me to create a fourth database let's name it "Summary". It will have 2 fields one primary which is text and the second one query field type. On each row I will be able to calculate total spent time on each database separately and also all 3 databases together. For example the query type field cell for total spent time on Home will be STH like this `select sum('Spent time') where 'Status' = 'Done' from 'Home'`. ### Impact Probably this will be useful to more advanced users who intend to get some sort of summary from their data in all databases (grids, boards, ...). ### Additional Context Somehow related to #2813 (the scope of this issue is document, not database field type).

Rows
Columns