Query Widget Not Returning All Values

[Blevins_Mark]

Enterprise 11.3...query widget when being configured i can scroll through all the values...

Once published it only populates a certain number of values and then spinning wheel appears for anything over the last value...

What the heck?

[ChrisUnderwood]

Hello @Blevins_Mark  are you able to put a more exact figure to "a certain number of values" ? Is your data Hosted, or is it Referencing a particular database type ?

[Ke_Xu]

Hi @Blevins_Mark,

This may be a bug. Could you share your data and app with me? My username is ke13810. Or you can contact the Support team to help reproduce your issue.

Thanks,

Ke

[Blevins_Mark]

hi @Ke_Xu thanks for your response...the issue ended up being the record page size of the layer on the data tab...increasing that from 100 to 5000 (a few hundred more than the record count in my layer) the widget worked as expected. i guess as an enhancement suggestion the default record size should be increased, 100 really isnt that much. thanks.

[apseifert]

I am having the same issue.  Where exactly is that record page size?

[Blevins_Mark]

Click the data button then select the layer.

Click settings

click records then adjust the page size

see if that gets what you need.

[apseifert]

@Blevins_Mark Thank you! I found it.  So many settings hidden.

This combined with indexing several fields has helped display the full list of values.