UI Expression Error: Invalid Equals Comparison with Null Date Value

Certified Associate Developer

I’ve set up a date search in my Appian interface backed by a Cloud DB table. When users select a date, it updates a rule input, which is then used to filter records. The filtering works well and shows only the data for that selected date.

query: a!query(
                    filter: if(
                      isnull(ri!onInputChange),
                      null,
                      a!queryFilter(
                        field: "createdOnDate",
                        operator: "=",
                        value: ri!onInputChange
                      )
                    )

But, when I am adding the interface as a page to the Site, I am getting the error below:
Error Evaluating UI Expression Expression evaluation error [evaluation ID = 296a3:3b232] in rule <table_Name> : Cannot apply operator [EQUALS] to field [createdOnDate] when comparing to value [TypedValue[it=49,v=<null>]].

  Discussion posts and replies are publicly visible