Issue to check related record if its empty

Question

Hi, 
 When we give empty related record in place of ri!array in below code it should give me true as a result but instead it is giving false 
 if(
&#160; fn!isnull(ri!array),
&#160; true(),
&#160; length(ri!array) = 0
) 
 
 Here local!lrrfRec is the record and rgracslblLrrfSelectedCountries is the related record. We are passing this in place of ri!array. 
 Please correct me if I'm missing something in the above code.

Konduru Chaitanya · Answer

Hello p2005 , 
 https://docs.appian.com/suite/help/24.4/fnc_informational_isnull.html#examples It is because isnull returns false for empty arrays. You could use the below code and try out. When the Array input value is null due to the type defined it would return as a string of null values. 
 if(
 or(a!isNullOrEmpty(ri!array), length(ri!array) = 0),
 true,
 false
 )

Andrew Hickingbotham · Answer

You can also just drop the if statement as it is redundant. The good thing about this condensed version is that the or() stops when it gets a single TRUE so as long as the length() after the a!isNullOrEmpty() then you never get the " A null parameter has been passed" error for the length() function. 
 or(a!isNullOrEmpty(ri!array), length(ri!array) = 0) 
 
 Having said that you can always use a!flatten() inside the length() function as length() can handle a list of null. The below code won't error even if given a null. 
 or(length(a!flatten(ri!array)) = 0, a!isNullOrEmpty(ri!array))

Stefan Helzle · Answer

This is my way of checking for null/empty/nothing: https://appian.rocks/2022/10/17/the-magic-of-null-checking/

Issue to check related record if its empty

Top Replies