Hi Team,I have a CDT named PSC test which contains a nested CDT called PSC test1(nested cdt column name :idf). In a process model script task I'm trying to make the PSC test1 as null and write into DSE. In a script task I'm mapping NULL to it, but while writing it getting error.
I tried using cast(cdttype,null), null, emptycdttype. But no improvement. Is there any solution for this?Thanks in advance!
Discussion posts and replies are publicly visible
I don't think we can do that in appian we cannot define CDT of type null.
Is that field "idf" a multiple? If yes, try to assign a empty list "{}". If you assign a NULL value, Appian thinks that you want to assign a list with a single NULL value item.
No Stefan it's the nested CDTat one point I don't need the relationship to idf. So I'm trying to change idf to null. In this case I'm getting an error!
Are you aware that nested CDTs are not recommended? Why not use Records?
You said "I don't need the relationship to idf.". I understand, but you cannot just set the field to NULL. You will have to actively delete that element and set up the CDT field correctly to make this work.
Yes Stefan I'm aware of that, but this application was developed some years back, I'm correctly working on that for an improvement. So I can't able to use records as of now.And I'm trying to solve this issue using query database node now. If it works I will post here