topic Choice filter not working in Survey123 Connect v3.12.230 in ArcGIS Survey123 Questions

Choice filter not working in Survey123 Connect v3.12.230

Anonymous User — Thu, 04 Mar 2021 03:22:10 GMT

Re-posted from this comment on What's new in ArcGIS Survey123 9 February 2021) blog post

I'm seeing some unexpected behaviour using Survey123 Connect v3.12.230 and Survey123 on Android v3.12.274 with select_one questions with choice filters (bold red in below example).

When a choice filter is present the select_one selection lists won't display.

This isn't an issue in Connect v3.11.123 or Android v3.11.164.

type

name

label

required

required_message

appearance

default

readonly

relevant

calculation

choice_filter

bind::esri:fieldType

bind::esri:fieldLength

text

ASSNBRI

Asset #.

yes

esriFieldTypeString

hidden

raise

Value can be used in field

null

select_one classification1

CLASSIFICATION1

Utility:

yes

minimal

if(string-length(${ASSNBRI}) = '0', '', 'yes')

${raise} = RAISE

esriFieldTypeString

select_one classification2

CLASSIFICATION2

Asset Class:

yes

minimal

if(string-length(${ASSNBRI}) = '0', '', 'yes')

${CLASSIFICATION1} = CLASSIFICATION1 and ${raise} = RAISE

esriFieldTypeString

select_one classification3

CLASSIFICATION3

Asset Type:

yes

minimal

if(string-length(${ASSNBRI}) = '0', '', 'yes')

${CLASSIFICATION1} = CLASSIFICATION1 and ${CLASSIFICATION2} = CLASSIFICATION2 and ${raise} = RAISE

esriFieldTypeString

I tried changing the format of these expressions to the below, but this has no effect.

selected(${raise}, RAISE)

selected(${CLASSIFICATION1}, CLASSIFICATION1) and selected(${raise}, RAISE)

selected(${CLASSIFICATION1}, CLASSIFICATION1) and selected(${CLASSIFICATION2}, CLASSIFICATION2) and selected(${raise}, RAISE)

Choices:

list_name	name	label	CLASSIFICATION1	CLASSIFICATION2	CLASSIFICATION3	RAISE
classification1	Stormwater	Stormwater				y
classification1	Wastewater	Wastewater				y
classification1	Water Supply	Water Supply				y

classification2	Bore	Bore	Stormwater			y
classification2	Chamber	Chamber	Stormwater			y
classification2	Channel	Channel	Stormwater			y
classification2	Control System	Control System	Stormwater			y
classification2	Electrical	Electrical	Stormwater			y
classification2	Filter	Filter	Stormwater			y

Re: Choice filter not working in Survey123 Connect v3.12.230

DougBrowning — Thu, 04 Mar 2021 14:28:55 GMT

I have seen weird things happen when the list name and field name are the same. Change to like ClassificationList or something. For Raise I would put "y" in the calculation vs default - defaults do not always work.

My choice filters I all wrote the opposite, not sure that matters but I have RAISE = ${raise}

These are just guesses though since you said this worked before. Hope it helps

Another with the same issue?

https://community.esri.com/t5/arcgis-survey123-questions/select-one-from-csv-field-empty-on-iphone/m-p/1032724#M32926

Re: Choice filter not working in Survey123 Connect v3.12.230

Anonymous User — Thu, 04 Mar 2021 20:44:54 GMT

Thanks for these suggestions, unfortunately no change though.

This is a survey that's been in use for over a year now, it's functional with versions 3.5 to 3.11.

Re: Choice filter not working in Survey123 Connect v3.12.230

Anonymous User — Tue, 09 Mar 2021 02:49:24 GMT

@JohnPlunkett @ Eagle Technology spotted the problem.

BUG-000137897 Cascading select does not work in ArcGIS Survey123 3.12 if a field used as the choice filter has a name which is listed as a reserved keyword for SQLite.

My survey was using the keyword RAISE, changing this to ACTIVE resolved the problem.

Re: Choice filter not working in Survey123 Connect v3.12.230

SolanaFoo2 — Tue, 23 Mar 2021 13:53:51 GMT

Thank you for posting! Racking my brain all night on this.