lmichel
commented
2 years ago Getting the service list
SELECT rr.interface.access_url AS url, rr.resource.short_name AS noField,rr.resource.ivoid AS ivoid FROM rr.resource
JOIN rr.capability ON ( rr.resource.ivoid=rr.capability.ivoid )
JOIN rr.interface ON ( rr.capability.ivoid=rr.interface.ivoid AND rr.capability.cap_index=rr.interface.cap_index )
WHERE ( ( UPPER(rr.resource.res_title) LIKE '%VIZIER%' OR UPPER(rr.resource.ivoid) LIKE '%VIZIER%' OR UPPER(rr.resource.short_name) not LIKE '%VIZIER%' ) ) AND
( ( rr.capability.standard_id='ivo://ivoa.net/std/tap' ) ) AND
( ( (rr.interface.intf_type = 'vs:paramhttp') ) )
This is the pace where to aggeagate all connection issues we got. No action required