<?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 List of related table from intersect features in Developers Questions</title>
    <link>https://community.esri.com/t5/developers-questions/list-of-related-table-from-intersect-features/m-p/1320038#M6715</link>
    <description>&lt;P&gt;Hi&lt;/P&gt;&lt;P&gt;I want to have the list from of attributes in a related table that come from features object that intersects a polygon (attribute rule: list of road signs from intersected poles).&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I have the error "Entité attendue" in french (Feature needed?) at line 5 of the following code.&lt;/P&gt;&lt;P&gt;Thanks for help&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;var supports = FeatureSetByName($datastore, "SIG.Support", ["interventionsupporttxt"]);&lt;BR /&gt;var inter = Intersects(supports, $feature);&lt;/P&gt;&lt;P&gt;// Have a list of road panels from supports&lt;BR /&gt;var panneaux = FeatureSetByRelationshipName(inter, "SIG.Support_PanneauSignalisation", ["interventionpanneautxt"]);&lt;/P&gt;&lt;P&gt;// Statistics for road panel&lt;BR /&gt;var panneauStats = GroupBy(panneaux, "interventionpanneautxt", [{ name: 'NbrInterventionParPanneau', expression: '1', statistic: 'COUNT' }]);&lt;/P&gt;&lt;P&gt;// Final output&lt;BR /&gt;var finalOutput = "";&lt;BR /&gt;for (var stat in panneauStats){&lt;BR /&gt;finalOutput += panneauStats[stat].NbrInterventionParPanneau + " " + panneauStats[stat].value + TextFormatting.NewLine;&lt;BR /&gt;}&lt;/P&gt;&lt;P&gt;return finalOutput;&lt;/P&gt;</description>
    <pubDate>Fri, 18 Aug 2023 12:28:31 GMT</pubDate>
    <dc:creator>mfafard</dc:creator>
    <dc:date>2023-08-18T12:28:31Z</dc:date>
    <item>
      <title>List of related table from intersect features</title>
      <link>https://community.esri.com/t5/developers-questions/list-of-related-table-from-intersect-features/m-p/1320038#M6715</link>
      <description>&lt;P&gt;Hi&lt;/P&gt;&lt;P&gt;I want to have the list from of attributes in a related table that come from features object that intersects a polygon (attribute rule: list of road signs from intersected poles).&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I have the error "Entité attendue" in french (Feature needed?) at line 5 of the following code.&lt;/P&gt;&lt;P&gt;Thanks for help&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;var supports = FeatureSetByName($datastore, "SIG.Support", ["interventionsupporttxt"]);&lt;BR /&gt;var inter = Intersects(supports, $feature);&lt;/P&gt;&lt;P&gt;// Have a list of road panels from supports&lt;BR /&gt;var panneaux = FeatureSetByRelationshipName(inter, "SIG.Support_PanneauSignalisation", ["interventionpanneautxt"]);&lt;/P&gt;&lt;P&gt;// Statistics for road panel&lt;BR /&gt;var panneauStats = GroupBy(panneaux, "interventionpanneautxt", [{ name: 'NbrInterventionParPanneau', expression: '1', statistic: 'COUNT' }]);&lt;/P&gt;&lt;P&gt;// Final output&lt;BR /&gt;var finalOutput = "";&lt;BR /&gt;for (var stat in panneauStats){&lt;BR /&gt;finalOutput += panneauStats[stat].NbrInterventionParPanneau + " " + panneauStats[stat].value + TextFormatting.NewLine;&lt;BR /&gt;}&lt;/P&gt;&lt;P&gt;return finalOutput;&lt;/P&gt;</description>
      <pubDate>Fri, 18 Aug 2023 12:28:31 GMT</pubDate>
      <guid>https://community.esri.com/t5/developers-questions/list-of-related-table-from-intersect-features/m-p/1320038#M6715</guid>
      <dc:creator>mfafard</dc:creator>
      <dc:date>2023-08-18T12:28:31Z</dc:date>
    </item>
  </channel>
</rss>

