frappe/insights v3.7.0 on GitHub

What's Changed

Features

feat: update frappe-ui to v0.1.256 by @nextchamp-saqib in #717
feat: search field in unresolved locations dialog by @shahzeelahmed in #747
feat: add favorites functionality to dashboards list by @shahzeelahmed in #748
feat: upgraded custom measure editor by @shahzeelahmed in #741
feat: table import jobs for api data by @nextchamp-saqib in #757
feat: Add icon selection for dashboard filters with visual picker by @bhushan-barbuddhe in #640
feat: refresh stored tables for a query & hide series from chart by @nextchamp-saqib in #795
feat: add deprecation warning for Insights v2 by @nextchamp-saqib in #820
feat(ci): add linters by @shahzeelahmed in #835
feat: add fy granularity to charts by @shahzeelahmed in #922
feat: wrap user-facing strings with __() in src2 for i18n by @Copilot in #927
feat: add column width and text wrap options by @nextchamp-saqib in #934
feat: sankey chart by @nextchamp-saqib in #938
feat: default filter values in dashboard (backport #799) by @mergify[bot] in #1003
feat: drill down into summarized source queries (backport #1006) by @mergify[bot] in #1007
feat: add pivot operation in query builder (backport #1008) by @mergify[bot] in #1009
feat: support JSON and JSONL file uploads (backport #1012) by @mergify[bot] in #1014
feat: query pagination (backport #1010) by @nextchamp-saqib in #1022

Fixes

fix: Handle exceptions when sending alerts and log errors by @kelue in #738
fix: ExpandedChartDialog could not be closed after drill-down by @Dumach in #746
deps: Bump pandas and duckdb for Python 3.14 by @cogk in #739
fix(chart): color scale in pivot tables by @shahzeelahmed in #750
fix: legacy-js-api warning by @ishanloya in #745
fix: include Custom Fields when checking child table permissions by @GetayawkalGirma in #756
fix: permission issues by @shahzeelahmed in #761
fix: add before_migrate function to restore site db credentials by @shahzeelahmed in #764
Revert "fix: add before_migrate function to restore site db credentials" by @nextchamp-saqib in #765
fix: load user data before displaying team members in manage dialog by @shahzeelahmed in #766
fix: incorrect drill down results when the chart results are sorted in descending order by @shahzeelahmed in #767
fix: handle missing credentials by @nextchamp-saqib in #772
fix: bad if condition by @nextchamp-saqib in #774
fix: native query fixes by @nextchamp-saqib in #776
fix: apply role & user permissions by default on site db by @nextchamp-saqib in #783
fix: add missing get_allowed_documents import by @nextchamp-saqib in #787
fix: prevent cleanup of non-existing insights folders by @mterceno in #790
fix: redirect to workbook after duplication by @nextchamp-saqib in #797
fix: disable external access by @nextchamp-saqib in #800
fix: don't apply user permission by default by @nextchamp-saqib in #802
fix: allow temp directory access when importing to warehouse by @nextchamp-saqib in #806
fix: save workbook before inserting child documents to fix link validation error by @shahzeelahmed in #808
Revert "fix: save workbook before inserting child documents to fix link validation error" by @nextchamp-saqib in #809
fix: restrict refresh action to admin users only by @nextchamp-saqib in #812
fix: return data source and table names when team permissions disabled by @nextchamp-saqib in #813
fix: restrict access to refresh stored tables to admins only by @nextchamp-saqib in #815
fix: auto-delete all merged branches by @nextchamp-saqib in #816
fix: don't commit state before the table is committed to warehouse by @nextchamp-saqib in #817
fix: set temp directory access only on write connections by @nextchamp-saqib in #822
fix: handle warehouse connection failure by @nextchamp-saqib in #823
fix: set mariadb session to read-only by @shahzeelahmed in #821
fix: restore sql format button by @nextchamp-saqib in #829
fix: style issues after frappe-ui update by @nextchamp-saqib in #831
fix: add type hints to whitelisted methods by @shahzeelahmed in #833
fix: don't apply current filter when getting filter values by @nextchamp-saqib in #843
fix: check role even if team perms are disabled by @nextchamp-saqib in #845
fix: validate public key by @nextchamp-saqib in #847
fix: apply user permissions on data source tables in warehouse by @nextchamp-saqib in #850
fix: fetch favorite dashboards separately by @shahzeelahmed in #864
fix: enable hook for forcing types by @nextchamp-saqib in #867
fix: handle empty values in table and CTE extraction by @nextchamp-saqib in #869
fix: add type hints to whitelisted methods by @nextchamp-saqib in #871
fix: alignment of dashboard item content by @shahzeelahmed in #873
fix: get correct measure name for conditional formatting by @shahzeelahmed in #880
refactor: remove unused imports and clean up code formatting by @mterceno in #876
fix: use correct types for filters in v2 by @shahzeelahmed in #883
fix: don't fail setup wizard if demo data setup fails by @nextchamp-saqib in #885
fix: make search field sticky in region mapping dialog by @shahzeelahmed in #892
fix: permission checks and role handling in v2 APIs by @nextchamp-saqib in #894
perf: apply row limit on data store import query by @shahzeelahmed in #897
fix: use iloc for compatibility with different pandas versions by @shahzeelahmed in #900
fix: show rotate values on x-axis config by @shahzeelahmed in #904
fix: Dont override local proxy by @ankush in #906
fix: only translate when username is administrator by @shahzeelahmed in #911
fix: replace setup wizard with demo data setup by @shahzeelahmed in #905
fix: metadata conversion and url detection by @robinroy03 in #903
fix: join tables from another schema with main schema tables by @nextchamp-saqib in #917
Add localization support to data source components by @dubinet in #926
fix: expression editor issues by @nextchamp-saqib in #929
fix: query results spacing by @shahzeelahmed in #936
fix: import error on v15 by @nextchamp-saqib in #939
fix: dashboard preview generation by @nextchamp-saqib in #942
fix: set demo database type to duckdb by @shahzeelahmed in #946
Fix conditional formatting bugs and remove dead code by @Copilot in #951
Fix conditional formatting bugs and remove dead code (backport #951) by @mergify[bot] in #952
fix: user logs out after setting up demo data by @shahzeelahmed in #955
fix: user logs out after setting up demo data (backport #955) by @mergify[bot] in #956
fix: home_dir error when loading xlsx extension by @nextchamp-saqib in #957
fix: home_dir error when loading xlsx extension (backport #957) by @mergify[bot] in #958
fix: unable to copy json in safari browser by @shahzeelahmed in #959
fix: alignment of dashboard item content (backport #873) by @mergify[bot] in #968
fix: only translate when username is administrator (backport #911) by @mergify[bot] in #973
Add localization support to data source components (backport #926) by @mergify[bot] in #977
fix: show dashboard name in document title by @shahzeelahmed in #984
fix: show dashboard name in document title (backport #984) by @mergify[bot] in #985
fix: unable to upload excel/csv files (backport #964) by @mergify[bot] in #992
fix: misc fiscal year fixes (backport #994) by @mergify[bot] in #997
fix: letters dropping in ContentEditable component (backport #965) by @mergify[bot] in #1001
fix: join column auto-match, column resolution, and smarter chart defaults (backport #1004) by @mergify[bot] in #1005
fix: conditionally render prefix and suffix slots (backport #1023) by @mergify[bot] in #1024
fix: add echarts/core to optimizeDeps include list (backport #1027) by @mergify[bot] in #1028
refactor: remove sass dependency (backport #752) by @mergify[bot] in #1030
refactor: centralize circular query dependency detection (backport #1032) by @mergify[bot] in #1033
fix: add connection timeout (backport #1034) by @mergify[bot] in #1035
fix: update type hint for test_connection methods to allow None (backport #1036) by @mergify[bot] in #1037
refactor: improve deprecation messaging (backport #1040) by @mergify[bot] in #1041
fix: improve error handling and logging in table import log (backport #1045) by @mergify[bot] in #1046
fix: use locale from user (backport #1051) by @mergify[bot] in #1052
fix: measure label is reset on blur event (backport #1053) by @mergify[bot] in #1054
refactor: update SidebarLink component to use dynamic routing (backport #1049) by @mergify[bot] in #1050

New Contributors

@GetayawkalGirma made their first contribution in #756
@mterceno made their first contribution in #790
@robinroy03 made their first contribution in #903
@dubinet made their first contribution in #926

Full Changelog: v3.6.0...v3.7.0