Aggregation on search
George Pegos
Mmm
George Pegos
Thanks for your reply Mmm!
I was thinking of something quicker and more flexible. Let me explain:
I’m building a library (or database) to store all my financial transactions. Each transaction is saved as a new entry.
For every entry, I’d like to include tags — however, I don’t yet know all possible tags in advance, and there might be too many to justify creating a separate SQL filter for each one.
Example entries:
1, 22/10/2025, 120 EUR, Supermarket, ..., #food
4, 23/10/2025, 40 EUR, Sweet store, ..., #birthday #Jason
23, 24/10/2025, 10 EUR, Bill, ..., #house
26, 26/10/2025, 30 EUR, Book store, ..., #Jason #birthday #gifts
I’d like to be able to see how much I spent for Jason’s birthday, for example, by simply filtering entries that include both tags #birthday and #Jason.
With an advanced search, this becomes much faster and easier for anyone to use — without the need for SQL queries or JavaScript code.
However, I’d like to know if there’s a way to aggregate search results — for instance, automatically summing up the total amount for the filtered entries.
Additionally, I want to handle split transactions.
Imagine the supermarket transaction from the example above — how could I split that entry into parts (e.g. groceries vs. cleaning supplies) while keeping the total and tags manageable?
One entry for the transaction but with more parts such as:
80 EUR, #groceries
40 EUR, #meat
Thanks
Er Mo
I didn't quite understand your plan. Have you tried grouping? I could imagine filtering by year/month and grouping by the number entered in the # field.
