<?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 Re: Filter features using coded value in ArcGIS Pro Questions</title>
    <link>https://community.esri.com/t5/arcgis-pro-questions/filter-features-using-coded-value/m-p/1517544#M86693</link>
    <description>&lt;P&gt;I figured out what was going on here. The issue is the field name I was using was invalid, so I was getting an error. Though this seems like a pretty dumb mistake to make, our system is set up in such a way this actually exposed a deeper error. I'm not going to get into it, but make sure you're using the field names for the layer you're actually calling.&lt;/P&gt;</description>
    <pubDate>Fri, 09 Aug 2024 15:43:00 GMT</pubDate>
    <dc:creator>Chris_S</dc:creator>
    <dc:date>2024-08-09T15:43:00Z</dc:date>
    <item>
      <title>Filter features using coded value</title>
      <link>https://community.esri.com/t5/arcgis-pro-questions/filter-features-using-coded-value/m-p/1516989#M86666</link>
      <description>&lt;P&gt;Hello community-&lt;/P&gt;&lt;P&gt;I'm trying to filter records in a feature class based off multiple fields. I am able to do this fine until I try include a field that contains coded values in my filter.&lt;/P&gt;&lt;P&gt;This works (no coded values):&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;LI-CODE lang="c"&gt;var hydrants = FeatureSetByPortalItem(Portal('https://xyz.com/portal/'), '123123123123123123' , 1, ['*'], true)

var above_filt = Filter(hydrants, "(LifeCycle_Status = 'Active') AND (Model IS NOT NULL)")

return Count(above_filt)&lt;/LI-CODE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;However, when I try to include the field (Manufacturer_Key) that has coded values, I receive the "&lt;SPAN class=""&gt;Parse Error:&lt;/SPAN&gt;&lt;SPAN&gt;Line 3: Unexpected identifier&lt;/SPAN&gt;" message:&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;LI-CODE lang="c"&gt;var hydrants = FeatureSetByPortalItem(Portal('https://xyz.com/portal/'), '123123123123123123' , 1, ['*'], true)

var above_filt = Filter(hydrants, "(LifeCycle_Status = 'Active') AND (Model IS NOT NULL) AND (Manufacturer_Key IS NOT NULL)")

return Count(above_filt)&lt;/LI-CODE&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;Any help is greatly appreciated!&lt;/P&gt;</description>
      <pubDate>Thu, 08 Aug 2024 21:44:38 GMT</pubDate>
      <guid>https://community.esri.com/t5/arcgis-pro-questions/filter-features-using-coded-value/m-p/1516989#M86666</guid>
      <dc:creator>Chris_S</dc:creator>
      <dc:date>2024-08-08T21:44:38Z</dc:date>
    </item>
    <item>
      <title>Re: Filter features using coded value</title>
      <link>https://community.esri.com/t5/arcgis-pro-questions/filter-features-using-coded-value/m-p/1517544#M86693</link>
      <description>&lt;P&gt;I figured out what was going on here. The issue is the field name I was using was invalid, so I was getting an error. Though this seems like a pretty dumb mistake to make, our system is set up in such a way this actually exposed a deeper error. I'm not going to get into it, but make sure you're using the field names for the layer you're actually calling.&lt;/P&gt;</description>
      <pubDate>Fri, 09 Aug 2024 15:43:00 GMT</pubDate>
      <guid>https://community.esri.com/t5/arcgis-pro-questions/filter-features-using-coded-value/m-p/1517544#M86693</guid>
      <dc:creator>Chris_S</dc:creator>
      <dc:date>2024-08-09T15:43:00Z</dc:date>
    </item>
  </channel>
</rss>

