Feature request
The query editor already autocompletes account names when typing a BQL query. It would be very useful to also autocomplete payee (and optionally narration) string values.
Use case
When writing a query like:
SELECT date, narration, position
WHERE payee = "..."
ORDER BY date DESC
...there is currently no way to discover or complete the payee string. You need to know the exact name. For ledgers with many suppliers/payees (e.g. a business with 80+ counterparties) this makes the query interface much less useful.
Proposed behaviour
When the cursor is inside a string literal that follows payee = or payee =~, the editor suggests matching payee values from the ledger — the same way account names are suggested after account = or in WHERE account ~ "...".
Similarly for narration, though payee is the higher-priority case.
Prior art in the codebase
Account autocomplete is already implemented — payee values are a natural extension of the same mechanism. The unique payee list is cheap to derive from the entries at ledger-load time.
Environment
- Fava 1.29
- Beancount 2.3.6
Feature request
The query editor already autocompletes account names when typing a BQL query. It would be very useful to also autocomplete payee (and optionally narration) string values.
Use case
When writing a query like:
...there is currently no way to discover or complete the payee string. You need to know the exact name. For ledgers with many suppliers/payees (e.g. a business with 80+ counterparties) this makes the query interface much less useful.
Proposed behaviour
When the cursor is inside a string literal that follows
payee =orpayee =~, the editor suggests matching payee values from the ledger — the same way account names are suggested afteraccount =or inWHERE account ~ "...".Similarly for
narration, though payee is the higher-priority case.Prior art in the codebase
Account autocomplete is already implemented — payee values are a natural extension of the same mechanism. The unique payee list is cheap to derive from the entries at ledger-load time.
Environment