✎ Filter or Search multiple values

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
~~NOTRANS~~
~~Title: Filter or Search multiple values ~~

A filter or search field makes it easy to search for the occurrence of a specific value within a table/list. If you want to search for multiple values in the same field, you need to use the [[visionx:userprofiles_filters|Profiles and Filter AddOn]]. This allows convenient searches for multiple values. However, sometimes it would be helpful to enter multiple values in a single search field, which the standard search field does not support without source code modifications.

Here’s an example table:

{{:visionx:simple_list.png?nolink&400|}}

The search field looks for a first name matching a specific value, such as //John// or //J*//.

However, if you enter multiple names, like //John;Ma*//, the search will not return results since no first name contains this text. But implementing this is quite simple with a bit of source code:

<code java> filterFirstname.eventConfigureCustomCondition().addListener(new IFilterEditorListener() { @Override public void configureCustomCondition(FilterEditor pEditor) throws Throwable { String sValue = (String)pEditor.getValue();

if (sValue != null) { ICondition cond = new Or();

for (String element : StringUtil.separateList(sValue, ";", true)) { cond = cond.or(new Like(pEditor.getColumnName(), element)); }

pEditor.setCustomCondition(cond); } else { pEditor.setCustomCondition(null); } } });</code>

The Like search enables finding similar values. Wildcards can be defined using *. Searches can also be performed using Equals or other [[https://www.sibvisions.com/files/jvx/current/api/jvx/rad/model/condition/package-summary.html|conditions]].