Fisheye: Tag 1.4.26.1 refers to a dead (removed) revision in file `openacs-4/packages/acs-service-contract/www/index-oracle.xql'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag 1.4.26.1 refers to a dead (removed) revision in file `openacs-4/packages/acs-service-contract/www/index-postgresql.xql'. Fisheye: No comparison available. Pass `N' to diff? Index: openacs-4/packages/acs-service-contract/www/index.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-service-contract/www/index.tcl,v diff -u -r1.11.2.2 -r1.11.2.3 --- openacs-4/packages/acs-service-contract/www/index.tcl 19 Dec 2019 16:02:30 -0000 1.11.2.2 +++ openacs-4/packages/acs-service-contract/www/index.tcl 2 Jan 2020 18:13:02 -0000 1.11.2.3 @@ -29,7 +29,23 @@ -db_multirow valid_installed_bindings valid_installed_binding {} +db_multirow valid_installed_bindings valid_installed_binding { + select q.* + from (select + b.contract_id, + b.impl_id, + (select contract_name from acs_sc_contracts + where contract_id = b.contract_id) as contract_name, + impl.impl_name, + impl.impl_owner_name, + impl.impl_pretty_name + from + acs_sc_bindings b, + acs_sc_impls impl + where + impl.impl_id = b.impl_id) q + order by upper(contract_name), contract_name, upper(impl_name), impl_name +} template::list::create \ -name valid_installed_bindings \