What is the best way to validate

6 replies
10 views

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 :)

stefanhelzle0001

Brainy

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?

richardm900458Author

Inspiring

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)