SaveDatabaseQuery
Save a read-only SELECT as a live question and get back the block that shows its answer. Paste the returnedmarkdown verbatim, into your reply or into a document with CreateDocument/EditDocument, and it renders as a live number, table, or chart that re-runs for whoever views it, with their permissions, so it stays current as the data changes.
Use it whenever the user asks a question about their data or asks for a chart. Run the SELECT with QueryDatabase first to check it returns what you expect, then save exactly that SQL. The SQL is QueryDatabase’s dialect, described there, limited to one SELECT.
displayMode:scalarfor one number (a single COUNT/SUM/AVG),tablefor rows,barto compare categories,linefor a trend over an ordered column,areafor a trend whose series add up to a whole,scatterto plot one numeric column against another,piefor shares of a whole.chart(bar/line/area/scatter/pie):xis the label column andythe numeric result columns, named exactly as the result columns are; alias aggregates (COUNT(*) AS invites) so they have stable names.colornames a result column whose values split oneyseries into one series per value (e.g. invites per party colored by status);stackstacks bar or area series instead of setting them side by side.- Pass
databaseIdso the question resolves against that database’s tables.