I have a tree layers containing over 100k trees for a city. In web app builder, I had a filtering widget that allowed users to query the trees based on several fields. I am migrating this app to experience builder but found that the filter widget and the filter in the table of attributes are causing an error.
Whenever I apply a filter with 2 or more queries at once on the layer, the map and table of attribute show 0 records. When I toggle the layer back off, the table and map continue to show 0 features. Applying just one query works. I have tested the query on the rest end point directly by going to ..../featureServer/0/query and I tested the filter in web map viewer. The filter has worked fine in both those places but it fails on experience builder.