<?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 Is it possible to choose a custom source field in a grouped value selector ? in ArcGIS Dashboards Questions</title>
    <link>https://community.esri.com/t5/arcgis-dashboards-questions/is-it-possible-to-choose-a-custom-source-field-in/m-p/1236746#M7043</link>
    <description>&lt;P&gt;Let's create a minimal example of my problem.&lt;BR /&gt;&lt;BR /&gt;I have a &lt;STRONG&gt;feature class&lt;/STRONG&gt;&amp;nbsp;&lt;STRONG&gt;(FC)&lt;/STRONG&gt; and a &lt;STRONG&gt;table (T)&lt;/STRONG&gt;.&lt;/P&gt;&lt;P&gt;Each element of &lt;STRONG&gt;FC &lt;/STRONG&gt;is linked to one or more element(s) in &lt;STRONG&gt;T &lt;/STRONG&gt;through a common field &lt;STRONG&gt;GID&lt;/STRONG&gt;.&lt;/P&gt;&lt;P&gt;I would like to create a category selector that can choose one or more grouped value in &lt;STRONG&gt;T &lt;/STRONG&gt;for a given field &lt;STRONG&gt;F1 &lt;/STRONG&gt;(F1 only exist in &lt;STRONG&gt;T &lt;/STRONG&gt;). But now I need to add an action to filter &lt;STRONG&gt;FC &lt;/STRONG&gt;with this selector. Unfortunately the source field is set to&lt;STRONG&gt; F1 &lt;/STRONG&gt;and cannot be changed to &lt;STRONG&gt;GID.&amp;nbsp;&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;In SQL I could do something like:&lt;/P&gt;&lt;P&gt;&lt;EM&gt;select FC.* from FC&lt;/EM&gt;&lt;BR /&gt;&lt;EM&gt;where GID in (select distinct GID from T where F1 in ('item1','item2',...))&lt;/EM&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;/P&gt;&lt;P&gt;My question is:&amp;nbsp;&lt;/P&gt;&lt;P&gt;In those cases is there a way to change the source field ?&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Bastien_0-1669892151653.png" style="width: 400px;"&gt;&lt;img src="https://community.esri.com/t5/image/serverpage/image-id/57339i9BC2BEEC8FB96D03/image-size/medium?v=v2&amp;amp;px=400" role="button" title="Bastien_0-1669892151653.png" alt="Bastien_0-1669892151653.png" /&gt;&lt;span class="lia-inline-image-caption" onclick="event.preventDefault();"&gt;Bastien_0-1669892151653.png&lt;/span&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;As we can see above (in french sorry) the source field is set (and cannot be changed) to the category field. So I cannot filter the element in my map :(.&lt;/P&gt;&lt;P&gt;Actually the only workaround I can think of is to create a query layer that add a new boolean field in&amp;nbsp;&lt;STRONG&gt;FC&amp;nbsp;&lt;/STRONG&gt;for each category available in the &lt;STRONG&gt;F1 &lt;/STRONG&gt;field of&amp;nbsp;&lt;STRONG&gt;T&lt;/STRONG&gt; which is... at least painful and with that option I would have to create a number selector for each category.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
    <pubDate>Thu, 01 Dec 2022 13:09:55 GMT</pubDate>
    <dc:creator>Bastien</dc:creator>
    <dc:date>2022-12-01T13:09:55Z</dc:date>
    <item>
      <title>Is it possible to choose a custom source field in a grouped value selector ?</title>
      <link>https://community.esri.com/t5/arcgis-dashboards-questions/is-it-possible-to-choose-a-custom-source-field-in/m-p/1236746#M7043</link>
      <description>&lt;P&gt;Let's create a minimal example of my problem.&lt;BR /&gt;&lt;BR /&gt;I have a &lt;STRONG&gt;feature class&lt;/STRONG&gt;&amp;nbsp;&lt;STRONG&gt;(FC)&lt;/STRONG&gt; and a &lt;STRONG&gt;table (T)&lt;/STRONG&gt;.&lt;/P&gt;&lt;P&gt;Each element of &lt;STRONG&gt;FC &lt;/STRONG&gt;is linked to one or more element(s) in &lt;STRONG&gt;T &lt;/STRONG&gt;through a common field &lt;STRONG&gt;GID&lt;/STRONG&gt;.&lt;/P&gt;&lt;P&gt;I would like to create a category selector that can choose one or more grouped value in &lt;STRONG&gt;T &lt;/STRONG&gt;for a given field &lt;STRONG&gt;F1 &lt;/STRONG&gt;(F1 only exist in &lt;STRONG&gt;T &lt;/STRONG&gt;). But now I need to add an action to filter &lt;STRONG&gt;FC &lt;/STRONG&gt;with this selector. Unfortunately the source field is set to&lt;STRONG&gt; F1 &lt;/STRONG&gt;and cannot be changed to &lt;STRONG&gt;GID.&amp;nbsp;&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;In SQL I could do something like:&lt;/P&gt;&lt;P&gt;&lt;EM&gt;select FC.* from FC&lt;/EM&gt;&lt;BR /&gt;&lt;EM&gt;where GID in (select distinct GID from T where F1 in ('item1','item2',...))&lt;/EM&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;/P&gt;&lt;P&gt;My question is:&amp;nbsp;&lt;/P&gt;&lt;P&gt;In those cases is there a way to change the source field ?&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Bastien_0-1669892151653.png" style="width: 400px;"&gt;&lt;img src="https://community.esri.com/t5/image/serverpage/image-id/57339i9BC2BEEC8FB96D03/image-size/medium?v=v2&amp;amp;px=400" role="button" title="Bastien_0-1669892151653.png" alt="Bastien_0-1669892151653.png" /&gt;&lt;span class="lia-inline-image-caption" onclick="event.preventDefault();"&gt;Bastien_0-1669892151653.png&lt;/span&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;As we can see above (in french sorry) the source field is set (and cannot be changed) to the category field. So I cannot filter the element in my map :(.&lt;/P&gt;&lt;P&gt;Actually the only workaround I can think of is to create a query layer that add a new boolean field in&amp;nbsp;&lt;STRONG&gt;FC&amp;nbsp;&lt;/STRONG&gt;for each category available in the &lt;STRONG&gt;F1 &lt;/STRONG&gt;field of&amp;nbsp;&lt;STRONG&gt;T&lt;/STRONG&gt; which is... at least painful and with that option I would have to create a number selector for each category.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Thu, 01 Dec 2022 13:09:55 GMT</pubDate>
      <guid>https://community.esri.com/t5/arcgis-dashboards-questions/is-it-possible-to-choose-a-custom-source-field-in/m-p/1236746#M7043</guid>
      <dc:creator>Bastien</dc:creator>
      <dc:date>2022-12-01T13:09:55Z</dc:date>
    </item>
  </channel>
</rss>

