topic Table Filter/Query Option in Experience Builder in ArcGIS Experience Builder Questions

Table Filter/Query Option in Experience Builder

AbiDhakal — Thu, 20 Jul 2023 14:38:51 GMT

@Jianxia I have been exploring ExB like the rest, and it appears like we have a long way to go. Keeps me up. Other thing that is very concerning with ExB app is there is no way to open attribute table of a layer by going to the layers' ellipsis - the three dots next to a layer like in WAB. In WAB you can go to the layers' ellipsis and 'View in Attribute Table'. The attribute table offers Options, Filter to do all sorts of querying. This is especially critical/important as it gives an opportunity for an array of query options on all the layers present on the map app to the clients (end users). They are not limited to pre-configured queries only like in ExB.
With ExB the developer of the applications make assumptions on what different queries the clients need and accordingly have a pre-configured, limited query options available on the map app for the clients to perform. There has to be much more than that, Please. The query needs to be open like in WAB where the clients can perform ( have the option) whatever query they want to on any layer they want to that is available on the map app.
Please make a way for the clients to be able to pick and choose what they want to query from any layers attribute tables like in WAB. Please make the query option open on the map apps so the clients can look up query, export table or filter any layers to print a map.

Thank you,
Abi

Re: Table Filter/Query Option in Experience Builder

Shen_Zhang — Fri, 27 Oct 2023 09:12:24 GMT

Hi @AbiDhakal I wanted to let you know that the Table widget now supports the 'Set filter' data action starting from the October 2023 release. You will find the 'Set filter' option in the data action dropdown list of the Table widget, and it is enabled by default. Feel free to give it a try and please let me know if you encounter any issues. Thank you!

Re: Table Filter/Query Option in Experience Builder

AbiDhakal — Fri, 27 Oct 2023 12:07:08 GMT

@Shen_Zhang I will give it a shot once it is available in ArcGIS Enterprise/Portal. Thank you. Hopefully, once the clients filter what they need they are also able to export a CSV file.

Thank you again.
Abi

Re: Table Filter/Query Option in Experience Builder

AbiDhakal — Tue, 05 Dec 2023 16:22:01 GMT

@Shen_ZhangI still do not see a way to apply filter on any layer for any attribute from the map interface like there is in Web AppBuilder. In Web AppBuilder there is the ellipses (...) next to each layer on the map app that you can click to open the table for the layer and then go to options and set any kind of filter. Without this capability displaying and printing a map of only layers, features and attributes desired by the end user is not possible. This is a must have to display and print a map.

Thank you,
Abi

Re: Table Filter/Query Option in Experience Builder

GISAdmin39 — Mon, 22 Apr 2024 19:16:39 GMT

@AbiDhakalDid you ever figure something out to replicate that WAB filtering in ExB?

Re: Table Filter/Query Option in Experience Builder

AbiDhakal — Tue, 23 Apr 2024 17:55:36 GMT

@GISAdmin39

I briefly tired the Table widget and it seems to be working. However, I like the way it used to work in WAB.

Re: Table Filter/Query Option in Experience Builder

AbiDhakal — Tue, 30 Apr 2024 12:21:12 GMT

@GISAdmin39 @Shen_Zhang @Jianxia - Let me take this back. The Filter widget in ArcGIS Enterprise is still not working. Please make it work in the next release.

Thank you,
Abi

Re: Table Filter/Query Option in Experience Builder

BigLouC — Thu, 09 May 2024 18:42:31 GMT

Why would they want us to migrate to EB when its not working properly

Re: Table Filter/Query Option in Experience Builder

Shen_Zhang — Fri, 10 May 2024 02:57:21 GMT

For enterprises, Set filter will be supported in Enterprise 11.3. This is a data action on the framework level so it's not exclusive to the table widget.

Re: Table Filter/Query Option in Experience Builder

AbiDhakal — Fri, 10 May 2024 12:08:27 GMT

@Shen_Zhang- What does data action on a framework level mean? Does it mean that you do not have to go to a widget like the table widget instead you can simply filter from the layer itself like in Web AppBuilder? That would be the most ideal. The way you have it now in ArcGIS Online for Experience Builder by going to the table widget to filter is simply not ideal.

Thank you,
Abi

Re: Table Filter/Query Option in Experience Builder

Shen_Zhang — Sat, 11 May 2024 01:37:07 GMT

The filters are applied to the layers, but you need to set the filters in the Set filter data action from applicable widgets, like table, map layers, query, etc. See a full list of widgets support Set filter here: https://doc.arcgis.com/en/experience-builder/latest/configure-widgets/action-triggers.htm#ESRI_SECTION1_441D594EF43743CEB307F0E9BB308AAF

For instance, if you have a map layers widget and a table widget in your app, you could set filters from either one of them and the filters will be applied to them both. For the workflow in your original post, users can decide whether to set a filter before adding the layers to the table, or setting the filters in table afterwards.

Re: Table Filter/Query Option in Experience Builder

AbiDhakal — Mon, 13 May 2024 12:29:06 GMT

@Shen_Zhang- Thank you for your response.

I did not understand what you were trying to say in your second paragraph. I'm sorry for my ignorance. Would you please be able to explain again.

Thank you,
Abi

Re: Table Filter/Query Option in Experience Builder

AbiDhakal — Wed, 22 May 2024 12:47:00 GMT

@Shen_Zhang- I also see when you enable Layer widget you get the option now to 'View table', however, when I click to 'View table' nothing happens. Also, nothing happens when I click 'Export all'. It shows up the different formats I can export to, but when I click it nothing happens. Only, the transparency toggle works. Please see screen shots below of the configuration below.

Configuration

Action

Upon clicking the ellipses of the layer (...)

Thank you,
Abi

Re: Table Filter/Query Option in Experience Builder

Shen_Zhang — Fri, 14 Jun 2024 03:27:24 GMT

In the second paragraph of my previous post, I was trying to explain how to use Set filter data action to do runtime queries. The set filter works on the layer itself, meaning all the widgets using this layer will be filtered. For example, you have a layer in the Map layers widget and want to add it to the table and add some queries. First, you can add it to the table to see the attributes of the layer. Then you could use the Set filter data action from either the Map layers widget or the Table widget to add runtime queries.

For the issue regarding the Map layers widget, could you share a simple app with me to investigate?

Re: Table Filter/Query Option in Experience Builder

AbiDhakal — Thu, 27 Jun 2024 18:36:37 GMT

@Jianxia @Shen_Zhang - We have a custom append Geoprocessing tool in WAB that allows our users to append shape file from their local machine, however upon testing the Analysis tool in EB there did not seem to be a way to browse to your local machine to append a shape file. Please, if you can, we must have that capability. We will appreciate you.

Thank you,
Abi

Re: Table Filter/Query Option in Experience Builder

AbiDhakal — Fri, 28 Jun 2024 12:13:36 GMT

@Jianxia @Shen_Zhang - With all the great things that you are doing please also include trace and copy in the Edit Widget for EB. That would make the Edit Widget excellent.

Thank you,
Abi