Skip to main content
P
pavitrad2763
January 21, 2025
Question

Issue to check related record if its empty

  • January 21, 2025
  • 3 replies
  • 0 views

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(
Â%A0 fn!isnull(ri!array),
Â%A0 true(),
Â%A0 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.

    3 replies

    konduruc733182
    konduruc733182
    January 21, 2025

    Hello [mention:eafad29ef2f94635b373ae8b9e875dbc:e9ed411860ed4f2ba0265705b8793d05] ,

    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
  )

    andrewh6762
    andrewh6762
    January 21, 2025

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

    stefanhelzle0001
    stefanhelzle0001
    January 22, 2025

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

    Terms & ConditionsAccessibility statement