Datatable for queries
Created a new QueryDataTable wrapper component to integrate DataTable with useQuery. This standardized UI-based query operations like renaming columns, quick filtering, sorting, loading counts, downloading results, and drill-downs.
Drill-down explorations
For drill-down exploration, query.drill_down(col, row) now creates a new query returning the drill-down results, which is interfaced with QueryDataTable and QueryOperations components, making it a simple and intuitive way to explore data.
Now, you can double-click on a cell to drill down, then group and aggregate using quick actions or perform other operations from the familiar operations sidebar.
drill-down-exploration.mp4
Sharing dashboard with specific users
Previously, you could share a dashboard by enabling public access or by sharing the workbook. There was no way to just share a dashboard with other users without sharing access to the workbook. You can now do so.
Setup data alerts
You can now setup alerts that triggers when data changes.
Minor Features
- Users can now specify schema names to fetch tables, supporting comma-separated values for multiple schemas. (84fc21d1)
- If a table cell starts with
http://orhttps://, it will be rendered as a clickable link. (a55dc9f5) - Users can now configure the number of column values displayed in pivot tables (6e852736)
- In table charts, number columns can now be selected as rows, not just string columns (7d906ba1)
- Set custom y-min and y-max for charts (19b4c4cf)
- Change data_type of a dimension via gear icon (d2fcce63)
- Added fiscal_year_start helper function (7e235bf6)
- Track dashboard views with view logs (df7d33d5)
- Option to overlap bars in charts (3a802968)
- Show read-only indicator in shared workbooks (db325f87)
- Added time_diff helper function for time calculations (539e0807)
Fixes
- Single-line expressions no longer require server scripts to be enabled (91513bec)
- Number charts now show
0instead of empty cards when no rows are returned (3cb61b9d) - Fixed drill downs not working when columns were renamed (8c20800f)
- Fixed drill downs in row charts (d027c0bd)
- Corrected logic for recent view logs (a0ac183b)
- Drill down queries now reset when closing the dialog (2ed2cd36)
- Redirect users to the setup wizard if setup is incomplete (b8dd626e)
- Enable server scripts after Docker setup (ad7bed38)
- Hide users without access in share dropdown (9b9867dc)
- Fix percent_change calculation when the previous value is 0 (0e593966)
- Dashboard filter label updates correctly after save (45329006)
- Correct percentage delta for -ve to +ve transitions (ff39b254)
- Allow changing sort order in queries (fb6977af)
- Fix download issues for query results (1e73e186)
- Ensure compatibility with Frappe v14 (2933008e)
- Fix column selector showing next step columns (fab6ce54)
- Fix 404 error on opening v3 routes (ec3a140c)