プロジェクト

全般

プロフィール

Vote #71897

未完了

Ticket list filter: More flexible filter conditions

Admin Redmine さんが7ヶ月前に追加. 7ヶ月前に更新.

ステータス:
New
優先度:
通常
担当者:
-
カテゴリ:
Issues filter_56
対象バージョン:
-
開始日:
2022/05/09
期日:
進捗率:

0%

予定工数:
category_id:
56
version_id:
0
issue_org_id:
10999
author_id:
21087
assigned_to_id:
0
comments:
32
status_id:
1
tracker_id:
2
plus1:
20
affected_version:
closed_on:
affected_version_id:
ステータス-->[New]

説明

I have not found any workaround on that by now ...

As far as I understand it, the filter conditions for the ticket list (text fields) filter on an exact phrase in any case. With that behaviour, I can't filter for tickets containing i.e. 2 words at random positions in the field. Normally I would circumvent that by just adding another filter on the same field, but unfortunately that is blocked - only one condition per field is allowed.

I would suggest to either

  • allow multiple filter conditions on the same field, connected by "AND", or
  • implement some kind of optional pattern search like RegEx, or
  • (preferred) implement search pattern interpretation rules for text fields, like a choice of "exact phrase / all words (AND) / any word (OR) / RegEx" as drop down list.

journals

The first suggestion is related to #1140.
--------------------------------------------------------------------------------
+1 see also #6332
--------------------------------------------------------------------------------
+1
--------------------------------------------------------------------------------
+1
--------------------------------------------------------------------------------
+1
--------------------------------------------------------------------------------
+1

Would also like to see it for (multi-select) lists:
* @any of@ (replaces @is@)
* @none of@ (replaces @is not@)
* @all of@
* @not all of@
* @is empty@ (replaces @none@)
* @is not empty@ (replaces @any@)
--------------------------------------------------------------------------------
*Note*: you can currently filter _text_ fields thus:
@field contains value1%value2@

Obvious caveat: @value1@ must be before @value2@ in @field@.

--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
+1.

I would suggest allowing to bypass UI filter limitations accepting a query expressed in query language.
With this, next goals would be achieved:

* Not adding complexity to current user interface, no need to develop complex user interface to express complex queries.
* Easy to develop if query language matchs internal query ruby on rails languages (I am not a ruby developer, I am not sure how queries are expressed internally, but if so, sure the patch to achieve this would be very small).
* Queries would not be limited to user interface, offering all features availables at backend.
* Any user with some development hability could express any query.

At front end option to use query language instead of current form should be offered to users.

Any ruby on rails developer could throw an opinion on this, is it feasible?

--------------------------------------------------------------------------------
+1 :)
--------------------------------------------------------------------------------
+1
--------------------------------------------------------------------------------
+1

I think it's better if we could choose in the 'list' formatted custom fields.

@ go2null wrote:
> +1
>
> Would also like to see it for (multi-select) lists:
> * @any of@ (replaces @is@)
> * @none of@ (replaces @is not@)
> * @all of@
> * @not all of@
> * @is empty@ (replaces @none@)
> * @is not empty@ (replaces @any@)

--------------------------------------------------------------------------------
+1
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
+1
--------------------------------------------------------------------------------
+10

I don't find plugin that do this, I try _query plugin but it's between 2 different filters.
I want to search (@any of@) words in only issues description filter, for example: word1 OR word2

@ go2null wrote:
>
> Would also like to see it for (multi-select) lists:
> * @any of@ (replaces @is@)
> * @none of@ (replaces @is not@)
> * @all of@
> * @not all of@
> * @is empty@ (replaces @none@)
> * @is not empty@ (replaces @any@)

--------------------------------------------------------------------------------
Dear Jean Louis
Thank you for your note. I see your point. For the list type fields, this is built-in as far as I understand. For text field in general, I will try to see if I can implement something like your suggestion.
Quan

Jean Louis wrote:
> +10
>
> I don't find plugin that do this, I try _query plugin but it's between 2 different filters.
> I want to search (@any of@) words in only issues description filter, for example: word1 OR word2
>
> @ go2null wrote:
> >
> > Would also like to see it for (multi-select) lists:
> > * @any of@ (replaces @is@)
> > * @none of@ (replaces @is not@)
> > * @all of@
> > * @not all of@
> > * @is empty@ (replaces @none@)
> > * @is not empty@ (replaces @any@)

--------------------------------------------------------------------------------
Update on July 24
@Jean Louis: Thank you again for your suggestion. I have implemented the two operators on the text field allowing to do boolean search within a text field, so you can search something like:

(word1 OR word 2) AND word3 AND NOT word4.

Please help me to test it here. (it is updated version of _query)

http://www.redmine.org/plugins/boolean_query

Jean Louis wrote:
> +10
>
> I don't find plugin that do this, I try _query plugin but it's between 2 different filters.
> I want to search (@any of@) words in only issues description filter, for example: word1 OR word2
>
> @ go2null wrote:
> >
> > Would also like to see it for (multi-select) lists:
> > * @any of@ (replaces @is@)
> > * @none of@ (replaces @is not@)
> > * @all of@
> > * @not all of@
> > * @is empty@ (replaces @none@)
> > * @is not empty@ (replaces @any@)

--------------------------------------------------------------------------------
Any news about this topic? We need the possibility to use and/or conditions. Also we need the possibility to filter project tags ...

A must have :)
--------------------------------------------------------------------------------
Doesn't look like there are any news on this. I'm still waiting for it, with some constantly nagging users in my back :(

BTW: I don't think that this functionality is a candidate for a plugin ... it should definitely be part of the Redmine core package.

--------------------------------------------------------------------------------
+1
--------------------------------------------------------------------------------
+1
--------------------------------------------------------------------------------
+1
--------------------------------------------------------------------------------
+1
--------------------------------------------------------------------------------
+1
--------------------------------------------------------------------------------
Hmmm - I see constantly dripping in "+1" from people who would like to have that too, but the issue is active for 5 years now w/o anybody feeling the urge to implement it.

Any hint how to draw a bit attention on this ?
--------------------------------------------------------------------------------
+1 this is so needed
--------------------------------------------------------------------------------
@Quan VN
Thank you for boolean_query plugin.
When I tested it on redmine 3.1.0, I've got a NoMethodError on 'sql_contains', so I needed to modify line 175 on query_patch2.rb as follows:
(This is just FYI, since I am not exactly sure if 3.1.0 is under support, nor how I can contribute on this plugin, such as pull request.)

<pre>
[before mod]
sql << "(" + sql_contains("#{db_table}.#{db_field}", term, match) + ")"

[after mod]
sql << "(" + "LOWER(#{db_table}.#{db_field}) LIKE '%#{self.class.connection.quote_string(term.to_s.downcase)}%'" + ")"
</pre>

Thanks.

Quan VN wrote:
> Update on July 24
> @Jean Louis: Thank you again for your suggestion. I have implemented the two operators on the text field allowing to do boolean search within a text field, so you can search something like:
>
> (word1 OR word 2) AND word3 AND NOT word4.
>
> Please help me to test it here. (it is updated version of _query)
>
> http://www.redmine.org/plugins/boolean_query
>
> Jean Louis wrote:
> > +10
> >
> > I don't find plugin that do this, I try _query plugin but it's between 2 different filters.
> > I want to search (@any of@) words in only issues description filter, for example: word1 OR word2
> >
> > @ go2null wrote:
> > >
> > > Would also like to see it for (multi-select) lists:
> > > * @any of@ (replaces @is@)
> > > * @none of@ (replaces @is not@)
> > > * @all of@
> > > * @not all of@
> > > * @is empty@ (replaces @none@)
> > > * @is not empty@ (replaces @any@)
--------------------------------------------------------------------------------
Just an additional opinion:

Creating some plugin is nice, but I presume that plugins are a measure for very special problems like interfacing to other software and tasks not close to Redmine's core functionality. Unfortunately then features requested here affect (tune up ? dope ? ;-) a very core part of Redmine, and I'd prefer them to be realized where they belong: In the core of Redmine.

Besides of that plugins tend to get unsupported with time moving on, and every new Redmine release bears the risk of breaking the plugin. I wouldn't recommend to expose such a core-near feature to that vulnerability.
--------------------------------------------------------------------------------
+1

Could not create a simple "Issues created or closed today" query without OR!
--------------------------------------------------------------------------------
+1 :}
--------------------------------------------------------------------------------


related_issues

relates,New,1140,Filtering using more than one instance of each field
relates,New,4939,List of tasks filtered as OR and not AND
relates,New,13635,Filtering issues by comparing two custom fields against each other
duplicates,Closed,23216,Issues List, Enhanced Filtering - Allowing Multiple Queries & "OR"-type constraints

Admin Redmine さんが7ヶ月前に更新

  • カテゴリIssues filter_56 にセット

他の形式にエクスポート: Atom PDF

いいね!0
いいね!0