Widgets

Widgets are the building blocks of your Dashboards. Each widget runs a SQL query against your live data and renders the results as a bar chart, line chart, pie chart, KPI card, or data grid — your choice. You write the query, configure the presentation, and CifraHQ handles the rest. Add the same widget to multiple Dashboards, and a single query update flows through everywhere it appears.

Where to find it

Go to Setup > Reporting > Widgets.

How to create a widget

1. Click New.
2. Enter a Name and optional Description.
3. Save — the widget detail page opens.
4. Write the SQL query that fetches the data you want to display. Use the Query Builder to prototype your SQL against live data first, then paste the working query here.
5. Configure the Presentation Options — choose the chart type and map your query columns to the visual axes (e.g., which column is the X axis, which is the value).

Import / Export

• Export — click the download icon on a widget row to save it as a JSON file. Share it with another CifraHQ tenant or keep it as a backup before making structural changes to the query.
• Import — click + Data Entry > Import to restore or copy a widget from a JSON file.

Tips

• Use the Query Builder to test and refine your SQL against real data before creating the widget — it's faster to iterate there than in the widget editor.
• A single widget can appear on multiple Dashboards simultaneously. When you update the widget's query or presentation settings, every Dashboard that uses it reflects the change automatically — no need to update each dashboard individually.
• Presentation Options are stored as JSON behind the scenes, but the visual editor handles that for you. You don't need to write JSON manually.

Related: Dashboards · Query Builder · Financial Reports · Inventory Report