<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Dashboards filter value list shows &amp;quot;No matching options&amp;quot; for high-cardinality field on referenced (non-hosted) feature layer in ArcGIS Dashboards Questions</title>
    <link>https://community.esri.com/t5/arcgis-dashboards-questions/dashboards-filter-value-list-shows-quot-no/m-p/1712811#M12155</link>
    <description>&lt;P class=""&gt;&lt;STRONG&gt;Environment:&lt;/STRONG&gt;&lt;/P&gt;&lt;P class=""&gt;- ArcGIS Enterprise 11.4 ArcGIS Dashboards&lt;/P&gt;&lt;P class=""&gt;- Feature service published from ArcGIS Pro 3.6 referencing registered data (not hosted)&lt;/P&gt;&lt;P class=""&gt;- Source: SQL Server 2022 enterprise geodatabase; the layer is a database view (point geometry, SRID 4326, ~62,000 rows)&lt;/P&gt;&lt;P class=""&gt;&amp;nbsp;&lt;/P&gt;&lt;P class=""&gt;&lt;STRONG&gt;Problem:&lt;/STRONG&gt;&lt;/P&gt;&lt;P class=""&gt;In a Dashboards element (Indicator), adding a Filter on a string field shows "No matching options" in the value dropdown — the list never populates, even when typing to search.&lt;/P&gt;&lt;P class=""&gt;&amp;nbsp;&lt;/P&gt;&lt;P class=""&gt;The interesting part — it depends on the field's unique-value count, on the same layer:&lt;/P&gt;&lt;P class=""&gt;- kategori_lesen — 12 unique values → dropdown populates fine, including counts&lt;/P&gt;&lt;P class=""&gt;- subkategori_lesen — 322 unique values → "No matching options"&lt;/P&gt;&lt;P class=""&gt;- Both fields are esriFieldTypeString, length 255&lt;/P&gt;&lt;P class=""&gt;&amp;nbsp;&lt;/P&gt;&lt;P class=""&gt;&lt;STRONG&gt;What I've verified (browser dev tools):&lt;/STRONG&gt;&lt;/P&gt;&lt;P class=""&gt;The dropdown fires a query with groupByFieldsForStatistics=subkategori_lesen and the server responds 200 OK with the complete, correct list:&lt;/P&gt;&lt;P class=""&gt;&amp;nbsp;&lt;/P&gt;&lt;P class=""&gt;{&lt;/P&gt;&lt;P class=""&gt;&lt;SPAN class=""&gt;&amp;nbsp; &lt;/SPAN&gt;"fields": [&lt;/P&gt;&lt;P class=""&gt;&lt;SPAN class=""&gt;&amp;nbsp; &amp;nbsp; &lt;/SPAN&gt;{"name": "subkategori_lesen", "type": "esriFieldTypeString"},&lt;/P&gt;&lt;P class=""&gt;&lt;SPAN class=""&gt;&amp;nbsp; &amp;nbsp; &lt;/SPAN&gt;{"name": "countOFsubkategori_lesen", "type": "esriFieldTypeInteger"}&lt;/P&gt;&lt;P class=""&gt;&lt;SPAN class=""&gt;&amp;nbsp; &lt;/SPAN&gt;],&lt;/P&gt;&lt;P class=""&gt;&lt;SPAN class=""&gt;&amp;nbsp; &lt;/SPAN&gt;"features": [&lt;/P&gt;&lt;P class=""&gt;&lt;SPAN class=""&gt;&amp;nbsp; &amp;nbsp; &lt;/SPAN&gt;{"attributes": {"subkategori_lesen": "KATERER MAKANAN", "countOFsubkategori_lesen": 5}},&lt;/P&gt;&lt;P class=""&gt;&lt;SPAN class=""&gt;&amp;nbsp; &amp;nbsp; &lt;/SPAN&gt;{"attributes": {"subkategori_lesen": "LESEN BAYARAN PENDAFTARAN LESEN", "countOFsubkategori_lesen": 3}},&lt;/P&gt;&lt;P class=""&gt;&lt;SPAN class=""&gt;&amp;nbsp; &amp;nbsp; &lt;/SPAN&gt;...&lt;/P&gt;&lt;P class=""&gt;&lt;SPAN class=""&gt;&amp;nbsp; &lt;/SPAN&gt;]&lt;/P&gt;&lt;P class=""&gt;}&lt;/P&gt;&lt;P class=""&gt;&amp;nbsp;&lt;/P&gt;&lt;P class=""&gt;So the service answers correctly, the widget receives the data and displays nothing.&lt;/P&gt;&lt;P class=""&gt;&amp;nbsp;&lt;/P&gt;&lt;P class=""&gt;&lt;STRONG&gt;Also verified:&lt;/STRONG&gt;&lt;/P&gt;&lt;P class=""&gt;- Layer's Advanced Query Capabilities are all true: Supports Distinct / Pagination / Statistics / OrderBy / Count Distinct&lt;/P&gt;&lt;P class=""&gt;- Count queries and the element's Data table work perfectly&lt;/P&gt;&lt;P class=""&gt;- Typing the full value manually ("enter new value") creates a workggestion list fails&lt;/P&gt;&lt;P class=""&gt;- An equivalent hosted feature layer populates the same high-cardinality field without issue&lt;/P&gt;&lt;P class=""&gt;&amp;nbsp;&lt;/P&gt;&lt;P class=""&gt;&lt;STRONG&gt;Questions:&lt;/STRONG&gt;&lt;/P&gt;&lt;P class=""&gt;1. Is there a documented unique-value limit for filter value lists on non-hosted feature layers in Dashboards? If so, what is the threshold?&lt;/P&gt;&lt;P class=""&gt;2. Is this a known bug in Dashboards for referenced feature services, and is it fixed in a later Enterprise/Dashboards release?&lt;/P&gt;&lt;P class=""&gt;3. Any workaround to get the value list to populate for high-cardinng exact values or driving a Category selector from a separate small hosted lookup table?&lt;/P&gt;&lt;P class=""&gt;&amp;nbsp;&lt;/P&gt;&lt;P class=""&gt;Any pointers appreciated - happy to provide more traces.&lt;/P&gt;</description>
    <pubDate>Tue, 07 Jul 2026 04:56:19 GMT</pubDate>
    <dc:creator>AznanJamil</dc:creator>
    <dc:date>2026-07-07T04:56:19Z</dc:date>
    <item>
      <title>Dashboards filter value list shows "No matching options" for high-cardinality field on referenced (non-hosted) feature layer</title>
      <link>https://community.esri.com/t5/arcgis-dashboards-questions/dashboards-filter-value-list-shows-quot-no/m-p/1712811#M12155</link>
      <description>&lt;P class=""&gt;&lt;STRONG&gt;Environment:&lt;/STRONG&gt;&lt;/P&gt;&lt;P class=""&gt;- ArcGIS Enterprise 11.4 ArcGIS Dashboards&lt;/P&gt;&lt;P class=""&gt;- Feature service published from ArcGIS Pro 3.6 referencing registered data (not hosted)&lt;/P&gt;&lt;P class=""&gt;- Source: SQL Server 2022 enterprise geodatabase; the layer is a database view (point geometry, SRID 4326, ~62,000 rows)&lt;/P&gt;&lt;P class=""&gt;&amp;nbsp;&lt;/P&gt;&lt;P class=""&gt;&lt;STRONG&gt;Problem:&lt;/STRONG&gt;&lt;/P&gt;&lt;P class=""&gt;In a Dashboards element (Indicator), adding a Filter on a string field shows "No matching options" in the value dropdown — the list never populates, even when typing to search.&lt;/P&gt;&lt;P class=""&gt;&amp;nbsp;&lt;/P&gt;&lt;P class=""&gt;The interesting part — it depends on the field's unique-value count, on the same layer:&lt;/P&gt;&lt;P class=""&gt;- kategori_lesen — 12 unique values → dropdown populates fine, including counts&lt;/P&gt;&lt;P class=""&gt;- subkategori_lesen — 322 unique values → "No matching options"&lt;/P&gt;&lt;P class=""&gt;- Both fields are esriFieldTypeString, length 255&lt;/P&gt;&lt;P class=""&gt;&amp;nbsp;&lt;/P&gt;&lt;P class=""&gt;&lt;STRONG&gt;What I've verified (browser dev tools):&lt;/STRONG&gt;&lt;/P&gt;&lt;P class=""&gt;The dropdown fires a query with groupByFieldsForStatistics=subkategori_lesen and the server responds 200 OK with the complete, correct list:&lt;/P&gt;&lt;P class=""&gt;&amp;nbsp;&lt;/P&gt;&lt;P class=""&gt;{&lt;/P&gt;&lt;P class=""&gt;&lt;SPAN class=""&gt;&amp;nbsp; &lt;/SPAN&gt;"fields": [&lt;/P&gt;&lt;P class=""&gt;&lt;SPAN class=""&gt;&amp;nbsp; &amp;nbsp; &lt;/SPAN&gt;{"name": "subkategori_lesen", "type": "esriFieldTypeString"},&lt;/P&gt;&lt;P class=""&gt;&lt;SPAN class=""&gt;&amp;nbsp; &amp;nbsp; &lt;/SPAN&gt;{"name": "countOFsubkategori_lesen", "type": "esriFieldTypeInteger"}&lt;/P&gt;&lt;P class=""&gt;&lt;SPAN class=""&gt;&amp;nbsp; &lt;/SPAN&gt;],&lt;/P&gt;&lt;P class=""&gt;&lt;SPAN class=""&gt;&amp;nbsp; &lt;/SPAN&gt;"features": [&lt;/P&gt;&lt;P class=""&gt;&lt;SPAN class=""&gt;&amp;nbsp; &amp;nbsp; &lt;/SPAN&gt;{"attributes": {"subkategori_lesen": "KATERER MAKANAN", "countOFsubkategori_lesen": 5}},&lt;/P&gt;&lt;P class=""&gt;&lt;SPAN class=""&gt;&amp;nbsp; &amp;nbsp; &lt;/SPAN&gt;{"attributes": {"subkategori_lesen": "LESEN BAYARAN PENDAFTARAN LESEN", "countOFsubkategori_lesen": 3}},&lt;/P&gt;&lt;P class=""&gt;&lt;SPAN class=""&gt;&amp;nbsp; &amp;nbsp; &lt;/SPAN&gt;...&lt;/P&gt;&lt;P class=""&gt;&lt;SPAN class=""&gt;&amp;nbsp; &lt;/SPAN&gt;]&lt;/P&gt;&lt;P class=""&gt;}&lt;/P&gt;&lt;P class=""&gt;&amp;nbsp;&lt;/P&gt;&lt;P class=""&gt;So the service answers correctly, the widget receives the data and displays nothing.&lt;/P&gt;&lt;P class=""&gt;&amp;nbsp;&lt;/P&gt;&lt;P class=""&gt;&lt;STRONG&gt;Also verified:&lt;/STRONG&gt;&lt;/P&gt;&lt;P class=""&gt;- Layer's Advanced Query Capabilities are all true: Supports Distinct / Pagination / Statistics / OrderBy / Count Distinct&lt;/P&gt;&lt;P class=""&gt;- Count queries and the element's Data table work perfectly&lt;/P&gt;&lt;P class=""&gt;- Typing the full value manually ("enter new value") creates a workggestion list fails&lt;/P&gt;&lt;P class=""&gt;- An equivalent hosted feature layer populates the same high-cardinality field without issue&lt;/P&gt;&lt;P class=""&gt;&amp;nbsp;&lt;/P&gt;&lt;P class=""&gt;&lt;STRONG&gt;Questions:&lt;/STRONG&gt;&lt;/P&gt;&lt;P class=""&gt;1. Is there a documented unique-value limit for filter value lists on non-hosted feature layers in Dashboards? If so, what is the threshold?&lt;/P&gt;&lt;P class=""&gt;2. Is this a known bug in Dashboards for referenced feature services, and is it fixed in a later Enterprise/Dashboards release?&lt;/P&gt;&lt;P class=""&gt;3. Any workaround to get the value list to populate for high-cardinng exact values or driving a Category selector from a separate small hosted lookup table?&lt;/P&gt;&lt;P class=""&gt;&amp;nbsp;&lt;/P&gt;&lt;P class=""&gt;Any pointers appreciated - happy to provide more traces.&lt;/P&gt;</description>
      <pubDate>Tue, 07 Jul 2026 04:56:19 GMT</pubDate>
      <guid>https://community.esri.com/t5/arcgis-dashboards-questions/dashboards-filter-value-list-shows-quot-no/m-p/1712811#M12155</guid>
      <dc:creator>AznanJamil</dc:creator>
      <dc:date>2026-07-07T04:56:19Z</dc:date>
    </item>
  </channel>
</rss>

