eikek / eikek/docspell

[Feature] Add simple functions to query language results

Open
#2,027 1 comment 0 reactions 0 assignees View on GitHub
restserver
Dominant language
Elm
Stars
2.3k
Forks
184
Avg merge
8h 2m
Merged PRs (30d)
4

Description

I'll try to explain by example:

I have invoices that I can submit to my insurance to get them refunded. Each invoice has amongst others the following custom fields:

- `submitted_to_insurance` (boolean, if the invoice is submitted for to the insurance already)
- `invoice_total` (numeric, the amount of money due to be paid)

The insurance wants invoices to be submitted in batches. Submissions must total at least 100,00€.

I can easily find the invoices that I need to remind myself to submit with the following query:
`(& f:eingereicht_beihilfe="false")`

However, this is annoying if the grand total of the unsubmitted invoices does not exceed 100,00€ yet. I'd love to be able to only show the results of the above query, if the sum of their custom fields `invoice_total` is greater than 100,00€.

Some functions would be needed, like:
- `sum` (for the above example)
- `minimum`
- `maximum`
- `mean`
- `count`

The results of these functions are already displayed in the UI header.

Would this be possible somehow?
Thanks for looking into this and this great software!

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.