Experience builder: Filter Data Records stopped working

[TravisSizemore]

Hello, 

I have an Experience Builder page with three tables and a map that I created a couple of years ago. It is hosted on ArcGIS Online, as well as the data that feeds it. Data from the three tables are related to one another through GlobalId-GUID relationships.

1. Top table: "Trip", this is the parent table.
2. Middle table: "Deployment", this is the child of the Trip table (1:M).
3. Bottom table: "End Deployment", this is the child of the Deployment table (1:1).

When a user clicks on the top table, the selection triggers a "Filter data records" action for the middle table. Then, a user can click on that filtered middle table to filter the bottom table (using the same "Filter data records" action. This has worked fine until recently. Now, when you click the middle table without first filtering it, it still shows the related data in the bottom table, but if you click the top table and then the middle table, the bottom table is blank (no selections).

I have tried removing and recreating these data actions in the Experience Builder editor, but can't seem to solve it. I don't know what else to do to troubleshoot. Does anyone have ideas?

[DanJiang · Accepted solution]

Hi @TravisSizemore , 

Thank you for reporting the issue. We've released a patch for online tonight and it should be working now. 

Thanks, 

Dan

[TravisSizemore]

Hi Dan,

You're welcome and thanks for looking into this. The original problem is corrected, but it still doesn't work as it used to. Now if I filter the top and then middle table it selects properly. If I then clear those selections and filter from the bottom up it won't work. In other words, if I select an End Deployment (after previously filtering the aformentioned way), no Deployments are selected. If I refresh the page and then select an End Deployment, it works as intended.

Thanks!

Travis

[DanJiang]

@TravisSizemore  We could not reproduce the issue you mentioned. With the same configuration of the three tables, the filtering action works as expected in the following scenarios.

case 1. click table 1, table 2 get filtered, then click table 2, table 3 get filtered. 

case 2. with the result from case1, click table 3, table 2 get filtered. 

case 3. clear all selections for table 1, 2, 3. click table 3, table 2 get filtered. 

I noticed that you mentioned "no Deployments are selected". Please be aware the action you configured is a filter action, no records will be automatically selected. Perhaps you can try review / reconfigure the actions? If the issue still happens, could you provide us a sample app?

[TravisSizemore]

Hi Dan,

I tested again this morning, and all appears to work just fine. Maybe I clicked something weird yesterday. Thanks again so much for all your help!

Cheers,

Travis

[DanJiang]

You are welcome. Glad to know it's working. 

[krantiYadav75]

Hi @DanJiang 

Can you please share the new patch download link.

[krantiYadav75]

Hi @DanJiang 

In our case, when we apply this filter to data records across multiple layers, selecting a feature on the map using the list widget does not clear that record from the map—it remains selected. This issue only occurs on the first selection. From the second selection onward, features are cleared correctly, but the first selected feature still remains on the map.

[DanJiang]

Hi @krantiYadav75 , 

The patch is automatically installed in the online codes and there is no need to install anything. In your case, this could be a different issue. @KeXu , could you help on this one? 

[krantiYadav75]

Hi @DanJiang

I’m experiencing an issue in ArcGIS Enterprise 11.3. When I apply data filters, the table filters the records correctly, but it also creates the same number of graphics (matching the number of filtered records) on the map. However, when I click "Clear," only one graphic is removed, while the rest remain on the map and are not cleared.

This appears to be a bug in the out-of-the-box "Filter Data Records" action. The issue occurs across all widgets where this action is available.