Lot Date in bean-query

[Alok Parlikar]

What's the best way to get lot-date out for positions in bean-query? I have the following working, but it feels too hacky.

bean-query FILE "select date, account, position, grep('....-..-..',str(position)) as lotdate, cost(position) where account ~ 'Assets:Shares'  order by account

Alok

[Martin Blais]

I just noticed the column accessors in the SQL shell haven't been updated for the removal of "position".

I added columns cost_date and cost_label. Pull and update.

(The right solution in the long run is to support structured and repeated fields and take this shell beyond prototype stage.)

--
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 beancount+unsubscribe@googlegroups.com.
To post to this group, send email to bean...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/b0e40e64-9c68-44fc-a8ec-db4c4bd4dd7b%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.