#Query data in SQL mode

In the Data query panel, switch to SQL mode, write and run the query, and use the returned result directly for chart mapping and rendering.

#Write SQL statements

• In the Data query panel, choose SQL mode.
• Enter SQL and click Run query.
• Supports complex statements including multi‑table JOIN and VIEW.

Example: order amount by month

SELECT 
  TO_CHAR(order_date, 'YYYY-MM') as mon,
  SUM(total_amount) AS total
FROM "order"
GROUP BY mon
ORDER BY mon ASC
LIMIT 100;

#View results

• Click View data to open the preview panel.

Data supports pagination; you can switch between Table and JSON to check column names and types.

#Field mapping

• In Chart options, map fields based on the query result columns.
• By default, the first column is used as the dimension (X axis or category), and the second column as the measure (Y axis or value). Mind the column order in SQL:

SELECT 
  TO_CHAR(order_date, 'YYYY-MM') as mon, -- dimension field in the first column
  SUM(total_amount) AS total -- measure field afterwards

#Use context variables

Click the x button at the top‑right of the SQL editor to choose context variables.

After confirming, the variable expression is inserted at the cursor (or replaces the selected text).

For example, {{ ctx.user.createdAt }}. Do not add extra quotes.

#More examples

For more examples, see the NocoBase Demo app

Recommendations:

• Stabilize column names before mapping to charts to avoid errors later.
• During debugging, set LIMIT to reduce returned rows and speed up preview.

#Preview, save, and rollback

• Click Run query to request data and refresh the chart preview.
• Click Save to persist the current SQL text and related configuration to the database.
• Click Cancel to revert to the last saved state and discard current unsaved changes.