Tal Nisan has uploaded a new change for review. Change subject: core: When ISO domain is attached to multiple DCs it appears multiple times ......................................................................
core: When ISO domain is attached to multiple DCs it appears multiple times In the storage main tab, when an ISO domain is attached to multipe data center, it appears in the list one time for each data centers Change-Id: I0b874fc33c660af29c2e20a15898444db12f6f6b Signed-off-by: Tal Nisan <tni...@redhat.com> Bug-Url: https://bugzilla.redhat.com/1150525 --- M packaging/dbscripts/create_views.sql 1 file changed, 8 insertions(+), 4 deletions(-) git pull ssh://gerrit.ovirt.org:29418/ovirt-engine refs/changes/84/34784/1 diff --git a/packaging/dbscripts/create_views.sql b/packaging/dbscripts/create_views.sql index 82d15b0..2e66f68 100644 --- a/packaging/dbscripts/create_views.sql +++ b/packaging/dbscripts/create_views.sql @@ -346,7 +346,8 @@ WHEN status_table.is_multi_domain THEN NULL WHEN status_table.status IS NULL THEN 2 -- in case domain is unattached ELSE status_table.status END as status, - status_table.storage_pool_id as storage_pool_id, storage_pool.name as storage_pool_name, + null::uuid as storage_pool_id, + status_table.pool_names AS storage_pool_name, storage_domain_dynamic.available_disk_size as available_disk_size, storage_domain_dynamic.used_disk_size as used_disk_size, fn_get_disk_commited_value_by_storage(storage_domain_static.id) as commited_disk_size, @@ -359,10 +360,13 @@ INNER JOIN storage_domain_dynamic ON storage_domain_static.id = storage_domain_dynamic.id LEFT OUTER JOIN - (SELECT storage_pool_id,storage_id, count(storage_id) > 1 as is_multi_domain, max(status) AS status + (SELECT storage_id, + count(storage_id) > 1 AS is_multi_domain, + max(storage_pool_iso_map.status) AS status, + array_to_string(array_agg(storage_pool.name), ',') AS pool_names FROM storage_pool_iso_map - GROUP BY storage_id, storage_pool_id) AS status_table ON storage_domain_static.id=status_table.storage_id -LEFT OUTER JOIN storage_pool ON status_table.storage_pool_id = storage_pool.id + JOIN storage_pool ON storage_pool_iso_map.storage_pool_id = storage_pool.id + GROUP BY storage_id) AS status_table ON storage_domain_static.id=status_table.storage_id LEFT OUTER JOIN (SELECT DISTINCT storage_domain_id FROM unregistered_ovf_of_entities) AS unregistered_entities ON unregistered_entities.storage_domain_id = storage_domain_static.id; -- To view, visit http://gerrit.ovirt.org/34784 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: newchange Gerrit-Change-Id: I0b874fc33c660af29c2e20a15898444db12f6f6b Gerrit-PatchSet: 1 Gerrit-Project: ovirt-engine Gerrit-Branch: ovirt-engine-3.5 Gerrit-Owner: Tal Nisan <tni...@redhat.com> _______________________________________________ Engine-patches mailing list Engine-patches@ovirt.org http://lists.ovirt.org/mailman/listinfo/engine-patches
