Filtering text in Explore

  • Asked
  • Active
  • Viewed 494 times
0

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?!

1

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

1

Accepted answer

Hi Joseph,
Thank you for bringing this up. Text filtering capabilities in Explore will be further improved and enhanced soon to make searching through text data smoother and more intuitive.
Thanks again for your patience and feedback as we continue to refine Arena!
Best regards,
The Open Foris Arena Team

0

Accepted answer

Using the operator > or >= will give a result, so: b_soils > 'zink' shows all the records containing the text 'zink', < and <= the records, I assume(d), without the text 'zink'.

0

Accepted answer

But, using b_soils = 'zink' delivers indeed only the record(s) with the text exactly, and b_soils >= all the comments that contain 'zink' in whatever way: zink!!, zink?, Zink, or as part of of the text in the comment: just what I need!

The other (>, <, <=) react not as expected, maybe because of what you said: looking alphabetically.

In the meantime, I need operater(s) in the Explore Filter for: 'text' included, excluded, case sensitive or not, == is by the way not an operator that can be selected in Explore Filter.

It would be nice if the existing operators could be used safely for this in the Explorer Filter tool.

Joseph

Your answer

Markdown text. Shortcuts: Ctrl+B bold, Ctrl+I italic, Ctrl+K link, Ctrl+E code, Ctrl+Shift+V paste as plain text. Tab indents list items and code; press Escape, then Tab, to leave the text box.

Insert an image

Say what the image shows, for people who can't see it.

Tip: type a few words from the error message, or put a tag in [brackets] to look only there.

Menu

Keyboard shortcuts

Anywhere

?
Show this list
/
Search
g h
Go to the home page
g q
Go to the questions
g t
Go to the tags
g u
Go to the users
a
Ask a question

Lists of questions

j k
Next or previous question
Enter
Open the question

Question pages

j k
Next or previous post

Shortcuts never apply while you type in a text field. Members can turn them off in their preferences.