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

Question

What is the best way to null check a date rule input before using inside Expression Rule? In order to prevent the below error: 
 
 Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error at function a!queryFilter [line 24]: The a!queryFilter function has an invalid value for the &ldquo;value&rdquo; parameter. When the value of &ldquo;operator&rdquo; is &ldquo;<=&rdquo; &ldquo;value&rdquo; must not be null or empty.

Mike Schmitt · Answer

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

sindhug · Answer

Hi Anusha, 
Please try with below code. 
if( 
 or(ri!dateField="", isnull(ri!dateField)), 
 {}, 
 a!queryFilter( 
 field: "dateField", 
 operator: "<=", 
 value: ri!dateField 
 ) 
)

Dude · Answer

First decide whether the input is single or multiple. If its single use the rule!APN_isBlank(). If its multiple use the rule!APN_isEmpty(). Some time if the input was passed with {}, then check for the length()>0, then proceed with the natural flow, otherwise go with the else flow.

Aditya GIll · Answer

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

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

Top Replies