I found a query to help remind me which accounts need attention from this 
conversation 
<https://groups.google.com/g/beancount/c/MJYbx6Au7TM/m/yw-sr3PJAQAJ> last 
year:

    SELECT account, max(date) as date FROM #balances GROUP BY account ORDER 
BY date

Is there any "WHERE not close"d option? I tried the postings-table 
close_date function, but...

    SELECT account, max(date) as date FROM #balances WHERE NOT 
close_date(account) GROUP BY account ORDER BY date
error: 
...
AttributeError: 'Balance' object has no attribute 'open_close_map'

I wasn't sure if this "implement balances ... where syntax 
<https://github.com/beancount/beanquery/issues/180>" issue was related. 
It's not terrible to script picking balances out of the directives list in 
python, but seems so close to a simple query-based solution.

Thanks,
Paul

-- 
You received this message because you are subscribed to the Google Groups 
"Beancount" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To view this discussion on the web visit 
https://groups.google.com/d/msgid/beancount/9ef9ba4c-b8e8-4a08-a7e3-aa7848e53ce0n%40googlegroups.com.

Reply via email to