Hi together,not sure if its a question or a discussion.i just discovered that isnull() for a nested CDT is not working properly
I have a CDT Processdata {"id"(integer), "startedAt"(datetime), "attachment"(CDT attachment),...}
which contains the nested CDT "attachment" {"id"(integer), "document"(document)....}
-> If I try to do isnull(ri!processData.attachment.document) it is not working and i always get false as result, even the value is NULL (100%)-> if I try ri!processData.attachment.document= todocument(Null) its fine.
-> isnull(ri!process.documenttest) is working, so it seems to be just an issue regarding nested document CDT as far is can clarify.
a) is that a bug by appian?
b) what would be your approach to solve it? What is your best practice here?
Thank you all :)
Discussion posts and replies are publicly visible
Did some small tests. But only with static data. Not from DB, just as rule inputs. Works for me. Can you provide more details? Is that nested type an array?
Fast Reproduction:
a!localVariables( local!processData:'type!{urn:com:appian:types:fwe}FWE_processData'(attachements: 'type!{urn:com:appian:types:fwe}FWE_Attachements'(document: ri!document)),
isnull(local!processData.attachements.document)
)
The isnull function gives back "false" (for ri!document= NULL)