Redmine

<?xml version="1.0" encoding="UTF-8"?>

<projectDescription>

	<name>Redmine</name>

	<comment></comment>

	<projects>

	</projects>

	<buildSpec>

	</buildSpec>

	<natures>

	</natures>

</projectDescription>

    @available_filters["relation_blocked_issues"] = { :type => :integer, :order => 51 }

    @available_filters["relation_blocking_issues"] = { :type => :integer, :order => 52 }

    @available_filters["relation_preceded_issues"] = { :type => :integer, :order => 53 }

    @available_filters["relation_preceding_issues"] = { :type => :integer, :order => 54 }

      elsif field =~ /^relation_/

        v = "1" if operator == "*"

        operator = ">=" if operator == "*"

        operator = "!*" if operator == "=" && v == 0

        count_operator = "=" if operator == "="

        count_operator = ">=" if operator == ">="

        count_operator = ">" if operator == "<="

        sql << (operator == ">=" || operator == "=" ? "#{Issue.table_name}.id IN (" : "#{Issue.table_name}.id NOT IN (")

        sql << (field =~ /ed_issues$/ ? "SELECT ir.issue_to_id" : "SELECT ir.issue_from_id")

        sql << " FROM issue_relations AS ir"

        sql << " LEFT OUTER JOIN issues AS i2 ON ir.issue_from_id = i2.id"

        sql << " LEFT OUTER JOIN issue_statuses AS is2 ON i2.status_id = is2.id"

        sql << (field =~ /^relation_block/ ? " WHERE ir.relation_type='blocks'" : " WHERE ir.relation_type='precedes'")

        sql << " AND is2.is_closed = FALSE"

        sql << " GROUP BY ir.issue_to_id HAVING COUNT(*) #{count_operator} #{v}" unless operator == "!*" 

        sql << ")"

  field_relation_blocked_issues: Blocked by open issues

  field_relation_blocking_issues: Blocking other issues

  field_relation_preceded_issues: Preceded by open issues

  field_relation_preceding_issues: Preceding other issues