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

Add support for 'current_date' as a default parameter #44

Closed
rafrombrc opened this issue Feb 24, 2017 · 4 comments
Closed

Add support for 'current_date' as a default parameter #44

rafrombrc opened this issue Feb 24, 2017 · 4 comments
Assignees
Milestone

Comments

@rafrombrc
Copy link
Member

rafrombrc commented Feb 24, 2017

It's possible to use static values as default parameter values in queries, but we have a need to use predefined variables such as 'current_date' as well.

@washort
Copy link

washort commented Feb 27, 2017

Since parameters are just done by string substitution, you can just put now() or any other SQL expression as a value for a parameter.

@arikfr
Copy link

arikfr commented Feb 27, 2017

Brilliant :)

One downside: you can't use the date picker in this case.

@rafrombrc
Copy link
Member Author

@davismtl Does this solution (i.e. using now() as the default parameter) satisfy the use case that you're interested in?

@davismtl
Copy link

Yeah, I think it'll resolve a lot!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

4 participants