Experience Builder>Filter>Is any of filter type not displaying

[DavidColey]

Hello this is related to a recent post:

https://community.esri.com/t5/arcgis-experience-builder-questions/experience-builder-filters-not-dis...

In my case, the Filter type 'Is any of' will build in the Filter expression builder config, but the multi-value pick list control is then not displayed in the widget itself:

And then here in form element selector, no choices appear:

I don't think this is a new issue.  I can tell you for this experience all of the layers from my webmap data source are from enterprise 12.0  portal hosted distributed collaboration feature layers.

So I'm at a loss...

here's a working copy:

https://experience.arcgis.com/experience/1ee9cb0cb8a040c0b634a712ab9baca9

@JeffreyThompson2 

@TonghuiMing 

[TonghuiMing]

@DavidColey We will take a look at this. Thanks for sharing the app.

[TonghuiMing]

Hi @DavidColey 

Per our colleagues' investigation, this issue lies in a bug on the service side of this special case. Here are the details (note that usually, or mostly, the "No data" issue from the Filter unique list has something to do with the service bug or limitations, but it is case by case - between many properties, so it is a bit different from the other post, I would say):

When querying count, the JS API layer adds `{ returnIdsOnly: true, returnCountOnly: true }` to the query parameters. Based on the Rest API doc (https://developers.arcgis.com/rest/services-reference/enterprise/query-feature-service-layer/ ), the `returnCountOnly` should supersede the `returnIdsOnly` parameter. But the service doesn't follow the rule and returns an array of object IDs.

See the actual result that conflicts the expected behavior https://ags3.scgov.net/server/rest/services/Hosted/PetitionActive/FeatureServer/0/query?f=json&retur... 

Maybe you could reach out in their channel? Sorry for the inconvenience.

[DavidColey]

@TonghuiMing - I would reach out if I knew what I was asking for, but I don't.  Are you telling me that in this portion of the get request:

.../0/query?f=json&returnIdsOnly=true&returnCountOnly=true&outFields=petitiontype&returnDistinctValues=true&...

should be:

.../0/query?f=json&returnCountOnly=true&returnIdsOnly=true&outFields=petitiontype&returnDistinctValues=true&...

If so, it did not seem to matter when I just physically changed the order in the request and pasted it into the browser.  The json return looks the same.

I don't understand how the Filters' SQL query configuration can get a correct syntax REST 'read' and display the proper choice list, but somehow when presented in the UI form the list disappears? 

I'm sorry but I don't get it, and I cannot be the only person that creates their experiences with enterprise hosted feature layers sourced from a distributed collaboration.

How can that be a server side issue?

Update - you should also be aware that if setting a query as 'Is any of' on an Integer field, the filter configuration tool no longer reads ANY values to pick from....

Thanks  

[DavidColey]

More - this is clearly not an issue for the webmap and the Instant Apps.  

The web map and the Instant apps are certainly not affected.  The webmap still properly displays an ‘Includes’ filter where the unique values are visible and selectable, as does the Filter widget in the Sidebar instant app, with the Sidebar filter displaying the unique values to the user for selection.

For this application this is big deal for us.  The UI for the 'Is' selection type is barely usable on a mobile device and is not a suitable workaround.

In fact, the only workaround I see for now will be for me to maintain ArcGIS Online hosted versions of the layers that I am using for this widget.  That is a lot of work for this application.  Please fix this as soon as possible.

[DavidColey]

Ok -

It would appear that, as long as the attribute value type that I want to use as a multi-value filter selection is a CHAR (text, whatever) that I can build pre-defined lists for the 'Is any of' query type and those values do populate both the query list configuration tool and then do appear as part of the Filter UI drop down for selections, and then those selections do work. 

Not ideal and this does not work for INT data types (like Subtypes) - but, for this application, better than me maintaining identical Enterprise-hosted  and ArcGIS Online-hosted feature layers.

[DavidColey]

More - it would appear that for CHAR data type attributes - if the attribute is not a Text Coded Value Domain list - then there is a limit of 10? values that will populate the Unique predefined list builder tool when trying to construct a Unique Pre-Defined list for an "Is any of" query type.

Otherwise, I have to use an "Is" query type to build Unique Pre-Defined list for a non-domained attribute value list.

@TonghuiMing 

[TonghuiMing]

Hi @DavidColey, the reason is what I posted earlier, and the problem does not lie in the WHERE request, but rather in how the backend responds to this request. I've tried to communicate with our backend colleagues and see if they can help with the issue above, and I will let you know if there are any updates. Thanks

[DavidColey]

Ok thanks for this @TonghuiMing, I needed time to understand what you were trying to communicate. I have started a support case and am meeting with an analyst today to demonstrate the behavior. Case number 04125481 for our Org 16502.

[DavidColey]

Ok thanks all, this has been identified as a bug 'In Review' for BUG-000183237 as

"ArcGIS Experience Builder, Filter with 'Is any of" filter type not displaying expected results."

Thanks @TonghuiMing