Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jasper Report: `Summary and balance list` - Summen- und Saldenliste #6190

Open
TheBestPessimist opened this issue Feb 14, 2020 · 0 comments
Open
Assignees

Comments

@TheBestPessimist
Copy link
Member

@TheBestPessimist TheBestPessimist commented Feb 14, 2020

Is this a bug or feature request?

FR

What is the current behavior?

Which are the steps to reproduce?

What is the expected or desired behavior?

@TheBestPessimist TheBestPessimist self-assigned this Feb 14, 2020
TheBestPessimist added a commit that referenced this issue Feb 17, 2020
Seems like this reduces query time to about 70% of original. (30% reduction)

#6190
TheBestPessimist added a commit that referenced this issue Feb 17, 2020
TheBestPessimist added a commit that referenced this issue Feb 18, 2020
Seems like this reduces query time to about 70% of original. (30% reduction)

#6190
TheBestPessimist added a commit that referenced this issue Feb 18, 2020
TheBestPessimist added a commit that referenced this issue Feb 18, 2020
TheBestPessimist added a commit that referenced this issue Feb 18, 2020
TheBestPessimist added a commit that referenced this issue Feb 18, 2020
TheBestPessimist added a commit that referenced this issue Feb 18, 2020
Seems like this reduces query time to about 70% of original. (30% reduction)

#6190
TheBestPessimist added a commit that referenced this issue Feb 18, 2020
TheBestPessimist added a commit that referenced this issue Feb 18, 2020
TheBestPessimist added a commit that referenced this issue Feb 19, 2020
TheBestPessimist added a commit that referenced this issue Feb 19, 2020
TheBestPessimist added a commit that referenced this issue Feb 19, 2020
TheBestPessimist added a commit that referenced this issue Feb 19, 2020
…#6200)

* Use CTE instead of pasting the same query 4 times.

Seems like this reduces query time to about 70% of original. (30% reduction)

#6190

* First draft of SummaryAndBalanceListReport

#6190

* Stop filtering by `c_elementvalue.c_activity_id`

#6190

* DROP INDEX fas_dateacct

#6190

* Add migration script

#6190

* Rename report to `SummaryAndBalanceReport` from `SummaryAndBalanceListReport`

#6190

* Exclude empty lines via param

#6190

* Add migration script for Summary and Balance Report

#6190

* Remove redundant order by inside CTE

#6190
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
1 participant
You can’t perform that action at this time.