nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Filter widget -selecting multiples values

JoseBarrios1

Hello experience builder community,

Does anyone know if is possible to select multiple values on the experience builder filter widget? I know that it is possible in dashboard but I can't figure out how to do it in exp. builder. An example will be an user selecting multiple U.S. States and ethnic groups to filter a data table. Thanks for any suggestions!

Encontre mais publicações marcadas com

ArcGIS Online

Accepted answers

JoseBarrios1

Well... I just figured it out! It is possible by just selecting "is any of" on the selecting sql statements.

Thanks,

All comments

JoseBarrios1

see if this workflow works for you!

JavierCMartínezPrieto

good afternoon,

I have visited the link (thanks for posting it) and if it is something similar to what I need. I need to make a filter that allows me a multiple selection (as in your experience), the problem is that when I create the filter in the experience it does not show me the values of the list that I have in the survey, but the records that have been sent and being a multiple select, these records appear separated by commas.
How could I create a filter that allows me to perform multiple selection and show me the selection values as they are shown in survey123, that is to say separated and not as they were sent after the survey?

thanks

greetings Javier

P,S: if you speak Spanish, we can write to each other in Spanish. hehehehehe

JoseBarrios1

Hello Javier,

I'm not sure if I'm clearly understand your requirements. Do you mean using the filter widget on Exp. Builder to filter a table widget on the survey123 field that contains the values separated by commas? Take a look at this example that I created. (https://arcg.is/1fjjzv) If you select the "At Risk List" menu at the top menu you can see a set of filters on the left and a table on the right...the user can filter by State...on the State field that contains multiple values. Does this similar to what you need?

JavierCMartínezPrieto

hello @JoseBarrios1
I would like to ask about the filtering for multiple select.
the situation is the following, in the survey you can choose several options in a question, that is to say a multiple select.
the problem occurs in the buldier experience, i would like to be able to filter by each unique value that is in that field. i.e. filter by the list that composes that select multiple and not by the records sent. if i use the expression "is any of" only allows me to select by the options that have been sent and not by the values of the table.

Would you know any way to make this filter.

Thanks in advance.

Greetings Javier

JoseBarrios1

I am confuse... Attached is a small excel sample of the species table structure. The species occur in many states as shown in "State" field.

SpeciesList_Sample.xlsx

JonathanMcDougall

How's your species data held? Are you able to share a grab of a few lines? You wouldn't be creating duplicate records, just ensuring the right species has the right state - you're data would be no bigger than it is just now.

@JoseBarrios1

JoseBarrios1

I clearly understand the workflow. Thank you so much! I created the list that allow me to select multiple States...that work great!. However, if I use this workflow, I will have to duplicate the records many times for each state. I have 18 states with 2,099 species. The result will be an extremely very large table with duplicate records and a very long list of species for the filter. I don't see anyway around to support this many- to-many relationship.

JonathanMcDougall

@JoseBarrios1

I've republished for you, it's still rough but should work as an example.

Elements are as follows;
Map - shows nothing more than the selection from the list, I've not set any actions at all. This dataset is just a dataset of states, nothing more.
List - set to allow multiple selections of "states". It's got one action to select records of species to show in the table.
Table - the data is a table of "species" that was published with the "state" feature layer, so two datasets with the state as a common id. The table is set to show selected records.
Filter - speaks for itself.

Happy to give further info and screenshot to develop further.

JonathanMcDougall

@JoseBarrios1

You may not have a list of species in the map, however, the common field in map, or list, and table is State, I assume.
This being the case, when you add the trigger, it will ask for this common field from the two datasets.
If you look at the link above, you will see I've put "states" into a list, from that list you can select multiple which will then populate the table from selected records. I've left the map there, but no map interaction is needed.
I'll add more records to make it a bit more obvious what's going on.

JoseBarrios1

Hi Jonathan,

Thanks you for your suggestions. The problem is that I don't have a map associated with the table. The table contains a list of species and the requirement is for the user to select multiple States to see the list. I was able to use the widget filter (using the "is any of " sql statement). The only problem that I still have is the duplication of values due to many - many relationship on species-state. The other problem is that the filter affects ALL the other tables on the app.

JonathanMcDougall

Sorry for this being rough - buy may give you ideas. Lists, filters, table, map and extents.

Re-published ExpB

JonathanMcDougall

There's perhaps a couple of ways, some smoother than others. @JoseBarrios1

One approach; allow the user to select the state(s) through a filter with multiple clauses then have a card related to the ethnic group information.

I could put a quick example of what I mean together for you

JoseBarrios1

Well... I just figured it out! It is possible by just selecting "is any of" on the selecting sql statements.

Thanks,

Participe da Conversa

Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.

Links Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.