github-starred/actual
2
0
Fork 0
mirror of https://github.com/actualbudget/actual.git synced 2026-07-16 07:04:23 -05:00
Code Issues 3.0k Packages Projects Releases 58 Wiki Activity

[GH-ISSUE #5727] [Feature] Advanced Reporting (Query Editor) #51598

New Issue
Closed
opened 2026-04-30 18:29:38 -05:00 by GiteaMirror · 6 comments
GiteaMirror commented 2026-04-30 18:29:38 -05:00
Owner
Copy Link

Originally created by @Spuddy on GitHub (Sep 14, 2025).
Original GitHub issue: https://github.com/actualbudget/actual/issues/5727

Verified feature request does not already exist?

  • I have searched and found no existing issue

💻

  • Would you like to implement this feature?

Pitch: what problem are you trying to solve?

Custom SQL / ActualQL queries for reports.

The ability to create any custom report using standard query language.

Describe your ideal solution to this problem

  • Ability to create custom reports using a query language such as ActualQL or SQL.
  • UI with text editor for editing queries.
  • Eventual ability to create a report with the UI, then view and tweak the code of the report.
  • Eventual migration of all existing reports to this format, so they can be expanded on as users please.

Teaching and learning

  • Report type toggle (Graphical UI / Code) in report editing page.
  • Documented relational diagrams for the entire database.
  • Quick reference help popup linked on report editing page and/or contextually in help menu.
  • Examples
Originally created by @Spuddy on GitHub (Sep 14, 2025). Original GitHub issue: https://github.com/actualbudget/actual/issues/5727 ### Verified feature request does not already exist? - [x] I have searched and found no existing issue ### 💻 - [ ] Would you like to implement this feature? ### Pitch: what problem are you trying to solve? Custom SQL / ActualQL queries for reports. The ability to create any custom report using standard query language. ### Describe your ideal solution to this problem - Ability to create custom reports using a query language such as ActualQL or SQL. - UI with text editor for editing queries. - Eventual ability to create a report with the UI, then view and tweak the code of the report. - Eventual migration of all existing reports to this format, so they can be expanded on as users please. ### Teaching and learning - Report type toggle (Graphical UI / Code) in report editing page. - Documented relational diagrams for the entire database. - Quick reference help popup linked on report editing page and/or contextually in help menu. - Examples
GiteaMirror added the needs votesfeature labels 2026-04-30 18:29:39 -05:00
GiteaMirror commented 2026-04-30 18:29:51 -05:00
Author
Owner
Copy Link

@github-actions[bot] commented on GitHub (Sep 14, 2025):

✨ Thanks for sharing your idea! ✨

This repository uses a voting-based system for feature requests. While enhancement issues are automatically closed, we still welcome feature requests! The voting system helps us gauge community interest in potential features. We also encourage community contributions for any feature requests marked as needing votes (just post a comment first so we can help guide you toward a successful contribution).

The enhancement backlog can be found here: https://github.com/actualbudget/actual/issues?q=label%3A%22needs+votes%22+sort%3Areactions-%2B1-desc+

Don’t forget to upvote the top comment with 👍!

<!-- gh-comment-id:3289996407 --> @github-actions[bot] commented on GitHub (Sep 14, 2025): :sparkles: Thanks for sharing your idea! :sparkles: This repository uses a voting-based system for feature requests. While enhancement issues are automatically closed, we still welcome feature requests! The voting system helps us gauge community interest in potential features. We also encourage community contributions for any feature requests marked as needing votes (just post a comment first so we can help guide you toward a successful contribution). The enhancement backlog can be found here: https://github.com/actualbudget/actual/issues?q=label%3A%22needs+votes%22+sort%3Areactions-%2B1-desc+ Don’t forget to upvote the top comment with 👍! <!-- feature-auto-close-comment -->
GiteaMirror commented 2026-04-30 18:29:56 -05:00
Author
Owner
Copy Link

@Spuddy commented on GitHub (Sep 14, 2025):

Link to Icebox:
https://github.com/orgs/actualbudget/projects/5/views/1?pane=issue&itemId=117824101

<!-- gh-comment-id:3289997621 --> @Spuddy commented on GitHub (Sep 14, 2025): Link to Icebox: https://github.com/orgs/actualbudget/projects/5/views/1?pane=issue&itemId=117824101
GiteaMirror commented 2026-04-30 18:30:02 -05:00
Author
Owner
Copy Link

@jbyrnescu commented on GitHub (Sep 18, 2025):

Can I join the design and implementation team? Or is this a closed development group who does the implementation? Who do I talk to?

<!-- gh-comment-id:3309938335 --> @jbyrnescu commented on GitHub (Sep 18, 2025): Can I join the design and implementation team? Or is this a closed development group who does the implementation? Who do I talk to?
GiteaMirror commented 2026-04-30 18:30:10 -05:00
Author
Owner
Copy Link

@jfdoming commented on GitHub (Sep 18, 2025):

Can I join the design and implementation team? Or is this a closed development group who does the implementation? Who do I talk to?

There's a core group of maintainers, but we review and accept PRs from anyone provided the PR is well-written and aligns with the project vision! A contribution on this feature would definitely be reviewed.

<!-- gh-comment-id:3309946442 --> @jfdoming commented on GitHub (Sep 18, 2025): > Can I join the design and implementation team? Or is this a closed development group who does the implementation? Who do I talk to? There's a core group of maintainers, but we review and accept PRs from anyone provided the PR is well-written and aligns with the project vision! A contribution on this feature would definitely be reviewed.
GiteaMirror commented 2026-04-30 18:30:14 -05:00
Author
Owner
Copy Link

@jbyrnescu commented on GitHub (Sep 19, 2025):

What about discussions? Is there a discussion group for this feature? It seems to me that using a pre-existing/already implemented Node.js sql query editor and integrating would be the way to go.
And... As far as charts are concerned. I think that's a feature in itself. (This one is too big, not exactly "agile") It needs to be broken up into smaller tasks or features. One feature would be the query editor, and another charts (maybe even a feature for each chart or chart type), and another for ER diagrams.

<!-- gh-comment-id:3314247734 --> @jbyrnescu commented on GitHub (Sep 19, 2025): What about discussions? Is there a discussion group for this feature? It seems to me that using a pre-existing/already implemented Node.js sql query editor and integrating would be the way to go. And... As far as charts are concerned. I think that's a feature in itself. (This one is too big, not exactly "agile") It needs to be broken up into smaller tasks or features. One feature would be the query editor, and another charts (maybe even a feature for each chart or chart type), and another for ER diagrams.
GiteaMirror commented 2026-04-30 18:30:17 -05:00
Author
Owner
Copy Link

@Spuddy commented on GitHub (Sep 20, 2025):

Yes, agreed. Some of those extra ideas would be for down the road. Hopefully it helps people to see the big picture.

Probably good to clarify and focus on the basic initial scope.

Discord discussion

<!-- gh-comment-id:3314410800 --> @Spuddy commented on GitHub (Sep 20, 2025): Yes, agreed. Some of those extra ideas would be for down the road. Hopefully it helps people to see the big picture. Probably good to clarify and focus on the basic initial scope. [Discord discussion](https://discord.com/channels/937901803608096828/1417378218003923016)
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
AI generated
API
bank sync
budgeting
bug
can’t replicate
dependencies
docker
documentation
electron
experimental feature
feature
feedback
goal templates
good first issue
help wanted
importers
maintenance
needs info
needs testing
needs triage
needs votes
openid
payees
pull-request
Mirrored from GitHub Pull Request
 regression
reports
responsive
rules
schedules
server
✨ merged
split transactions
tech debt
tech-support
theme
transaction import
transaction reconciliation
transactions
translations
upstream
user interface
✅ approved
wontfix
No Label feature needs votes
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
GiteaMirror ninjasurge
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/actual#51598
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?