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.

Sign up for GitHub

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

Jump to bottom

Add isInCachePeriod() function to report #147

Open
ftrotter opened this issue May 23, 2021 · 1 comment
Open

Add isInCachePeriod() function to report #147

ftrotter opened this issue May 23, 2021 · 1 comment
Assignees
@kchapple
Labels
enhancement New feature or request

Comments

@ftrotter
Copy link
Contributor

In many cases, I want to write a report that performs multiple database setup things to enable an analysis.
Like, 9 SQL queries against a data warehouse and the final report SQL (that is returned by getSQL()) is the tenth that shows the results of the previous 9 SQL statements...

But if a report is cached, then I do not want to run those 9 statements at all..
I just want to let the engine know "the 10th statement has not changed... and I want to use the cached version of this report for today".

This way, I can have a report that does extensive SQL work inside an if statement that is basically saying... "it is time to refresh all 9 SQL queries to refresh todays version of the report" and it will return todays report instantly on the 2nd through nth time the report is loaded... and only be very slow on the first run of the report.
@ftrotter ftrotter added the enhancement New feature or request label May 23, 2021
@ftrotter
Copy link
Contributor Author

FYI the TeamStatusCard report in the CareSet OneRing app is an example...

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@kchapple kchapple

Labels
enhancement New feature or request
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@ftrotter @kchapple