Source: Trisotech ( Denis Gagne)
FEEL for iteration statement context limits the iteration context (Section of 10.3.2.14 ) to integers:
"An iteration context may either be an expression that returns a list of elements, or two expressions that return integers connected by “..”. "
It would be useful to augment the iteration context to also allow dates.
This will allow to create simple decision logic that validates conditions for each date in the range and allows one to write decision logic that can validate the state on each day to calculate the number of days that meet a requirement.
An general example use case could be, how many days in the range [2021-01-01..2022-01-01] meets a certain complex logic.
A specific example of that would be to determine if the person and its spouse were both employed and living at the same address for at least the 3 of the last 5 years given a list of Job description for both (Date From, Date To, Employer) and a list of their declared residence for both (Date From, Date To, Address).
This can of course be calculated in a different way, but the logic of iterating on a date range and checking if the condition is true for every day and summing the number of days for which its true makes the logic a lot simpler to follow for a business user.
Reported: DMN 1.4b1 — Tue, 18 Oct 2022 18:39 GMT
Disposition: Resolved — DMN 1.5
Add date range to iteration context
Explicitly allow date ranges and add @”2021-01-01”..@”2022-01-01” to the list of examples in section 10.3.2.14.
Updated: Fri, 30 Jun 2023 20:31 GMT