Who can help me?
I would like to use queries in ChronoMyAdmin to show, for example, the activities in a certain month (for example from March 1, 2025 to March 31, 2025)
screenshot
Forums
Using queries in
This is Chronoforms8, if you need to limit the records date range then you can use a Where statement in Read Data:
where "doopdatum" is the name of the Date column
Dear Max
Thank you very much for your quick response.Unfortunately, your suggestion does not yield the desired result.
Every time I enter a condition in the WHERE STATEMENT, I don't get a desired selection; all records are displayed.
What am I doing wrong?
what are your Table view settings ? please show a screenshot of it
Dear Max
I found my mistake!
I had not filled in the Data Source field in the Table view settings and had entered the name of the table that I am querying in the "Table name" field.
Apparently the name next to "Read Data" (in the example "read_data2") must match what is entered in the "Data Source" field.
Thanks for your tip to view the Table view settings.
Yes, having the Data Source should make it work as you need
so is it working well now ?
You need to login to be able to post a reply.