it's been a while so getting back into wappler.
I forget what is the default date format for using dates in the query builder. Is it 11-30-2024 for Nov 30, 2024 or 2024-11-30 or what? I'm looking at the parameters tab and want to put in test values to test my query. I don't remember how to do this. Is there a tutorial on how to use this preview ability?
Also not sure how to use the Names like :P1, in the expressions. :Sorry, I will get back in the swing of things just need to awaken all the neurons for this.
I'll answer the most essential question: What date format?
To answer that question, I went on Google and typed "SQL date format". I quickly concluded the date format is YYYY-MM-DD
Wappler uses a more complete date format for {{ NOW }}, but such is internally stripped-down to YYYY-MM-DD when injecting in a query (if I'm not mistaken).
Serial :P1,:P2, etc. Parameters are automatically generated from the conditions you set within your query, a = :P1, b != :P2, etc. However, if you're looking to map your own parameters and use them within more complex queries, CASE, OVER, etc. you need to use custom query component. There you can set your parameters in the parameter menu, dynamically. The Database Query component hasn't changed since documentation was rolled out, therefore the information is still relevant:
