Project

General

Profile

Actions

Feature #13347

open

Filtering by issue subject with wildcard

Added by Philipp Zabel about 11 years ago. Updated over 2 years ago.

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

0%

Estimated time:
Resolution:

Description

If I'm right it is not possible to filter issues by subject with a wildcard. This could be very useful, maybe by using "*" character.


Related issues

Related to Redmine - Defect #19786: '%' and '_' are treated as SQL wildcards in issue filterClosed

Actions
Related to Redmine - Feature #35073: Escape values in LIKE statements to prevent injection of placeholders (_ or %)ClosedMarius BĂLTEANU

Actions
Related to Redmine - Feature #38423: Regular expression support for string/text type filtersNew

Actions
Actions #1

Updated by Dipan Mehta about 11 years ago

+1. This would be great to have.

Actions #2

Updated by David Rahusen about 10 years ago

+1

I am wondering this is not yet possible... :-(

Actions #3

Updated by Philipp Kroll over 9 years ago

I'm also interested in this feature.

Actions #4

Updated by Jos Groot Lipman over 9 years ago

There is an undocumented way to do it. You can add these parameters to the URL:

f[]=subject
&op[subject]=~
&v[subject][]=texttofind

All properly url-encoded this becomes:
issues.json?f%5B%5D=subject&op%5Bsubject%5D=%7E&v%5Bsubject%5D%5B%5D=texttofind

I found this by creating a search-query in the GUI and examining the URL that was generated for that.

Again: this is undocumented and may change without notice in a future version but it solved my problem.

Actions #5

Updated by Matthias Schelling almost 9 years ago

+1
can confirm the solution by Jos Groot Lipman is working, looking for a documented way though...

Actions #6

Updated by JW Fuchs over 7 years ago

+1 for this to be implemented as a regular functionality.

Actions #7

Updated by Stéphane Lavergne over 5 years ago

Not sure when it appeared, but the direct prefix form of the ~ operator example in note 4 works for me in Redmine 3.4.1:

issues.json?subject=~texttofind

…so I suppose this issue can be closed?

Actions #8

Updated by Stéphane Frath over 4 years ago

For anyone looking for an answer: the % character works as wildcard in the subject text field
Tested on Redmine 4.0.4

Actions #9

Updated by Go MAEDA over 4 years ago

  • Related to Defect #19786: '%' and '_' are treated as SQL wildcards in issue filter added
Actions #10

Updated by Go MAEDA about 3 years ago

  • Related to Feature #35073: Escape values in LIKE statements to prevent injection of placeholders (_ or %) added
Actions #11

Updated by Go MAEDA over 2 years ago

Stéphane Frath wrote:

For anyone looking for an answer: the % character works as wildcard in the subject text field
Tested on Redmine 4.0.4

The behavior is going to be fixed in the upcoming Redmine 5.0.0 (#35073). Instead, filtering by multiple keywords (AND search) will be available (#35764).

Actions #12

Updated by Go MAEDA 12 months ago

  • Related to Feature #38423: Regular expression support for string/text type filters added
Actions

Also available in: Atom PDF