Wappler Version : 2.4.1
Operating System : W10
I have a view which when called from regular Query, works fine. But, when the same query is called from Custom query, the results are weird.
The reason why I need to call it from Custom Query is that I need to add to this query. But since it did not work here (although it worked perfectly in phpMyAdmin), I tested various things and finally found this.
This query works fine and returns correct number of rows:
But this fails and returns just two rows:
Have tried using
AND instead of
BETWEEN same results.
Please help @patrick .