In one of our last projects we had the requirement to allow the user to filter tables using the table filter feature. By default you can filter String fields starting with the word that the user provides, but our customer needed to find the rows that contained the criteria.
This is an easy task that can be accomplished by creating a custom Query Listener method.
As by default the filter works with “Starts with” condition you will see that filtering by “tra” will give no result although departments like Administration exists.
In this example we will use Departments table in HR schema.
This is the helper method we use to call the default query listener.
The last step is to set our new method as the table’s query listener.