Filter Widget - All Unique Values of this Field Error

[ChristinaNeal]

Hi, our experience builder app is having issues populating the options within the filter widget when set up to use "All unique values of this field." The list is blank even though this used to work before. I have tried recreating the filters and that did not make a difference.

[DennisDKing]

We are also having the same issue.  For us, it seems to be the last part of the query being sent to ArcGIS Server and looks something like: %20and%20((PROJECTNUM%20IS%20NOT%20NULL)%20AND%20(PROJECTNUM%20%3C%3E%20%27%27)

PROJECTNUM%20%3C%3E%20%27%27 (PROJECTNUM = '') is the part that makes it return 0 rows from the ArcGIS Server Query.

Support was not able to reproduce but they were using SQL Server.  Our SDE backend system is Oracle.  Not sure if that is a factor.

[TonghuiMing]

Thank you all for the feedback. We have received the details from support and will take a look at this. Sorry for the inconvenience.

@hamini Thanks for pointing out the string field type.

[TonghuiMing]

@ChristinaNeal @DennisDKing @hamini @NeilWebber @LJackson29 

In addition, it would be helpful for our follow-ups with the service colleagues if you could provide us with your service version. Thank you.

[NeilWebber]

@TonghuiMing  Service version here is 11.3

And further to @DennisDKing, we are also using Oracle SDE backend

[TonghuiMing]

Hi all, this issue should have been fixed and patched. Let me know if you still see the problems. Make sure to clear the cache first. (Your service version information is still helpful, if possible)

@NeilWebber I tested your app; it looks good now - FYI.