Processing of nulls in dmn tables


#1

Hello!
Tell me, is it possible to handle the value of null in the dmn table?
Particularly interested in the type of datetime. Can I give an example?


#2

Hi @ntdim1973,

An example DMN table would certainly be useful so that we can understand what you want to achieve and where null comes into play.

Cheers,
Thorben


#3

example_dt_null.dmn (2.0 KB)

How correctly in the given case to use and process null ?


#4

Hi @ntdim1973,

currently, the Camunda FEEL engine doesn’t support null-checks. If you can’t prevent null values then you’ve two ways:

Does this help you?

Best regards,
Philipp


#5

Could you give an example of using JUEL or Groovy in dmn?


#6

Hi @ntdim1973,

you can set the expression language of the input entry. Please have a look at the documentation:

Does this help you?

Best regards,
Philipp


#7

Hi @Philipp_Ossler
So by using “not(null)” we cannot evaluate a NULL value. Is it correct? Please confirm.


#8

Hi @Philipp_Ossler,

when you use the FEEL extension then you can write not(null). The expression is true when the input value is not null.

However, in most cases, you don’t need this check. You can add a rule at the button of the table which has no condition (i.e. - aka don’t care).

Does this help you?

Best regards,
Philipp


#9

Hi @Philipp_Ossler
If there is no condition specified, everything will be ignored which includes also a null value. In such time, our aim to check not(null) will be skipped where NULLS are also ignored if we specify no condition (don’t care). Kindly provide your idea.

Also,can i check the null value in a column as “NULL”?