Here is the SQL for "subtasks_depth" filter:

<pre><code class="ruby">
def sql_for_subtasks_depth_field(field, operator, value)
case operator
when "*"
return
when "!*"
"(SELECT (COUNT(parents.id) - 1) FROM #{Issue.table_name} AS parents WHERE #{Issue.table_name}.lft BETWEEN parents.lft AND parents.rgt AND #{Issue.table_name}.root_id = parents.root_id) = 0"
when "><"
depth_from = value.first.to_i || 0
depth_to = value.last.to_i || 0
if depth_from > 0
depth_from = depth_from -1
end
if depth_to > 0
depth_to = depth_to -1
end
"(SELECT (COUNT(parents.id) - 1) FROM #{Issue.table_name} AS parents WHERE #{Issue.table_name}.lft BETWEEN parents.lft AND parents.rgt AND #{Issue.table_name}.root_id = parents.root_id) BETWEEN " + depth_from.to_s + " AND " + depth_to.to_s
else
depth = value.last.to_i || 0
if depth > 0
depth = depth -1
end
"(SELECT (COUNT(parents.id) - 1) FROM #{Issue.table_name} AS parents WHERE #{Issue.table_name}.lft BETWEEN parents.lft AND parents.rgt AND #{Issue.table_name}.root_id = parents.root_id) " + operator + " " + depth.to_s
end
end
</code></pre>
--------------------------------------------------------------------------------
Is there a chance to add this in one of the 3.1.x release?
--------------------------------------------------------------------------------
Sebastian Paluch wrote:
> Is there a chance to add this in one of the 3.1.x release?

Please post by patch and add tests.
--------------------------------------------------------------------------------
+1
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
Toshi MARUYAMA wrote:
> Please post by patch and add tests.
I would but unfortunately I don't know how to add tests :/

--------------------------------------------------------------------------------
Sebastian Paluch wrote:
> Toshi MARUYAMA wrote:
> > Please post by patch and add tests.
> I would but unfortunately I don't know how to add tests :/

source:trunk/test
--------------------------------------------------------------------------------
+1
--------------------------------------------------------------------------------