Experience Builder Query Widget Unique list

[LindseyStone]

In Experience Builder developer v1.17.  I am trying to set up the query widget with an attribute filter where Field Name is Unique where it gives a drop down list of all the values.  Upon testing it the drop down just spins.  I have this same setting set up on a different Experience Builder App utilizing a different service and it works just fine.  The one working is about 50 records compared to the one not working is 650 records.  

I looked on the service properties (service is published from Pro to Enterprise server) and it has the maximum number of records returned by server as 1000.  Within Experience Builder I upped the record page size to 900. Is there a max size limit on this option or am I missing another setting to check for this capability on this amount of records?

Just for fun I also tried to add the Search widget and added this same layer as a custom data source with suggestions and after a type the first 3 letters than I DO get suggestions.

[Ke_Xu]

Hi @LindseyStone,

Could you provide the service that could reproduce this issue for me to troubleshoot?

Thanks,

Ke

[LindseyStone]

@Ke_Xu 

I had reached out to support and we figured out the issue with my layer having issues was it didn't have Advanced Queries enabled.  The reasoning for that it was pointing to a shapefile and not a file geodatabase.  Once I imported my shapefile into a geodatabase, the advanced queries was enabled and the drop down worked.  I'm currently waiting on support to get back to me whether this is a an existing or new bug or core limitation, etc.