Project

General

Profile

Actions

Feature #38423

open

Regular expression support for string/text type filters

Added by Go MAEDA 11 months ago. Updated 11 months ago.

Status:
New
Priority:
Normal
Assignee:
-
Category:
Filters
Target version:
-
Start date:
Due date:
% Done:

0%

Estimated time:
Resolution:

Description

I suggest adding a new operator that does regular expression matching for string/text type filters.

Currently, string or text filters such as Subject, Description, and Notes use SQL's LIKE to find objects that match the given search string. Needless to say, support for regular expressions allows for more flexible searches. Since recent versions of MySQL, PostgreSQL, and SQLite allow regular expressions in the WHERE clause, I think it is possible to implement the new regexp operator.


Files

38423.patch (4.54 KB) 38423.patch Go MAEDA, 2023-04-10 17:30

Related issues

Related to Redmine - Feature #13347: Filtering by issue subject with wildcardNew

Actions
Actions #1

Updated by Go MAEDA 11 months ago

I wrote a patch, but it may be vulnerable to ReDoS (regular expression denial of service) because it accepts regular expression input from users.

Actions #2

Updated by Go MAEDA 11 months ago

  • Related to Feature #13347: Filtering by issue subject with wildcard added
Actions

Also available in: Atom PDF