Select to view content in your preferred language

Table Filter/Query Option in Experience Builder

2134
15
07-20-2023 07:38 AM
Labels (1)
AbiDhakal
Occasional Contributor III

@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

15 Replies
Shen_Zhang
Esri Contributor

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_SECTI...

 

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.

Shen Zhang
AbiDhakal
Occasional Contributor III

@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

0 Kudos
AbiDhakal
Occasional Contributor III

@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

AbiDhakal_0-1716381703789.png

Action

AbiDhakal_1-1716381733513.png

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

AbiDhakal_2-1716381841764.png

Thank you,
Abi

 

 

0 Kudos
Shen_Zhang
Esri Contributor

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?

Shen Zhang
0 Kudos
AbiDhakal
Occasional Contributor III

@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

0 Kudos
AbiDhakal
Occasional Contributor III

@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

 

0 Kudos