Vote #64849
未完了More criteria for filtering tickets 'text' fields
0%
説明
When filtering tickets 'text' fields, I mean builtin 'text' fields like 'title' AND also 'text' custom fields, you can choose between :
- 'is'
- 'contains'
- 'is not'
- 'doesn't contain'
It will be nice if you add new choices :
- 'regex'(this one should be very very useful)
- 'is empty'
- 'is not empty'
journals
Is there a workaround to filter a text field with a criteria 'is empty' or 'is not empty' ?
--------------------------------------------------------------------------------
"is not" and "does not contain" could be better solved with a general "not" operator, that could added to every operator no matter the data type...
--------------------------------------------------------------------------------
Browsing sources, I found a workaround : Countains '_'
In SQL, it becomes :
<pre>
... LIKE %_%...
</pre>
which means "contains something".
--------------------------------------------------------------------------------
+1. This is very useful.
--------------------------------------------------------------------------------
related_issues
relates,New,3040,Extend filter on subject field
relates,Closed,4815,More criteria for filtering tickets