New issue 365: nested field is displayed with its elements in arbitrary order,
e.g. SUM(VALUE(position))
https://bitbucket.org/blais/beancount/issues/365/nested-field-is-displayed-with-its
Adam Wolenc:
When displaying a nested target, for example a `SUM` of `position`s containing
more than one currency, bean-query displays the elements of this field in
arbitrary order. Is there a way to tell it to sort them by currency?
This is best illustrated by an example.
```
#!python
2000-01-04 open Assets:HOOL:Unvested:FUTURE2000 HOOL.UNVEST
2000-01-04 open Income:HOOL:Awards HOOL.UNVEST
2001-01-04 open Assets:HOOL:RSURefund USD
2001-01-04 open Income:HOOL:HoolStockUnit USD
2000-01-04 * "Award FUTURE2000"
Income:HOOL:Awards -10 HOOL.UNVEST
Assets:HOOL:Unvested:FUTURE2000 10 HOOL.UNVEST
2001-01-04 * "Vest FUTURE2000"
Income:HOOL:HoolStockUnit -1000.00 USD
Assets:HOOL:RSURefund
```
Sub accounts under Assets:HOOL now contain two currencies.
Running this query repeatedly results in one of two outputs arbitrarily.
```
#!sql
SELECT ROOT(account, 2) AS institution,
SUM(VALUE(position)) AS mkt
GROUP BY institution
ORDER BY mkt, institution DESC;
```
```
#!
institution mkt
----------- --------------------
Assets:HOOL 10 HOOL.UNVEST, 1000.00 USD
Income:HOOL -10 HOOL.UNVEST, -1000.00 USD
```
```
#!
institution mkt
----------- --------------------
Assets:HOOL 1000.00 USD , 10 HOOL.UNVEST
Income:HOOL -1000.00 USD , -10 HOOL.UNVEST
```
--
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 post to this group, send email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/beancount/20190120183410.26168.85428%40app-147.ash1.bb-inf.net.
For more options, visit https://groups.google.com/d/optout.
