What is the best way to null check a date rule input before using inside Expression Rule

Hi,

Please replace the a!queryFilter code with below code.

if(
isnull(
ri!dateField
),
null,
a!queryFilter(
field: "dateField",
operator: "<=",
value: ri!dateField
)
)

Thanks
Aditya

This is close but I believe it won't work as written.  The issue I expect is because the queryFilter() element is usually within an expected array of queryFilters, and passing null() will break it.

This (slight) modification would not have this issue:

if(
  isnull(ri!dateField),
  {},
  a!queryFilter(
    field: "dateField",
    operator: "<=",
    value: ri!dateField
  )
)

I agree with using the common objects functions for those that have them.  I use the apn_isBlank() and apn_isEmpty() functions almost exclusively.

I'd just note here that you were probably thinking of apn_isBlank(), which is intended to check the null / blank status of a single entity.  apn_isEmpty(), on the other hand, is intended to take an array and check that it's empty (and it handles being passed a null value too, unlike the primitive functions).