topic Re: Filter table from multiple widgets action in ArcGIS Experience Builder Questions

Filter table from multiple widgets action

Moi_Nccncc — Thu, 27 Jul 2023 05:36:21 GMT

I have two table widgets. When the user selects a value from Widget 1, it filters "Table A" on the map based on the selected Category. However, when the user selects a value from Widget 2, I want "Table A" to be filtered on the map based on the combined selection from both Widget 1 and Widget 2.

Here's the structure of "Table A":

ObjectID Category Zone

1	1	1
2	2	1
3	1	2
4	3	2

The filtering logic should work as follows:

When the user selects a value from Widget 1, "Table A" should be filtered to show only rows where the Category matches the selected value.
When the user selects a value from Widget 2, "Table A" should be filtered to show only rows where both the Category matches the selected value from Widget 1 and the Zone matches the selected value from Widget 2.

For example:

If the user selects Category 1 from Widget 1, the table should be filtered to show rows with ObjectID 1 and 3.
If the user then selects Zone 1 from Widget 2 (while Category 1 is still selected in Widget 1), the table should be further filtered to show only the row with ObjectID 1.

How can I implement the filtering based on both widgets' selections effectively?

Re: Filter table from multiple widgets action

ChristopherCounsell — Tue, 01 Aug 2023 12:03:58 GMT

This is a little bit difficult to follow. Some screenshots would help. It's because of the words being used interchangeably - table widgets, select a value from a widget (is this the table widget), filtering the table on the map? It doesn't sound right.

We have set up things like this where you:

Add two chart widgets based on categories
To each of these, add a message action to filter the table
Users can then select from the table to flash or zoom to or filter the record on the map.

I would generally recommend keeping any 'filters' to be obvious to the end user, and try to avoid stacking the workflow. It will be very confusing to them otherwise. That's why the chart infographics, or actual filter widget are good. They stay on screen with a visual representation of what is getting filtered or not.

Re: Filter table from multiple widgets action

DanJiang — Thu, 03 Aug 2023 08:05:46 GMT

Hi @Moi_Nccncc ,

Based on my understanding, you can achieve the filtering goal with the following configurations.

1. Under Widget 1's setting panel, add a message action, trigger is the Widget 1's selection change and the action is the framework-filter on the Table A's data source.

2. Under Widget 2's setting panel, add a message action, trigger is the Widget 2's selection change, and the action is the framework-filter on the same data source (Table A's data source)

3. The filters on the same data source is appended, so the widget consuming the data source (in this case is the table A) will reflect the combined effects.

Re: Filter table from multiple widgets action

Moi_Nccncc — Thu, 03 Aug 2023 08:19:52 GMT

Hi DanJiang.

The table dose not keep the previous applied filter. every time an filter action happened it clear old one and apply the new one. So you click widget 2 it clean widget 1 filter and apply widget 2 filter only.
I am using in my case ArcGIS Portal 10.9.1 not 11.1.

Re: Filter table from multiple widgets action

DanJiang — Thu, 03 Aug 2023 08:39:34 GMT

@Moi_Nccncc I have a quick demo app configured with your case https://experience.arcgis.com/experience/9f156b0080bb4f80bb7ccd42cf3656a1/ It works on AGOL, which is the latest version. Could you have a try with a newly version?

Re: Filter table from multiple widgets action

Moi_Nccncc — Thu, 03 Aug 2023 08:57:47 GMT

I will try, but What I have noticed is the following.

I have 2 layers which I apply 4 filters on them from 4 different widgets.

The first one is a layer from a web map which is added to my map widget . This works fine and all filters applied normally on this layer.

The second layer is normal layer (not from a web map ana not added to my map) and I apply the same filters from same widgets(this is the one which has a problem).

I could use the first one as both have the same source but I did this because I need to get the count when applying a filters which is calling a rest with statistic count, because the this layer has a join with a table the statistic request failed (This an old problem not solved yet). that's why I had to create a sperate layer without Join.

Re: Filter table from multiple widgets action

DanJiang — Thu, 03 Aug 2023 09:13:37 GMT

The filter action doesn't differentiate between data source types, whether added in web map or not, it should all work. It is hard to tell what is wrong from the description. My best guess could be the trigger/action connection fields were mismatched. If you wish to provide a sample app, I can help take a look.

Re: Filter table from multiple widgets action

Moi_Nccncc — Thu, 03 Aug 2023 09:19:20 GMT

I was following the requests going to the server and could see every request going on every action. the filters are correct and no errors for both layers. the only different is layer1 (web layer added to the map) goes with all filters but the second one clears the previous filter and sends only the new one. I will try to get more info if possible why this happening. I will send the request coming for each layer for each widget.

Re: Filter table from multiple widgets action

Moi_Nccncc — Thu, 03 Aug 2023 09:40:34 GMT

Here is the requests going to the server

When Click on widget 1. 2 requests are going to the server one for layer 1 and second for layer 2 (2 actions applied);

(First request comes from one click on widget 1).

Request 1 to Layer1. 1 filter after click on widget 1 - /arcgis/rest/services/Portal/landmarks_NoCategories/MapServer/0/query?f=json&resultOffset=0&resultRecordCount=50&where=CATEGORY_ID IN (1)&orderByFields=&outFields=*&returnGeometry=false&spatialRel=esriSpatialRelIntersects

Request 1 to Layer2 . filter after click on widget 1 - arcgis/rest/services/Portal/Landmarks_AR/MapServer/0/query?f=json&resultOffset=0&resultRecordCount=50&where=CATEGORY_ID IN (1)&orderByFields=&outFields=*&returnGeometry=false&spatialRel=esriSpatialRelIntersects

(Second request comes from one click on widget 2).

Request 2 to Layer1. filter after click on widget 2 - (First filter was cleared and second filter only applied).
/arcgis/rest/services/Portal/landmarks_NoCategories/MapServer/0/query?f=json&resultOffset=0&resultRecordCount=50&where=SUBCATEGORY_ID IN (600)&orderByFields=&outFields=*&returnGeometry=false&spatialRel=esriSpatialRelIntersects

Request 2 to Layer2. filter after click on widget 2 - (2 filters applied first and second as excpected).

arcgis/rest/services/Portal/Landmarks_AR/MapServer/0/query?f=json&resultOffset=0&resultRecordCount=50&where=SUBCATEGORY_ID IN (600) AND CATEGORY_ID IN (1)&orderByFields=&outFields=*&returnGeometry=false&spatialRel=esriSpatialRelIntersects

Re: Filter table from multiple widgets action

DanJiang — Fri, 04 Aug 2023 07:34:26 GMT

@Moi_Nccncc I did a test on the single layer case and updated the above sample app (see page two). It works as expected, that the requests are the combined filters. I could not tell why the filter is replaced with the latest one in your case. Maybe contact a support engineer will better help position the reason.

Re: Filter table from multiple widgets action

Moi_Nccncc — Sat, 05 Aug 2023 11:03:05 GMT

cannot access your sample (Public Account user cannot access this application.) 😞

Re: Filter table from multiple widgets action

Moi_Nccncc — Sat, 05 Aug 2023 11:42:17 GMT

I have public account so I am not able to access you sample.

Re: Filter table from multiple widgets action

ChristopherCounsell — Sun, 06 Aug 2023 01:22:11 GMT

@DanJiang the user is on Portal for ArcGIS 10.9.1. It was released in Nov 2021. This is equivalent to Experience Builder 1.5. The current release of ArcGIS Online is on Experience Builder 1.12.

https://developers.arcgis.com/experience-builder/guide/release-versions/

There's a good chance that the builder has changed significantly over the 7 updates to Experience Builder and the underlying JS API.

I can't see anything specific in the release notes to confirm if it will/won't work for the user's environment, but it's probably worthwhile to test in an equivalent environment.

https://developers.arcgis.com/experience-builder/guide/whats-new/

Re: Filter table from multiple widgets action

DanJiang — Mon, 07 Aug 2023 01:56:17 GMT

@Moi_Nccncc sorry about that. I've shared the app public, please try again.

Re: Filter table from multiple widgets action

DanJiang — Mon, 07 Aug 2023 02:06:50 GMT

Yes, there could be bug fixes among those releases.