https://community.esri.com/t5/arcgis-experience-builder-ideas/complex-filtering-data-list-by-selected-feature-in/idi-p/1520690 <P>Hi, I am working on a simple Experience Builder App which allows viewers to select a <STRONG>state county</STRONG>, which then filters a list showing <STRONG>public service providers</STRONG> that operate in that county.&nbsp;<BR /><BR />Many of the public service providers only serve one county, but others serve multiple counties, and some serve all counties. I want the app to work so that when a user clicks on a county in the map, the list is filtered to show all public service providers relevant to that county.<BR /><BR />I have a map Widget and a List Widget displaying the Public Service Providers. I set up a Message Action on the map with Record Selection Changes as a Trigger, and Framework Filter for an action.&nbsp;<BR />I can link <STRONG>County:Name</STRONG> to&nbsp; <STRONG>ServiceProvider:CountiesServed</STRONG>, but this only works for providers that only serve one county.&nbsp;<BR /><BR />I see there is an SQL Expression Builder, having something like&nbsp;<BR /><STRONG>ServiceProvider:CountiesServed&nbsp; CONTAINS&nbsp; County:Name&nbsp;&nbsp;</STRONG>is what I need, but I can only access Fields for the Action Data, and not the Trigger data...&nbsp;<BR /><BR />This seems like it should not be difficult to achieve, but I am not seeing a way to do this. If there were more options for configuring SQL expressions, or something more complicated like bitwise math operations this would be easy.&nbsp;<BR /><BR />Thanks for the help!</P> Tue, 13 Aug 2024 16:43:53 GMT ColtonHashMT 2024-08-13T16:43:53Z https://community.esri.com/t5/arcgis-experience-builder-ideas/complex-filtering-data-list-by-selected-feature-in/idi-p/1520690 <P>Hi, I am working on a simple Experience Builder App which allows viewers to select a <STRONG>state county</STRONG>, which then filters a list showing <STRONG>public service providers</STRONG> that operate in that county.&nbsp;<BR /><BR />Many of the public service providers only serve one county, but others serve multiple counties, and some serve all counties. I want the app to work so that when a user clicks on a county in the map, the list is filtered to show all public service providers relevant to that county.<BR /><BR />I have a map Widget and a List Widget displaying the Public Service Providers. I set up a Message Action on the map with Record Selection Changes as a Trigger, and Framework Filter for an action.&nbsp;<BR />I can link <STRONG>County:Name</STRONG> to&nbsp; <STRONG>ServiceProvider:CountiesServed</STRONG>, but this only works for providers that only serve one county.&nbsp;<BR /><BR />I see there is an SQL Expression Builder, having something like&nbsp;<BR /><STRONG>ServiceProvider:CountiesServed&nbsp; CONTAINS&nbsp; County:Name&nbsp;&nbsp;</STRONG>is what I need, but I can only access Fields for the Action Data, and not the Trigger data...&nbsp;<BR /><BR />This seems like it should not be difficult to achieve, but I am not seeing a way to do this. If there were more options for configuring SQL expressions, or something more complicated like bitwise math operations this would be easy.&nbsp;<BR /><BR />Thanks for the help!</P> Tue, 13 Aug 2024 16:43:53 GMT https://community.esri.com/t5/arcgis-experience-builder-ideas/complex-filtering-data-list-by-selected-feature-in/idi-p/1520690 ColtonHashMT 2024-08-13T16:43:53Z