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
create a rule with the following code:
or(isnull(ri!input), ri!input="", length(ri!input)=0)
where ri!input is (Any Type) and see if this works in your scenario
that's the way I have approached this kind of issue. It works for me
Hi santhos, Hi Manuel,Thank you both for your input,I have a similar solution :)
quick information for you both:
isnull(local!processData.attachements.document) -> false
local!processData.attachements.document="" -> false
length(local!processData.attachements.document)=0 -> true