Show related data for large selections?

[ElijahMlawsky]

I am attempting to rebuild an app originally created in Web AppBuilder (WAB) with Experience Builder (ExpB). This app relies heavily on a REST service with many point features and related tables. Each table has a 1:many relate with the parent point features. The service is loaded into an ArcGIS Online Web Map, which is then used as the data source in WAB and ExpB.

I am experiencing an issue in ExpB where the select>show related action (via spatial select or table widgets) breaks for larger selections (~200+ features), in most cases stalling indefinitely, sometimes crashing out to a "page unresponsive" message in Chrome. In WAB, the select>show related action can return up to the record return limit (10,000 for this particular service) with ease.

I assume that this is a bug with ExpB, but would love to know if there is simply a setting that I am missing. Unfortunately, the ExpB limitation breaks the core functionality of this app.

Similarly, is there any way to enable shift+select for rows in the attribute table? This is another feature of WAB that seems to be missing in ExpB. I have select multiple enabled, but can only add to the selection one row at a time.

I am using ExpB Developer edition 1.16 and can also confirm this behavior in the ArcGIS Online ExpB. Thanks for the advice!

[ElijahMlawsky]

I've stumbled upon something of a workaround, though still not the functionality enjoyed in WAB:

I've added a trigger to the Select widget with a Framework target set to filter related data tables when parent features are selected. Incidentally, if the condition is set to "Use layer's relationship" (i.e. the relationship that is baked into the web service), I get the limited functionality described above. However, if I use "Set custom connection fields" and redefine the relationship keys in ExpB, the filter can handle much larger selections - though the app still times out on very large selections rather than just returning up to the record limit.

In this case, the "show related data" options (from both the select widget and table) still break for all but the smallest selection of features - and even then, I am limited to fetching only the related records that are "loaded," which defaults to 20.

[ShengdiZhang]

Hi @ElijahMlawsky ,

This bug is fixed in the latest February AGOL release.

Please let me know if you have any other questions.

Thanks,

Shengdi

[ElijahMlawsky]

Performance is slightly improved in the 2/2025 update, but the above issues do not appear to be resolved. Please see Case #03819484. Thanks.

Edit: Specifically, the application still crashes when selecting on the order of 10,000 + points, and the "show related data" option does not work for even small selections. I do see that using existing service relationships is now comparable with redefining relates at the app level, which is good progress.

[Ke_Xu]

Hi @ElijahMlawsky,

When selecting a large amount of data using the Select widget, it is possible to experience freezing due to the processing load. This is a known limitation. We will discuss some technical solutions and then optimize accordingly. I will keep you update.

Workaround:

Using a Feature Layer as a replacement for a Map Image Layer.

Thanks,

Ke