SQL Expression Builder for the query widget is not loading unique values

[NateWold1]

When configuring the SQL Expression Builder for the query widget, the unique values are not loading for any of the string fields. They are not loading in the SQL Expression Builder, or in the Query widget. The unique values are loading for other field types such as integer and date fields.  I am building this query for a feature service table published from a sde and it has around 400,000 features.

WR_TYPE is a string field, unique values will not load:

VERS is an integer field, unique values do load:

[Ke_Xu]

Hi @NateWold1,

Can you share your service with me so I can take a look?

Thanks,

Ke

[NateWold1]

Hello @Ke_Xu,

Here is the service. Thank you for taking a look. Our GIS Server is at version 11.1.

Layer: Public Versions (ID: 0)

Thanks,

Nate 

[Ke_Xu]

Hi @NateWold1,

This is a known issue we currently have, related to CHAR_LENGTH() in the query expression. I will keep you updated.

Thanks,

Ke