Biarity / Sieve

⚗️ Clean & extensible Sorting, Filtering, and Pagination for ASP.NET Core
Other
1.19k stars 132 forks source link

When the user types special characters (operators which are used for filtering) in the search input, the search result returns all records in the database, not the expected data #207

Open Mohamed-Al-Saeed98 opened 2 months ago

Mohamed-Al-Saeed98 commented 2 months ago

Describe the bug When the user types special characters (operators which are used for filtering) in the search input, the search result returns all records in the database, not the expected data. To Reproduce For example: Filters=Name@=jhon_doe OR Filters=Name@=jhon-_*

Expected behavior -The result from example 1 should be "john_doe" or "not found" if "john_doe" is not in the database. -The result from example 2 should be "john-" or "not found" if "john-" is not in the database. Actual behavior -Returns all data in the database, which breaks the package functionality.

Has anyone else encountered this problem and found a solution for it?