topic Re: ArcGIS Experience Builder 1.12 - Data Actions for List Widget not working in ArcGIS Experience Builder Questions

ArcGIS Experience Builder 1.12 - Data Actions for List Widget not working

ClangDevGuy — Wed, 19 Jul 2023 22:39:04 GMT

Hey,

I've been going through the process of upgrading my applications/widgets from ExB version 1.10 to 1.12 and noticed that the out-of-the-box List Widget data action isn't working correctly anymore.

I have two different List widgets, Site and Site Updates which have a 1-to-many relationship, so when I click on the "Site" List it will show all the related "Site Updates" in the other list. It worked great in version 1.10 but not in version 1.12 where now the Site Updates list returns 0 records.

Here is action setup I am using:

I would appreciate any help, Thanks!

Re: ArcGIS Experience Builder 1.12 - Data Actions for List Widget not working

josevaldes1 — Thu, 20 Jul 2023 12:33:59 GMT

hi , i have a similar problem. i create a post about my problem https://community.esri.com/t5/arcgis-experience-builder-questions/when-select-from-list-widget-the-feature-info/m-p/1306358#M7551

what i found is that with a hosted feature it works.

The feature i use and does not work is in a microsoft sql. In version 1.11 is working, something changes in 1.12 .

Re: ArcGIS Experience Builder 1.12 - Data Actions for List Widget not working

ClangDevGuy — Thu, 20 Jul 2023 17:08:57 GMT

Thanks for the response. We are also using published services from SQL server and currently in Enterprise 10.9.1, but waiting for an upgrade to 11.1. But, not sure if upgrading will help in this case.

Re: ArcGIS Experience Builder 1.12 - Data Actions for List Widget not working

QuantitativeFuturist — Tue, 25 Jul 2023 22:24:15 GMT

Seeing the same issue here can someone from @JShi_EsriStaff please comment this is a serious issue.

Re: ArcGIS Experience Builder 1.12 - Data Actions for List Widget not working

DanJiang — Fri, 10 Nov 2023 01:15:40 GMT

Hi, we delivered a fix in October Online release to address a similar issue. As the bug could be data-specific, could you please check if the fix work for your case?

Thanks,

Dan

Re: ArcGIS Experience Builder 1.12 - Data Actions for List Widget not working

ClangDevGuy — Tue, 30 Jan 2024 20:37:40 GMT

Hey @DanJiang,

We got around to update our dev environment to Enterprise 11.2 that is using this version of ExB 1.12 and I dug a little deeper and its due to the inconsistency of using GlobalIDs and GUIDS as the relationship for the data action.

I'm basically using the "Data Actions" to query related records from a feature to a feature table. I have GlobalDs and GUIDs for the relationship and the internal built query for selecting sites now uses a "LOWER" in the where statement:

Ex:
(((LOWER(SiteGUID) = '{f725dad7-5205-41d3-956c-1b1a45ff680f}')))

Result is 0 records now, because this was programmed for the "AGOL" globalIDs and not the "Arcgis Portal" globalIDs.

Re: ArcGIS Experience Builder 1.12 - Data Actions for List Widget not working

QuantitativeFuturist — Mon, 12 Feb 2024 18:45:08 GMT

@DanJiang Any updates on this please?

Re: ArcGIS Experience Builder 1.12 - Data Actions for List Widget not working

DanJiang — Sun, 18 Feb 2024 01:38:19 GMT

Hi @QuantitativeFuturist @ClangDevGuy , Do you mean using the LOWER function causes the issue? Could you provide us a sample service to reproduce the bug? We did not discriminate between AGOL globalIDs and Portal globalIDs. And it will help position the issue if you can share the differences with us.

Re: ArcGIS Experience Builder 1.12 - Data Actions for List Widget not working

ClangDevGuy — Tue, 20 Feb 2024 22:01:52 GMT

Hey @DanJiang, I noticed this has been fixed in the ExB version 1.13 where the change in the query is now like this:

(((LOWER(SiteGUID) IN ('{3b790d55-ac22-4009-b4d2-8960b413b9e8}','3b790d55-ac22-4009-b4d2-8960b413b9e8'))))

So, the query includes have the '}' and without. We just can't use the Experience Builder version that is tied to our Portal.

Re: ArcGIS Experience Builder 1.12 - Data Actions for List Widget not working

DanJiang — Wed, 21 Feb 2024 06:20:28 GMT

Oh, I see. I'm afraid the portal version will have a certain lag. I am wondering if you can upgrade your Developer Edition? You can use the higher version Dev Edition to link to portal 11.2, then configure and deploy your apps. But please be noted that custom widgets developed by higher version DE may not work in portal 11.2.

Re: ArcGIS Experience Builder 1.12 - Data Actions for List Widget not working

ClangDevGuy — Wed, 21 Feb 2024 19:10:43 GMT

Thanks Dan, I have been going through the process of upgrading to ExB 1.13 and hosting it to get around this issue.

Just wanted to know if you can expand on your last statement when developing custom widgets in a higher DE version and if there is anything I would really need to consider?

Re: ArcGIS Experience Builder 1.12 - Data Actions for List Widget not working

DanJiang — Mon, 26 Feb 2024 02:14:31 GMT

I think if you want to use the custom widget in your portal, for example, creating exb apps with portal home app and consuming those custom widgets, the core version of the custom widget and portal exb home app must be the same, as the new version may have enhancements or new features that are not compatible with the old version. But if your apps are deployed outside the portal, I think it should be no problem.