Can we Filter in Explore on text information in the data, e.g in Biotope, Remarks on soil: b_soils = 'Zink'? AI asking suggests Javascript: b_soils == 'Zink', but so far no success?!
Accepted answer
Hi joseph,
thanks for reporting this. It's a bug in Arena, and your syntax was correct. The filter kept the quotes as part of the text it was searching for, so it looked for 'Zink' with the quotes included and found no records. The editor could also reject = as invalid. We've already fixed this, and the fix will be in the next version of Arena.
Once it's released, you can filter on text like this:
b_soils = 'Zink'
b_soils == 'Zink' will work too.
Please note that this finds records where the whole value is exactly Zink, and it's case-sensitive, so it won't match zink or Zink and clay.
Please be careful with the > and < workaround in the meantime. These operators compare text alphabetically and don't check whether a value contains a word, so the results may look right but can include the wrong records or miss some.
Many thanks,
The Open Foris Arena Team