I have a list with values in an attribute which contain diacritics. I would like the user to be able to choose multiple values and then upload it to Flow for self service data download.
However, when I open an oracle spatial reader in Forms and use the where clause to add them it doesn't work.
What would be the best way to solve this?
The where clause of the reader is now as follows:
"active" in '$(choose_status)' and "municipality" in '$(choose_municipality)'
- both attributes are strings and published parameters
- the list includes only values from the oracle table
- ‘allow multiple selection’ is on
- choice list delimiter is ',’
- default value is a municipality with diacritics.
The first (choose_status) works. The second (choose_municipality) contains diacritics and does only work for values without diacritics.
I also tried a Tester (municipality in $(choose_municipality)) but it also only works for values of municipalities without diacritics.