I have a query rule that retrieves data from a view. I apply the APN_Distinct f

I have a query rule that retrieves data from a view. I apply the APN_Distinct function to the array of items that is returned. I then want to use this list in a dropdown field in SAIL. In my development environment the field of interest contains NULLS and some blanks. In the interface designer it is giving me an error of "Choice values cannot be null". Is there an easy way to remove these NULLS? I have thought about modifying my view to not allow NULLS in this field but that could potentially create other issues.

Thank you for your ideas and thoughts on how I might solve this issue....

OriginalPostID-128027

OriginalPostID-128027

  Discussion posts and replies are publicly visible

Parents Reply Children
No Data