topic Re: Webmap layer filter by "contains" in ArcGIS Online Questions

Webmap layer filter by "contains"

NaomiBegg2 — Thu, 22 Nov 2018 04:01:22 GMT

I have a layer which is created in Survey123. One of the questions is a select multiple type. On this question I want to create layer filters so that if it contains a certain text then it will appear in the layer. The only options I can see is for it to be exactly one thing (or not or blank).

I have 6 different options within the multi type question. That leads to 61 different selection combinations. I was hoping that this tool would save me from having to create 61 different test surveys so that I can group them all which would look like (issues is a AND issues is b AND issues is c AND ...)

Is there any other way I can do this? Am I missing something obvious?

Re: Webmap layer filter by "contains"

EdApalinski — Fri, 23 Nov 2018 20:16:37 GMT

Hi,

The layer filter in the webmap should give you an option to use contains and add multiple expressions as an Or statement as in the example in the attached image. You can also set up a filter widget in a Web App builder application to accomplish this.

Cheers!

Re: Webmap layer filter by "contains"

NaomiBegg2 — Sun, 25 Nov 2018 19:49:10 GMT

That's exactly what I'm after but for some reason I only have four options within the filter for my layer.

Re: Webmap layer filter by "contains"

EdApalinski — Mon, 26 Nov 2018 15:09:22 GMT

I believe the reason you only see is, is not, etc.. is because the field is a number data type. While the label is text the data element which is written to the feature service is a number type, probably 1,2,3, etc.. Odd that the filter does not use the actual database value instead of the label. I have a feature service with a domain used in collecotr which shows the 1,2,3 instead of the label. If you built the survey in the Survey123 Connect app you could use the labels as the database values however spaces are not valid so you will need to use underscores. If you used the web version perhaps you can change the domain values to be text instead of number based.

Hope this helps,

Re: Webmap layer filter by "contains"

NaomiBegg2 — Mon, 26 Nov 2018 19:59:04 GMT

I'm hoping that it hasn't given itself a second lot of code to confuse things!

Yes I created it using connect and this is what it shows within AGOL.

Re: Webmap layer filter by "contains"

EdApalinski — Mon, 26 Nov 2018 20:07:33 GMT

I looked at a feature service published using Connect and sure enough the select_one fields do not have the option for 'contains'. Free text fields do. You might want to ask this question in the Survey 123 Community since it looks like the select_one and possibly the select_many field types are having the issue.

Cheers

Re: Webmap layer filter by "contains"

EdApalinski — Mon, 26 Nov 2018 20:11:15 GMT

just had a thought, you could try to set the bind::esri:fieldType column to esriFieldTypeString in the xls form.

Re: Webmap layer filter by "contains"

NaomiBegg2 — Mon, 26 Nov 2018 20:24:46 GMT

How do I do this?

Re: Webmap layer filter by "contains"

NaomiBegg2 — Mon, 26 Nov 2018 20:27:49 GMT

Figured it, just testing now.

It doesn't appear to have been successful 😕

Re: Webmap layer filter by "contains"

Anonymous User — Fri, 30 Nov 2018 20:07:40 GMT

Survey123 for ArcGIS‌

Re: Webmap layer filter by "contains"

JamesTedrick — Fri, 30 Nov 2018 20:48:42 GMT

Hi Naomi,

A select_multiple field is stored as a string (text) field and should have the option for contains in the filter, as in this example:

There should not be a domain (choice list) associated with a select_multiple, as that prevents the multiple values from being displayed (multiple values are stored as a comma-separated list, so the combinations rapidly become more than we want to store in a domain)

A select_one question (which is discussed in the comments) is stored as a string field with a domain (the choice list) which restricts the value to only a predefined set.

Did you originally create the question as a select_one and then change it to a select_multiple later? If so, you will need to remove the choice list.

Re: Webmap layer filter by "contains"

NaomiBegg2 — Sun, 02 Dec 2018 20:40:53 GMT

This has always been a select_multiple layer and is required to be. If you see this question you will see that the domain names didn't follow through on the layer https://community.esri.com/thread/224848-domain-values-from-survey123-not-showing-in-webmap.

I do require domain names however as the choices have been created in code which would mean nothing without the domain to turn it into English. Therefore I started to created the domains within the layer on AGOL. If I were to remove these how would I then have a correct label showing that_doesnt_look_horrible_like_this ?

Re: Webmap layer filter by "contains"

JamesTedrick — Mon, 03 Dec 2018 03:16:45 GMT

Hi Naomi,

As I mentioned above, domains can't work with select_multiple questions - domains allow only one choice to be saved. To display human-readable labels for a select_multiple question, you can use an Arcade expression - see https://community.esri.com/groups/survey123/blog/2018/10/10/labels-for-multiple-choice-questions-using-arcade

Re: Webmap layer filter by "contains"

NaomiBegg2 — Tue, 04 Dec 2018 01:48:05 GMT

Great, that was the direction I needed Along with this bit which showed me where to actually put the code! https://community.esri.com/groups/survey123/blog/2017/12/18/use-arcade-to-improve-survey123-other-answers-in-pop-ups

In the end I chose a simple Replace statement.

Re: Webmap layer filter by "contains"

NicolasGIS — Thu, 21 Nov 2019 07:26:22 GMT

Was the symbology a unique renderer based on that field ?

I am under the impression that "contains" is not available if the symbology is made on that field.

Too bad...

Re: Webmap layer filter by "contains"

Anonymous User — Wed, 04 Nov 2020 18:33:36 GMT

Hi James,

I have this exact same problem, with an active survey. I don't understand how to remove the choice list, so I can choose "contains" to filter my field by, without having survey respondents lose the choices they select from? Can you elaborate on what the fix is here so that my users can still "select multiple" in an active survey and I can select "contains" as a filter in my web map?

Re: Webmap layer filter by "contains"

JamesTedrick — Wed, 04 Nov 2020 18:52:27 GMT

Hi Erica,

The fix is only in the web map that displays the results, not the form. The blog post

Labels for Multiple Choice Questions Using Arcade describes how to make a custom Arcade expression for viewing the list of choices; you would then modify the web map's pop-up to not display the multiple choice question directly, but rather the Arcade expression.

Re: Webmap layer filter by "contains"

Anonymous User — Wed, 04 Nov 2020 19:40:55 GMT

Thanks for the quick reply! I'm fine with the way things show up in my pop-up, but I want the users in my web map to be able to choose "contains" when filtering, instead of "is". This is possible for this "select_multiple" field in my layer in Survey123, but not via my web map. Is there a fix?

Re: Webmap layer filter by "contains"

JamesTedrick — Wed, 04 Nov 2020 20:05:57 GMT

Hi Erica,

If there is a list attached to a field, it should be removed. See the 'Delete a List' topic in Define attribute lists and ranges—ArcGIS Online Help | Documentation

Re: Webmap layer filter by "contains"

Anonymous User — Wed, 04 Nov 2020 20:31:41 GMT

In that section, it looks like if I delete that list, the users of my survey will no longer be able to have those values to choose from. I don't want them to have to remember the choices...