SaveDatabaseQueryCopy Anchor Link

Save a read-only SELECT as a live question and get back the block that shows its answer. Paste the returned markdown verbatim into your reply or a CreateDocument document, or quote it verbatim in EditDocument's instructions, 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: scalar for one number (a single COUNT/SUM/AVG), table for rows, bar to compare categories, line for a trend over an ordered column, area for a trend whose series add up to a whole, scatter to plot one numeric column against another, pie for shares of a whole.
• chart (bar/line/area/scatter/pie): x is the label column and y the numeric result columns, named exactly as the result columns are; alias aggregates (COUNT(*) AS invites) so they have stable names. color names a result column whose values split one y series into one series per value (e.g. invites per party colored by status); stack stacks bar or area series instead of setting them side by side.
• Pass databaseId so the question resolves against that database's tables.

Saved questions never change, and a block you write or edit yourself does not work. To change one, save a new one and use its new block. EditDocument can restyle a block already in a document (chart type, title, height) and switch an embedded database to another table or view by its tableId/viewId.

ParametersCopy Anchor Link