topic Re: Experience Builder Query Widget: pass attribute query result from 1st layer as spatial filter for 2nd layer in ArcGIS Experience Builder Questions

Experience Builder Query Widget: pass attribute query result from 1st layer as spatial filter for 2nd layer

DavidColey — Wed, 06 Oct 2021 19:02:09 GMT

Hello - Does anyone know how to get this to work:

Selected features from data source—
Choose to return features that have a spatial relationship with features in another layer.
Optionally, a search distance can be applied to the geometries of the features in the related layer.

The framework doesn't seem to honor this. I just have a simple query to select one feature by attribute then want to use that result as the spatial filter "Intersects' for a second layer. As in: Select a parcel by ID, then use that result as the spatial filter to return intersecting flood zone(s) . . .

Re: Experience Builder Query Widget: pass attribute query result from 1st layer as spatial filter for 2nd layer

DavidColey — Thu, 07 Oct 2021 15:15:37 GMT

So from what I can tell when setting up a spatial filter for a layer in the query widget:

For this choice:

Spatial filter>Filter by> Selected features from data source>Add filter layer>Added

The feature layer must come from another layer in another map from another page.

For this choice

Spatial filter>Filter by> Selected features from data source>Add filter layer>Outputs

The only valid sources appear to be the Output from a Geolocator source from the Search Widget. Selected records from a feature layer source in the Search Widget do not appear as a choice.

Re: Experience Builder Query Widget: pass attribute query result from 1st layer as spatial filter for 2nd layer

TianWen — Wed, 13 Oct 2021 02:35:23 GMT

Hi @DavidColey, I think the first choice you mentioned will work. A filter layer actually can be the same layer that is consumed by the query item. Could you provide any more detailed information or a sample app? Thanks!

Re: Experience Builder Query Widget: pass attribute query result from 1st layer as spatial filter for 2nd layer

DavidColey — Wed, 13 Oct 2021 17:48:05 GMT

Hi @TianWen - well, that's the problem. This option:

Spatial filter>Filter by> Selected features from data source>Add filter layer>Added tab

doesn't seem to work. Nothing appears as selection set from my layers' attribute query to set as the filter for the spatial query. The only way I can see to get it to work is when the feature layer is pulled in from another map page in the ExB or an external source...

Re: Experience Builder Query Widget: pass attribute query result from 1st layer as spatial filter for 2nd layer

TianWen — Thu, 14 Oct 2021 02:29:17 GMT

Well, I cannot seem to reproduce the problem. I think screenshots or a sample app would help me figure it out.

Re: Experience Builder Query Widget: pass attribute query result from 1st layer as spatial filter for 2nd layer

DavidColey — Thu, 14 Oct 2021 17:49:00 GMT

Ok thanks @TianWen I see. Ok. This is the desired work flow:

Using the Search widget, the user queries a parcel polygon via a Parcel ID from a feature layer source.

The returned record should be visible as an Output source for the Query tool, where that geometry is then used a a spatial filter for another layer, like Zoning:

As you can see, the Parcel Layer does not show up as an available output source. The 2 output sources that do appear are both Locator output sources.

Re: Experience Builder Query Widget: pass attribute query result from 1st layer as spatial filter for 2nd layer

DavidColey — Thu, 14 Oct 2021 19:43:02 GMT

@TianWen , this is what I have come up with so far:

https://experience.arcgis.com/experience/4a523b8a772b48af921d793b6b9c9563/page/page_10/

Re: Experience Builder Query Widget: pass attribute query result from 1st layer as spatial filter for 2nd layer

TianWen — Fri, 15 Oct 2021 07:10:19 GMT

I see the problem! Actually, Search widget will generate output data source only when it consumes geocode services. So it is as expected.

To achieve your intended goal, you can add the original Parcel layer as a filter layer in the Query. Then use a Filter widget configured with the same data. Apply filter conditions in the Filter widget, then the returned geometries are the candidates that can be used to conduct a spatial filter (select them all in your case).

Re: Experience Builder Query Widget: pass attribute query result from 1st layer as spatial filter for 2nd layer

DavidColey — Fri, 15 Oct 2021 14:44:44 GMT

Hmm, ok thanks @TianWen for looking at this. The Interaction from the help says as much:

"When configured with a locator source, the Search widget generates an output data source that can be used in other widgets. "

Although the help does not specifically say a layer source won't work, now we know. For my use case, I may just leave as is but thanks for the tip on the Filter Widget. I'll give it a try, re-publish and ping you . . .

Re: Experience Builder Query Widget: pass attribute query result from 1st layer as spatial filter for 2nd layer

DavidColey — Fri, 15 Oct 2021 15:00:48 GMT

Hi @TianWen - I gave this a try and the output from the Filter Widget is not showing as an active or available Output Source for the Query Widget:

Am I missing something?

Re: Experience Builder Query Widget: pass attribute query result from 1st layer as spatial filter for 2nd layer

DavidColey — Fri, 15 Oct 2021 15:05:52 GMT

@TianWen - from what I am seeing in the ExB interaction it the Filter widget can consume output from the Query widget result, but not the other way around....

Re: Experience Builder Query Widget: pass attribute query result from 1st layer as spatial filter for 2nd layer

DavidColey — Fri, 15 Oct 2021 15:32:39 GMT

@TianWen - I also tried adding a second query widget where I just set up a simple attribute query. I had hoped that result might be available as an output for my spatial selection query widget, but it is not....

Re: Experience Builder Query Widget: pass attribute query result from 1st layer as spatial filter for 2nd layer

TianWen — Mon, 18 Oct 2021 02:47:31 GMT

You can use the original data source (instead of output, Filter actually does not generate output ds) in the Query as a filter layer. Apply the Filter widget, then the filter layer will update according to the conditions. So you can use the filtered geometries to conduct a spatial filter.

Re: Experience Builder Query Widget: pass attribute query result from 1st layer as spatial filter for 2nd layer

DavidColey — Mon, 18 Oct 2021 18:48:00 GMT

Ok thanks for your time. I can't see anywhere to make that work. I cannot add - as a filter source for the query widget - a layer from the same page and map widget: The map source does not display. As you can see, the map source 'Planning Layers' does not appear under the 'Added' tab:

If the filter source does not come from the same page and map widget source, then it cannot act as filter source for the query widget. It is ignored.

If you can get that workflow to function, that's great but I can't.