User can select different search modes when filtering columns that have text

[iritmaximus]

No description provided.

[iritmaximus]

Possibly something of interest. https://www.material-react-table.com/docs/guides/global-filtering

[juhanikat]

• User can search for exact matches ("sus")
• User can search for substring matches (*sus*)
• User can search for fuzzy matches (*s*u*s*)
• User can switch between these modes in table view
• Documentation is written

[EeroAnt]

#566 enabled substring search

[realtalin]

Tasks:

• Implement logic for changing table column filter modes #600
• Add frontend component for a user to select table column filter modes #601
• Enable filter mode selection for appropriate columns #627

[realtalin]

Decided not to do tests for this, as it's just an in built function of MRT.

Will add a bit more documentation for usage before moving to done.

[karilint]

Test results
OK - Works fine with "Sus"