v3.7.0

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