Question

Using OQL Query fetch data from backend

0

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

asked 2023-08-13

Dnyaneshwar Khule

2 answers

0

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?

thank you~

answered 2023-08-14

Shinwoo Lee

Tim van Steenbergen · Accepted Answer · 2023-08-13

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.

*****Editted*****