I am attempting to define two facet options to filter a database column by wheth

I am attempting to define two facet options to filter a database column by whether it is null (in null()) or non-null (not in null()).

For a numeric column, I receive the error message: "Cannot apply operator [EQUALS] to field [price] when comparing to value [TypedValue[it=3,v=]]. (APNX-1-4203-015)"

For a varchar/string column, the "not in null()" facet option returns the appropriate rows but the "in null()" facet option returns no rows (it seems to be ignoring any rows containing null).

How can filter based upon presence/absence of a null value?...

OriginalPostID-77621

OriginalPostID-77621

  Discussion posts and replies are publicly visible

Parents Reply Children
No Data