Question

Date parameter in OQL

0

Hi community, In my OQL query, I need to set a constraint on a date to filter objects which are in the past. how can I get a date/time parameter working in OQL dataset ? if I add a parameter, it's automatically defined as a date range Or maybe if there is a function to parse a date in OQL in Mendix 9.24 ? (string --> date) I couldn't find anything in the doc thanks

asked 2024-05-24

François Lecomte

1 answers

Paweł Turek · Accepted Answer · 2024-05-24

Hi.

You have an 'execute OQL statement' activity in your microflow and there you want to just add a constraint on a date to for instance show only the records <= CurrentDate. Is that the case?

If so then please add 'Add Date Time Parameter' activity before the 'Execute OQL statement' and use it in the query.