TOS 7.3 - tMap - TalendDate.diffDate why we can not have null as ouput ?

[Urba34]

Hi evryone,

I'm using this formula on a tMap component in var section

(

row1.tech_setr1appointementdate!=null

&&

row1.tech_setr2date!=null

)?

TalendDate.diffDate(row1.tech_setr2date,row1.tech_setr1appointementdate,"dd"):

0

it's working but when i trie to replace 0 by "null" then i have a errror "java.lang.NullPointerException: null"

(

row1.tech_setr1appointementdate!=null

&&

row1.tech_setr2date!=null

)?

TalendDate.diffDate(row1.tech_setr2date,row1.tech_setr1appointementdate,"dd"):

null 

I have allow the nullable result on the ouput

Thanks for your help 🙂

[Anonymous · Accepted solution]

Hi

try to use this expression on the output rather than Var area, there is no Nullable option in the Var area.

Regards

Shong

[Urba34]

Hello,

Thanks for your quick answer. I got the same result

[Anonymous]

I am not able to reproduce the NPE when I set it to null for a long type. Can you try this expression:

(

row1.tech_setr1appointementdate==null

||

row1.tech_setr2date==null

)?null:TalendDate.diffDate(row1.tech_setr2date,row1.tech_setr1appointementdate,"dd")

[Urba34]

Unfortunately I have the same error

[Urba34]

hi back,

I think it's about a parameters in my TOS 7.3 no ?

[Urba34]

Hi for the futur guys how pass throw this post the answer was to copy past

this code

(

row1.tech_setr1appointementdate!=null

&&

row1.tech_setr2date!=null

)?

TalendDate.diffDate(row1.tech_setr2date,row1.tech_setr1appointementdate,"dd"):

null 

directly on the output et and not on the variable

[Anonymous]

I see you marked this question as resolved and select my answered as best answer. Thanks for your confirmation and feedback.

Regards

Shong