Question

How to Use a Dynamic value LastRunDate in SQL Constraints in mendix database mapping for Updating CycleSchedule Table

0

Hello Mendix Community, I am currently working on a project in Mendix and need assistance with updating the Schedule table based on changes that have occurred in the UPS Sched table since the last execution. Specifically, I want to update only the rows in the Schedule table where the data in the UPS Sched table has been modified after the previous execution. The problem I’m facing is that the LastRunDate (the date of the last execution) is dynamic and changes every time the process runs. I want to use this dynamic value in a SQL Constraints field WHERE clause to filter records that have been modified since the last run.

asked 2025-12-08

Asha Misal

1 answers

ishtiaq ahmad · Answer 1 · 2025-12-09

First solution, I think you can use the two schedule run period as one way, lets say its daily or hourly then you can single day or hours as filter option.

Second solution, Another option is to update the column at times when UPS sched table is updating. Suppose you don't have access to to this then first solution above should work.