'IS IN' and equals comparison for data types in Decision Table

Flowable Engine
1

Hi,
What is the significance of having ‘IS IN’ when evaluating business rules for data type ‘number’?
For example: I have a workflow, where I’m submitting amount variable when starting a process instance.

image
image1906×583 33.9 KB

On following the evaluation of decision table, I can see that this comparison ended up in allOf() of org.flowable.dmn.engine.impl.el.util.CollectionUtil.java, which is doing a normal .contains check against the value given in decision table.

I have the same query for other data types as well.
For example: == for Collection data type and ‘Date’ data type to evaluate a business rule.
For collection if we have below configuration in table

image
image1901×504 34.3 KB

I passed the same values in countryCode variable when starting the process instance. However, it gave me false with equals comparison.

2

Hi

It seems your doing it the other way around.
When a non collection input variable and using the IS IN operator and you have define a collection in the expression.
For example checking if the input1 number is in the collection containing the numbers 1,2 and 3;

image
image2722×502 39.1 KB

When the input variable is a collection you have other operators to check against an other collection.

For example check if the elements in input1 collection are all in the collection contains the numbers 1,2 and 3;

image
image2696×446 34.4 KB

PS.

The ‘Collection*’ unit tests perhaps provide some additional info;

Hope this helps,

Regards,

Yvo

1 Like
3

Hi @yvo ,

I’m using flowable version 6.4.2.
For the number and date data types, when I try to give multiple values, the row gets filled with a red background indicating some sort of validation error
Although when I tried executing below decision table for number data type,

image
image1918×434 17 KB
It executed perfectly i.e. when input1 value was 23, the rule was evaluated to true and assignee output variable was set to ‘JOHN’. But while configuring it shows some sort of invalid input in the column.

Also, how can we configure multiple date values for date data type, I tried doing it this way,

image
image1904×441 17 KB

but got this error while executing the above decision.
Below is the error
Error while evaluating expression: ${collection:allOf('2021-01-20,2021-01-21', dueDate)}

4

Hi,

not sure if this was a validation bug in the editor in 6.4.2. But it’s working correct during runtime?
Is there a reason you’re not on the latest version; 6.6.0?

Regarding the date collection check. The date strings should be between quotes; "2021-02-16", "2021-02-21".
But; while checking this I noticed an issue. When using a date as in input variable type and a collection related operated; it tries to do some (unneeded) transformation on the date variable. Which can result in issues. This is a bug. I’ve created an issue for this so you can track the progress.

This issue does not occur when using a collection containing dates as an input variable. This can be used as a temporary workaround.

Regards,

Yvo

1 Like
5

Thanks, @yvo .
Yes, even after the validation bug for number data type, it’s working correctly during runtime in version 6.4.2.
My project is using 6.4.2, that’s why I’m not on the latest version.

6

As with all software out there, it’s always a good idea to be on the latest version (bugfixes and improvements get added all the time)

7

Hi,

I just ran through this post , I am trying to use decision tables for more than one multi-select fields.

Field contains 7-8 options in total , ex , option a , b , c , d etc.
I want to display output based on the condition if the multi-selection contains either option a , option b or option c.

IS IN - Works when I select option a & option b OR option b & option c , however it doesn’t work when I select option a , option b & option d

Please share any thoughts on how this can be achieved.

Thanks,
Ajinkya