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.

hamini

Were on 11.1. Thank you, I no longer see the issue!

LJackson29

@TonghuiMing Thank you - the issue has been resolved in my apps 😊

ChristinaNeal

It is fixed, thank you! Version 11.3

NeilWebber

@TonghuiMing also confirming as fixed - many thanks for your help.

NeilWebber

@TonghuiMing I have now found another problem with ExB data filtering that seems to be too much of a coincidence not to be connected with this acknowledged issue.

A List widget has a data source. That data source can be filtered via the settings for the data source in the Content tab (Filter/Sort/Records)

No filter applied, Yes/No values in a field

With a 'Field IS Yes' filter applied (i.e. Unique values), no values are returned where there should be many

With a STARTS WITH filter applied the results are as expected

This suggest to me that the same 'Unique Values' issue that affected the Filter widget is also manifesting in other applications of data filtering within ExB framework.

Thanks, Neil