mirror of
https://github.com/actualbudget/actual.git
synced 2026-11-16 12:10:22 -06:00
Closed
opened 2026-05-16 12:22:07 -05:00 by GiteaMirror
·
6 comments
No Branch/Tag Specified
master
matiss/enable-banking-pending-and-rate-limit
claude/lucid-turing-br8zwl
jfdoming/api-key-shared-bank-sync
worktree-pr-description-rules
ios-ci-launch-test
theme-number-contrast
theme-contrast-test
fix/automatic-bank-sync-mobile-app
future-buffer
carryover-chain
copilot/fix-failing-github-actions-job
copilot/fix-failing-github-actions-job-compare
fix/hide-sab-warning-in-capacitor
release
tabedzki/feat/docker-non-root
ios-home-screen-widgets
mobile-budget-redesign
ai/fix-mobile-carryover-arrow-alignment
jfdoming/provider-identity-update
jfdoming/electron-signin-update
jfdoming/openid-flow-update
release-update/26.10.1
release-notes/26.10.1
matiss/dazzling-babbage-b9rjwi
react-query-rules
ai/add-loan-formula-autocomplete
claude/pr-8519-regression-testing-fhvrrh
speed-up-transaction-list-and-schedules
fix-slow-balance-recompute-on-transaction-edit
jfdoming/opfs-sahpool-mobile
jfdoming/opfs-sahpool
fix-8612-schedule-delete-menu
jfdoming/api-tokens-part-8
jfdoming/api-tokens-part-7
jfdoming/api-tokens-part-6
jfdoming/api-tokens-part-5
jfdoming/mobile-safe-area-header
jfdoming/api-tokens-part-4
jfdoming/mobile-splash-lifecycle
jfdoming/api-tokens-part-3
jfdoming/mobile-shared-array-buffer
jfdoming/api-tokens-part-2
jfdoming/api-tokens-part-1
persist-transaction-filters
claude/modernize-transactions-tanstack-orgrze
bank-sync-per-file-03-pluggy-loot-core
claude/auto-close-prs-no-profile-pic-mjqpsy
cross-version-sync-stage2
claude/react-table-library-research-afx83z
tolerate-newer-migrations
claude/verify-migration-guardrails-i82c8m
tabedzki/feat/replacing-month-picker-with-day-picker
delay-initial-sync-until-loaded
cross-version-sync-compat
jfdoming/mobile-app-updates
claude/budget-version-migration-compat-151jlr
claude/worker-error-serialization-9iqtl7
claude/issue-8401-regression-test-9nw9l3
jfdoming/mobile-app-foundation-part-1
jfdoming/mobile-app-scaffold
ai-fix-cleanup-def-8290
claude/relaxed-shannon-jusywa
claude/fervent-keller-s6f2fq
claude/determined-feynman-st1y9z
claude/wizardly-einstein-vi2wce
claude/sweet-albattani-7nseio
feat/bank-sync-per-budget-file
claude/affectionate-cannon-y0kc82
claude/dependabot-findings-m9pgmb
claude/mac-app-ios-publish-zjs1lz
claude/vigilant-tesla-aiiyos
claude/quirky-cerf-v5qck7
claude/animation-removal-alternative-2etfh1
claude/netlify-preview-comments-consolidate-9XPYa
osc/7391-error-boundaries-reports
claude/pensive-dijkstra-7DYui
claude/server-app-version-mismatch-HTCGv
claude/pr-8027-review-feedback-mELuO
claude/zealous-wozniak-e5pO0
claude/intelligent-heisenberg-BSHJq
claude/translation-download-refactor-jFRsO
claude/mobile-performance-ideas-G9PAO
claude/github-issue-7988-5A5ly
blacksmith-migration-ff70d2d
claude/great-mayer-KRvOk
claude/react-native-ios-compilation-fcJh5
claude/serene-goldberg-58xv0
claude/kind-euler-LVG3K
release-automation/edge-nightly
7710-bundle-migrations
claude/fix-docker-build-error-WMfed
claude/llm-compatible-release-notes-t20Nr
7710-tests-tdd
cursor/transaction-table-rewrite-f077
claude/plan-ci-secure-context-OtEe1
claude/fix-issue-7667-DPXi3
cursor/resolve-pr-7449-ee11
claude/fix-typescript-build-error-JPtZ5
copilot/add-repository-configs-to-packages
worktree-compressed-drifting-ritchie
claude/api-consumer-verification-kfz1K
pr-7454
claude/fix-issue-7410-LLLQ4
revert-7281-generate-icons
react-query-useSchedules
copilot/sub-pr-6140
package-upgrades
v26.11.0
v26.10.0
v26.9.0
v26.8.1
v26.8.0
v26.7.0
v26.6.0
v26.5.2
v26.5.1
v26.5.0
v26.4.0
v26.3.0
v26.2.1
v26.2.0
v26.1.0
v25.12.0
v25.11.0
v25.10.0
v25.9.0
v25.8.0
v25.7.1
v25.7.0
v25.6.1
v25.6.0
v25.5.0
v25.4.0
v25.3.1
v25.3.0
v25.2.1
v25.2.0
v25.1.0
v24.12.0
v24.11.0
v24.10.1
v24.10.0
v24.9.0
v24.8.0
v24.7.0
v24.6.0
v24.5.0
v24.4.0
v24.3.0
v24.2.0
v24.1.0
v23.12.0
v23.11.0
v23.10.0
v23.9.0
v23.8.1
v23.8.0
v23.7.2
v23.7.1
v23.7.0
v23.6.0
v23.5.0
v23.4.2
v23.4.1
v23.4.0
v23.3.2
v23.3.0
v23.2.9
v23.2.5
v23.1.12
v22.12.9
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
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
Mirrored from GitHub Pull Request
No labels
API
Milestone
No items
No Milestone
Projects
Clear projects
No projects
No Assignees
Notifications
Due Date
No due date set.
Dependencies
No dependencies set.
Reference: github-starred/actual#72342
Reference in New Issue
Block a user
Blocking a user prevents them from interacting with repositories, such as opening or commenting on pull requests or issues. Learn more about blocking a user.
Originally created by @Phil89a on GitHub (Nov 8, 2025).
Original GitHub issue: https://github.com/actualbudget/actual/issues/6089
Verified issue does not already exist?
What happened?
Trying to access the column TYPE from the Accounts Table using ActualQL
const tquery = api.q('accounts') .select(['*']); const accountsResult = await api.aqlQuery(tquery);This returns the columns ....
{ "id": "4dc4b8a6-292d-4357-97f0-c343a74c242e", "name": "xxxxxxxxxxxx", "offbudget": false, "closed": false, "sort_order": 4096, "tombstone": false, "account_id": "5cd7b838-1bc6-4652-be3b-e8620af8559e", "official_name": null, "account_sync_source": "goCardless", "last_reconciled": "1762597320355", "last_sync": "1762581605830" },Missing for my requirement is the TYPE column - but also a number of other columns are missing. It seems TYPE is returned using the API getAccounts, but I am using ActualQL, so I can pull the reconciled and sync columns.
How can we reproduce the issue?
Run an ActualQL query against the accounts table; for example:
const tquery = api.q('accounts') .select(['*']); const accountsResult = await api.aqlQuery(tquery);Where are you hosting Actual?
Docker
What browsers are you seeing the problem on?
Safari
Operating System
Mac OSX
@MatissJanis commented on GitHub (Nov 10, 2025):
👋
I'm a bit confused: what column is missing? Could you please provide the output you receive from using the AQL query and also the output you receive from
api.getAccounts()? These are the columns api.getAccounts() returns.Note:
Easier reproduction: use this:
window.$query(window.$q('accounts').select(['*']));in browser console.@Phil89a commented on GitHub (Nov 10, 2025):
I am looking for the TYPE column as returned in the getAccount API - this column is not being returned from the ActualQL against the Accounts table...
@MatissJanis commented on GitHub (Nov 10, 2025):
Thanks! There actually is no
typecolumn for accounts. It was removed ~2 years ago, but the docs were not updated.I have fixed the docs here: https://github.com/actualbudget/actual/pull/6106
@Phil89a commented on GitHub (Nov 10, 2025):
Shame - I can see it is still in the tables and I had great use for it :-) But have worked around it now (I needed to group Accounts into different groups; e.g. Bank Accounts, Credit Cards, Savings, etc.)
@MatissJanis commented on GitHub (Nov 10, 2025):
Weird that you still have it. Are you running an old version?
It was removed here https://github.com/actualbudget/actual/blob/matiss/docs-remove-account-type-reference/packages/loot-core/migrations/1686139660866_remove_account_type.sql#L6:L6
@Phil89a commented on GitHub (Nov 10, 2025):
Latest version but my budget files are very old - just looked at the definition for my local file just synced from the server....
create table accounts
(
id TEXT
primary key,
account_id TEXT,
name TEXT,
balance_current INTEGER,
balance_available INTEGER,
balance_limit INTEGER,
mask TEXT,
official_name TEXT,
subtype TEXT,
bank TEXT,
offbudget INTEGER default 0,
closed INTEGER default 0,
tombstone INTEGER default 0,
sort_order REAL,
type TEXT,
account_sync_source TEXT,
last_sync text,
last_reconciled text
);