Not at the moment. In the next iteration of the SQL client design the virtual tables will be by type of directive. That is, you will be able to do something like
select * from balance; and so on. That work hasn't even started yet, but I think that's a better strategy than what I built in the first version. On Wed, Apr 26, 2017 at 11:07 AM, <[email protected]> wrote: > Hello All, > > Is there a way to query directives which are not transactions? > Currently I'm seeing this: > > beancount> select * where type != "transaction" > > (empty) > > beancount> > > > > The problem I'm trying to solve is invoice generation: want to store > client-specific metadata (e.g.: address) in the ledger somewhere; then > query them and have the results be the various fields of the generated > invoice. > > An example might be: > > 2017-03-01 note *Assets:Credits:CLIENT* "Via Lungolago 13, > CH-6900 Lugano" #address > > And an example query might be: > > SELECT last(narration) FROM (type = "note") AND ("address" in tags) WHERE > account = "*Assets:Credits:CLIENT*" > ... assuming that a note's text field is referred to as "narration". > > This would have the advantage of being able to declare new addresses if > the client moves. > The #address tag is so that other notes may exist without breaking this > query. > > > > I'm not sure if this is the way this problem should be solved, maybe a > different approach is best? > > Thank you very much, > > Sirio > > -- > 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/e0ef1c87-578f-4656-aeb7-d3cc9716352c%40googlegroups.com > <https://groups.google.com/d/msgid/beancount/e0ef1c87-578f-4656-aeb7-d3cc9716352c%40googlegroups.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- 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/CAK21%2BhPnyqRtFU7jD0naf8vrCiz%3DXRDJjeJKq%3DDat49_JAj9aA%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
