idea Allow EB users to create custom query statements just like in the Filter widget in WAB in ArcGIS Experience Builder Ideas

Allow EB users to create custom query statements just like in the Filter widget in WAB

DigitalenCity — Fri, 25 Nov 2022 03:47:02 GMT

Hi,

I wish there will be an option to allow users to create their own query statements (as many as they like) and not just pre-defined queries we set for them. And unique values must get filtered by the previous statement.

This is already implemented in the Filter widget in WAB but it's not smart enough to filter the unique values on the second query ("contingent values").

Say

1st filter. Category is Food
2nd filter. Subcategory is Restaurant, Coffee Shops, Tea Shop etc. and should no longer show me subcategory values which belong to Transport or Health or Business Category etc.

I hope I am making sense.

Re: Allow EB users to create custom query statements just like in the Filter widget in WAB

YvonneBooysen — Tue, 13 Dec 2022 10:57:26 GMT

Definitely noticing some pain points from not having this ability. We have to skill someone up in Map Viewer as soon as they have any interest in filtering data for themselves and that's a huge step when custom filters already exist in WAB and worked really well.

Re: Allow EB users to create custom query statements just like in the Filter widget in WAB

andrewdc_tt — Tue, 14 Mar 2023 03:45:56 GMT

We would like to see a Custom Filter option in Experience Builder too!

The current option to predefine filters only is not sufficient. I am still creating WebAppBuilder apps for people who want to be able to define their own filters on layers in the map.

Re: Allow EB users to create custom query statements just like in the Filter widget in WAB

RayKidd — Fri, 17 Mar 2023 15:29:14 GMT

I would like to second this request, this is a real issue on a project I'm working on: users would like to create their own filters within Experience Builder but this is not currently possible as far as I can tell.

Re: Allow EB users to create custom query statements just like in the Filter widget in WAB

Micah_Stailey — Tue, 05 Sep 2023 21:54:02 GMT

I would like to see this feature implemented in ExB.

Re: Allow EB users to create custom query statements just like in the Filter widget in WAB

ChristosP — Wed, 13 Sep 2023 14:44:35 GMT

Yes! Please, we need this feature in EB! It really limits the user if they have to rely on custom queries built by the developer. There can be so many variations.

Re: Allow EB users to create custom query statements just like in the Filter widget in WAB

AValenski — Wed, 08 Nov 2023 08:31:17 GMT

@DerekLaw are there any plans to implement this? Having user-defined queries/filters is a must and it is a bit shocking to see that Esri hasn't implemented this, especially since it was available in WAB like a decade ago.

Re: Allow EB users to create custom query statements just like in the Filter widget in WAB

DerekLaw — Wed, 08 Nov 2023 23:50:47 GMT

Hi @AValenski,

I don't work on the Experience Builder product, so I'm unable to respond to your question. Sorry. I will defer to someone on the Experience Builder team to comment.

Re: Allow EB users to create custom query statements just like in the Filter widget in WAB

Sibe — Thu, 23 May 2024 14:51:11 GMT

It would be really helpful to let users built their own query in Experience Builder. There are many variations possible and for the interface it's not a good idea to predefine them all for the user. Please implement this feature in the filter widget Esri.

Re: Allow EB users to create custom query statements just like in the Filter widget in WAB

BlakeTerhune — Fri, 13 Sep 2024 22:36:57 GMT

My first attempt to work with the query and filter widgets was to implement a way for the user to build their own SQL. The app I'm building has many layers that have different ways to search so it's not reasonable to build out every combination of SQL statements. Using the Search widget is not reasonable because the users need to specify more complex logic with AND/OR operators. Please consider adding this functionality in Experience Builder.

Re: Allow EB users to create custom query statements just like in the Filter widget in WAB

IgorAtamanchuk — Tue, 19 Nov 2024 15:21:53 GMT

It's a very needed feature indeed. Prebuilding everything does not make sense. Please Add this functionality.

Re: Allow EB users to create custom query statements just like in the Filter widget in WAB

PeterMcIntosh — Tue, 19 Nov 2024 20:37:26 GMT

I agree with all the points made above. This feature is absolutely necessary. Please add this functionality.

Re: Allow EB users to create custom query statements just like in the Filter widget in WAB

JordanCarmona — Fri, 13 Dec 2024 18:38:21 GMT

Allowing users to run their own searches makes sense, taken to its logical extreme, you're asking the ExB author to try and imagine every possible query and pre-build them.

The path of least resistance here is to allow a user to run their own query. Since this feature was available in WAB, our ExB users expect parity here.

Re: Allow EB users to create custom query statements just like in the Filter widget in WAB

JordanCarmona — Fri, 13 Dec 2024 18:47:57 GMT

The current state is the ExB authors are constantly fielding questions to add one-off questions and then negotiating with users as to whether or not those should be added. It is definitely an encumbrance to maintaining the application.

@Jianxia is this functionality on the ExB team's radar?

Re: Allow EB users to create custom query statements just like in the Filter widget in WAB

BlakeTerhune — Fri, 13 Dec 2024 18:48:13 GMT

Even if we could create a query with parameters for the user to complete, that would be helpful.

Re: Allow EB users to create custom query statements just like in the Filter widget in WAB

Jianxia — Fri, 13 Dec 2024 23:50:00 GMT

Hi all, ability to allow end users to create their own SQL expressions (custom filter) is now available in the Filter widget in Experience Builder for ArcGIS Online and developer edition 1.16. See the blog post for details. It will be available in Enterprise 11.5.

Re: Allow EB users to create custom query statements just like in the Filter widget in WAB - Status changed to: Implemented

Jianxia — Fri, 13 Dec 2024 23:51:24 GMT

implemented in the Filter widget in Experience Builder for ArcGIS Online and developer edition 1.16. Will be available in Enterprise 11.5.

Re: Allow EB users to create custom query statements just like in the Filter widget in WAB

bigmapguy — Mon, 30 Dec 2024 14:08:29 GMT

Thank you @Jianxia. Is it possible to use developer edition 1.16 for this feature while being on enterprise 11.1?