Index: openacs-4/packages/bug-tracker/www/admin/versions.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/www/admin/versions.xql,v diff -u -N -r1.2 -r1.3 --- openacs-4/packages/bug-tracker/www/admin/versions.xql 14 Jun 2018 13:21:19 -0000 1.2 +++ openacs-4/packages/bug-tracker/www/admin/versions.xql 14 Jun 2018 14:31:46 -0000 1.3 @@ -10,20 +10,15 @@ v.actual_freeze_date, v.anticipated_release_date, v.maintainer, - u.first_names as maintainer_first_names, - u.last_name as maintainer_last_name, - u.email as maintainer_email, v.supported_platforms, v.active_version_p, v.assignable_p, - case when v.assignable_p = 't' then 'Yes' else 'No' end as assignable_p_pretty, (select count(*) from bt_bugs b where b.found_in_version = v.version_id or b.fix_for_version = v.version_id or b.fixed_in_version = v.version_id) as num_bugs - from bt_versions v left outer join - cc_users u on (u.user_id = v.maintainer) + from bt_versions v where v.project_id = :package_id and v.active_version_p = 't' and v.actual_release_date is null @@ -40,20 +35,15 @@ v.actual_freeze_date, v.anticipated_release_date, v.maintainer, - u.first_names as maintainer_first_names, - u.last_name as maintainer_last_name, - u.email as maintainer_email, v.supported_platforms, v.active_version_p, v.assignable_p, - case when v.assignable_p = 't' then 'Yes' else 'No' end as assignable_p_pretty, (select count(*) from bt_bugs b where b.found_in_version = v.version_id or b.fix_for_version = v.version_id or b.fixed_in_version = v.version_id) as num_bugs - from bt_versions v left outer join - cc_users u on (u.user_id = v.maintainer) + from bt_versions v where v.project_id = :package_id and v.actual_release_date is null and v.active_version_p = 'f' @@ -73,20 +63,15 @@ v.anticipated_release_date, v.actual_release_date, v.maintainer, - u.first_names as maintainer_first_names, - u.last_name as maintainer_last_name, - u.email as maintainer_email, v.supported_platforms, v.active_version_p, v.assignable_p, - case when v.assignable_p = 't' then 'Yes' else 'No' end as assignable_p_pretty, (select count(*) from bt_bugs b where b.found_in_version = v.version_id or b.fix_for_version = v.version_id or b.fixed_in_version = v.version_id) as num_bugs - from bt_versions v left outer join - cc_users u on (u.user_id = v.maintainer) + from bt_versions v where v.project_id = :package_id and v.actual_release_date is not null order by v.actual_release_date, version_name