How to compare a date parameter in OQL statement ?

0
Hi Team, I want to compare a date with current week Friday in below oql query, if the date is greater than current week Friday then display the date in report grid. OQL statement : select date,no from entity where cast(date as string) > CURRENT WEEK FRIDAY Thanks In Advance
asked
1 answers
0

If you use the OQL module from the appstore you can use a java action that is called: AddDateTimeParameter 

With this you can create a date parameter with something like this addDays([%BeginOfCurrentWeek%],5). (it is 5 or 6 depending on your first day of the week.

You can then use this parameter to compare with in your oql.

If you are implementing a Mx dataset you can use the parameters: https://docs.mendix.com/refguide/data-sets#4-parameters

 

answered