<?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 Specify exact text in ArcGIS experience builder filter widget SQL 'contains' command in ArcGIS Experience Builder Questions</title>
    <link>https://community.esri.com/t5/arcgis-experience-builder-questions/specify-exact-text-in-arcgis-experience-builder/m-p/1662705#M21461</link>
    <description>&lt;P&gt;Hi, I'm using ArcGIS Experience Builder filter widget to be used on a single column of data which has the text of survey question answers from 4 separate columns concantenated into a single string, each response from each column is separated by a spacebar. In the filter box in EB I would like the box to contain a list of all possible answers - a single item next to each tick box - to make it look tidy, rather than a concatenated string which appears when the data is loaded.&amp;nbsp; Thus when the user selects 'yes' the map would filter all those points which contain 'yes'.&amp;nbsp; For example yes for the first question and the other 3 questions are blank, then scenario 2 yes yes no no, then scenario 3 blank, yes, blank blank etc.&amp;nbsp; Is this possible with the SQL 'contains' statement in EB, or could there be a work around to this? And also an option to include a single unique item in the filter box, even though in the data it appears as part of a string?&lt;/P&gt;</description>
    <pubDate>Sat, 01 Nov 2025 23:18:00 GMT</pubDate>
    <dc:creator>JonathanHall3</dc:creator>
    <dc:date>2025-11-01T23:18:00Z</dc:date>
    <item>
      <title>Specify exact text in ArcGIS experience builder filter widget SQL 'contains' command</title>
      <link>https://community.esri.com/t5/arcgis-experience-builder-questions/specify-exact-text-in-arcgis-experience-builder/m-p/1662705#M21461</link>
      <description>&lt;P&gt;Hi, I'm using ArcGIS Experience Builder filter widget to be used on a single column of data which has the text of survey question answers from 4 separate columns concantenated into a single string, each response from each column is separated by a spacebar. In the filter box in EB I would like the box to contain a list of all possible answers - a single item next to each tick box - to make it look tidy, rather than a concatenated string which appears when the data is loaded.&amp;nbsp; Thus when the user selects 'yes' the map would filter all those points which contain 'yes'.&amp;nbsp; For example yes for the first question and the other 3 questions are blank, then scenario 2 yes yes no no, then scenario 3 blank, yes, blank blank etc.&amp;nbsp; Is this possible with the SQL 'contains' statement in EB, or could there be a work around to this? And also an option to include a single unique item in the filter box, even though in the data it appears as part of a string?&lt;/P&gt;</description>
      <pubDate>Sat, 01 Nov 2025 23:18:00 GMT</pubDate>
      <guid>https://community.esri.com/t5/arcgis-experience-builder-questions/specify-exact-text-in-arcgis-experience-builder/m-p/1662705#M21461</guid>
      <dc:creator>JonathanHall3</dc:creator>
      <dc:date>2025-11-01T23:18:00Z</dc:date>
    </item>
  </channel>
</rss>

