Some columns are missing from the transactions table

[Ev2geny]

By comparing the .help from with .describe transactions it appears, that there are several transaction columns, which are available for filtering in the FROM clause, but are not available in the transactions table (in the .describe transactions).

These columns are:

id: str
year: int
month: int
day: int
filename: str
lineno: int

[dnicolodi]

This is mostly a design decision. There is a lot of redundancy in the fields exposed in the postings table and I did not want to replicate it in the new tables. I would actually like to deprecate and remove some of the fields in the postings table (that is what the non-standard FROM expression iterates over).

The only column that is not available via other means is id. I didn't have an use for it so far and I didn't notice it is missing. It can be added, but I would like to know what you need it for.

For the others:

• year is year(date) or date.year
• month is month(date) or date.month
• day is day(date) or date.day
• filename is meta['filename']
• lineno is meta['lineno']

[Ev2geny]

The only column that is not available via other means is id. I didn't have an use for it so far and I didn't notice it is missing. It can be added, but I would like to know what you need it for.

It is more for consistency and to avoid confusion for newcomers, than anything else. I noticed this when working on the Interactive beanquery manual. I made a comparison table and the fields I mentioned in this issue are the ones, I found inconsistent. Thought I agree, there is a lot of redundancy.