You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
As for today the account_balances view sums the balance of all account.
Change that to only include active accounts:
create or replaceviewaccount_balancesasselect currency, sum(balance) as value, cast(avg(precision) asinteger) as precision
from accounts
whereaccounts.active= true
group by currency;
The text was updated successfully, but these errors were encountered:
As for today the
account_balances
view sums the balance of all account.Change that to only include
active
accounts:The text was updated successfully, but these errors were encountered: