I want to write an OQL query to retrieve date range data I want to pass two parameters for the start date and end date so want need to fetch backend data between those given ranges as parameters how I can write a query for that in the variable Please help Thanks advance
See https://service.mendixcloud.com/p/OQL for the oql-playground. To see your requested date example click on button “Where Date < $DateTimeParameter”:
and you will see a guide how to pass the date parameter.
Tim van Steenbergen
I still don't understand the clear difference and usage of oql and sql.
Is there a place where I can see a more detailed and kind explanation?