Where can I find all the columns available in beanquery

[CD]

I'm using Beancount 3.0 and have been creating scripts that use queries to get information.  The problem is I don't understand the query language that well and can't find current documentation that goes into a lot of detail.  Also, most AI's aren't that familiar either and end up giving me many queries that don't work.

What are all the columns that are available in 'postings'?  Is there a place I can find those?

For example, what query would replicate the "Journal" view in Fava?

-Chris

[Red S]

In the `bean-query` shell:

help help targets journal

​

[Daniele Nicolodi]

On 06/07/25 17:15, CD wrote:
> I'm using Beancount 3.0 and have been creating scripts that use queries
> to get information.  The problem is I don't understand the query
> language that well and can't find current documentation that goes into a
> lot of detail.  Also, most AI's aren't that familiar either and end up
> giving me many queries that don't work.
>
> What are all the columns that are available in 'postings'?  Is there a
> place I can find those?

You can use:

.describe postings

with the leading dot, in the bean-query shell to get a list of the
columns and their type. The syntax is

.describe [table | structured type]

Cheers,
Dan