Unplanned
Last Updated: 09 Jun 2023 19:00 by Dennis
Anton
Created on: 08 Jun 2023 15:55
Category: UI for ASP.NET Core
Type: Feature Request
1
Grid Search Wildcard characters support
It will be great if the search wildcard characters for Grid is possible.
1 comment
Dennis
Posted on: 09 Jun 2023 19:00

Anton --

Thanks for initializing this request for me.

Here are the details of what I'm looking for.

I would like the Search textbox to accept similar wildcard characters that are recognized in SQL.

An underscore '_' would represent any single character.

A percent '%' would represent any 1 or more characters.

I have attached 5 images that represent the major use cases of the behavior.

1. Standard behavior (Contains) - or what we have now.  The string fields are searched as contains. (e.g. "Rober" matches Roberts or Groberts)

2. Contains with Single Wildcard Character using an underscore (e.g. "Ro_er" matches Roberts or Roger or Rogers but not Robberts)

3. Begins With using a percent (e.g. "Rob%" matches Roberts or Robbins but not Grobin)

4. Ends With using a percent (e.g. "%ert" matches Roberts or Herbert but not Werten)

5. Middle Contains using a percent (e.g. "Ru%ert" matches Rupert or Ruppert but not Ruperth)

 

Although this type of functionality is available in the Grid using Column Filtering.  The Search Panel provides an easy way to search across columns.

Allowing this additional search text capability would make the Grid Search Panel incredibly powerful.

Regards,
Dennis